Skip to main content

Shortcut Keys in Oracle EBS

F4 -----> Exit
F5 -----> Clear Field
F6 ----->Clear Record
F7 ----->Clear Block
F8-----> Clear Form
F11-----> Query Enter
Ctrl + S-----> Commit/Save
Ctrl + L-----> List of Values
Ctrl + F11-----> Execute Query
Ctrl + E-----> Edit
Ctrl + Up ----->Delete Record
Ctrl + Down ----->Insert Record
Ctrl + P ----->Print
Ctrl + U-----> Update Record
Ctrl + B ----->Block Menu
Ctrl + K ----->Display list of Keys
Shift + F5 ----->Duplicate Field
Shift + F6-----> Duplicate Record
Shift + F8 ----->Next Set of Records (Same as Page Down)
Shift + PageDown ----->Next Block
Shift +PageUP-----> Previous Block
Shift + Tab-----> Previous Field
Shift + PageUp-----> Previous Block
Shift + Ctrl + E-----> Display Error
Page Down-----> Scroll Down (Same as Shift + F8)
PageUp -----> Scroll Up
Tab -----> Next Field
Down Arrow-----> Next Record
Up Arrow-----> Previous Record
Return-----> Return

Comments

Post a Comment

Popular posts from this blog

Oracle R12 Inventory Configuration: Key points to Avoid Mistakes

Most Oracle ERP R12 inventory problems are not system failures they are process and configuration failures. The same categories of mistakes surface repeatedly across implementations: Focusing on master data control, disciplined transactions, proper OU setup, and strong internal controls prevents operational and financial discrepancies.   This article walks through the four most critical areas where Oracle R12 inventory implementations go wrong, explains why each mistake is costly, and provides recommendations to prevent them. Each section includes the relevant navigation path and configuration screenshots for hands-on reference   1.       Improper Item Master Configuration in Oracle R12   Oracle E‑Business Suite R12 , the Item Master Configuration serves as the foundation of the Inventory module. Two critical components under this configuration umbrella are: Define Master Item Setup Define Item Status Both setups control how items ...
Post a Comment
Read more

Monitoring and Troubleshooting Oracle APEX Performance with Real-World SQL Queries

    Introduction Oracle Application Express (APEX) is one of the most widely adopted low-code development platforms in the Oracle ecosystem. As organizations scale their APEX deployments, the need for robust monitoring and troubleshooting capabilities becomes critical. This article provides SQL queries that DBAs and developers can use to monitor, diagnose, and optimize their APEX environments.   What makes monitoring APEX unique is the three-tier architecture it operates on: the Oracle Database at the data layer, APEX at the application layer, and Oracle REST Data Services (ORDS) as the middleware. Understanding how sessions flow through these three layers is the key to effective monitoring.     Architecture Overview   Layer Component Version Role Database Oracle DB 19.28 Stores data, executes SQL, manages sessions Application Oracle AP...
Post a Comment
Read more
SQL Query Performance Tuning: A Practical Approach for Oracle DBAs Inefficient queries in Oracle Database can significantly impact system performance, resulting in higher response times and decreased user productivity. By closely monitoring memory usage and CPU consumption, database administrators can identify performance bottlenecks and determine the root causes of inefficient query execution. Oracle Query Performance Tuning Checklist 1.          Monitor Memory Usage:                Purpose: Ensure optimal memory allocation to prevent excessive disk I/O and performance degradation.             Actions: * Track memory consumption using Oracle Enterprise Manager *Automatic Workload Repository (AWR) reports to review SGA and PGA utilization, and identify abnormal memory usage patterns. Analyze AWR reports for: a.   ...
Post a Comment
Read more