Shortcut Keys in Oracle EBS Forms

Function Shortcut Key
Show Shortcut Keys Ctrl + K
Enter Query F11
Execute Query Ctrl + F11
Count Query F12
Clear Block F7
Clear Field F5
Clear Form F8
Clear Record F6
Edit Ctrl + E
Update Record Ctrl + U
Insert Record Ctrl + Down
Delete Record Ctrl + Up
Commit Ctrl + S
Duplicate Field Shift + F5
Duplicate Record Shift + F6
List of values Ctrl + L
List Tab Pages F2
Next Field Tab
Next Record Down Arrow Key
Next Primary Key Shift + F7
Next Set of Records Shift + F8
Previous Field Shift + Tab
Previous Record Up Arrow Key
Previous Block Shift+PageUp
Scroll Down PageDown
Scroll Up PageUp
Up Up Arrow Key
Down Down Arrow Key
Print Ctrl + P
Exit F4
Help Ctrl + H
Block Menu Ctrl + B
Display Error Shift + Ctrl + E

 

 

Reference# https://wordpress.com/read/post/id/877876/67

Advertisements

Difference between Conversion / Revaluation / Translation

Three key foreign currency concepts in Oracle GL are

  • Conversion
  • Revaluation
  • Translation
Conversion:
It refers to foreign currency transactions that are immediately converted at the time of entry to the ledger currency of the ledger in which transaction takes place.
Revaluation:
Revaluation adjusts liability or asset accounts that may be materially understated or overstated at the end of a period due to a fluctuation in the exchange rate between the time the transaction was entered and the end of the period
Translation:
Translation refers to the act of restating an entire ledger or balances for a company from the ledger currency to a foreign currency.
Reference# http://orclapp.blogspot.in/2012/08/gl-difference-between-conversion.html

Revaluation

Revaluation reflects changes in conversion rates between the date of journal entry and the date of receipt/payment of the foreign currency amount. General Ledger posts the change in converted balances against the unrealized gain/loss account you specify.”

“When you revalue balances in an average balance set of books, General Ledger only revalues standard balances. When you post the revaluation journal entries to update your standard balances, the system will recompute your average balances automatically.”

 

Summary: When you run revaluation, a journal entry is created that either increases or decreases the functional currency amount for that account, based on the fluctuation of the exchange rate. The resulting gain or loss amounts are posted to Gain/Loss or Cumulative Translation Adjustment account you specify. This process creates a revaluation batch containing separate journal entries for each revalued foreign currency.

 

The revaluation adjustment is created in your functional currency, this is where the fluctuation is. The foreign currency of the transaction will stay the same, it is the functional currency balance that is adjusted.

 

Setups Considered:

Define an unrealized gain/loss account.

Define a revaluation rate for each currency for each period for which you want to run revaluation.

 

 

Reference#https://docs.oracle.com/cd/A60725_05/html/comnls/us/gl/revalue.htm

 

Issue:
Exception Name: oracle.apps.bne.exception.BneFatalException
Cause: Line 85 – Programmatic access to Visual Basic Project is not trusted
Action: A runtime has occurred. Please contact your support representative.
Log File Bookmark: 12176

Solution:
Please verify if you have below setup in place for macros:
Go to >Excel options>trust centre settings>macro settings>Enable all macros