You can optionally choose to track entered currency balances that have been entered using the ledger currency separately from balances that have been converted to the ledger currency.
If you are upgrading Oracle General Ledger from Release 11.5.10, you can optionally choose to track entered ledger currency balances separately from converted ledger currency balances. This enables you to view account balances that were entered using your ledger currency separately from those foreign currency entered amounts that were converted to your ledger currency.
For example, assume your ledger currency is USD; the currency that has been assigned to your ledger. Assume you enter the journals below. The first journal is entered using the ledger currency and the last two journals are entered using foreign currencies, CAD and EUR, respectively.
| USD Entered Amounts | ||
|---|---|---|
| Account | Debit | Credit |
| 01.110.6110 | 1000.00 | |
| 01.000.2110 | 1000.00 |
| CAD Entered Amounts | USD Converted Amounts | |||
|---|---|---|---|---|
| Account | Debit | Credit | Debit | Credit |
| 01.110.6110 | 1500.00 | 1233.00 | ||
| 01.000.2110 | 1500.00 | 1233.00 |
| EUR Entered Amounts | USD Converted Amounts | |||
|---|---|---|---|---|
| Account | Debit | Credit | Debit | Credit |
| 01.110.6110 | 1000.00 | 1294.00 | ||
| 01.000.2110 | 1000.00 | 1294.00 |
If you choose to track your entered ledger currency balances separately from the balances that have been converted to your ledger currency, the following balances would be maintained for the following accounts.
Choosing to view account balances that were entered using your ledger currency would retrieve the following balances.
| USD Entered Ledger Currency Balances | ||
|---|---|---|
| Account | Debit | Credit |
| 01.110.6110 | 1000.00 | |
| 01.000.2110 | 1000.00 |
Any foreign currency amounts that were converted to the ledger currency are ignored in this query.
Note: If you do not choose to track your entered and converted ledger currency balances separately, then you would not be able to obtain this view of your account balances.
Choosing to view all balances by your ledger currency would retrieve the following balances:
| USD Converted Ledger Currency Balances | ||
|---|---|---|
| Account | Debit | Credit |
| 01.110.6110 | 3527.00 | |
| 01.000.2110 | 3527.00 |
These amounts include all amounts that were entered using the ledger currency as well as foreign currency amounts that were converted to your ledger currency.
To upgrade your balances to track balances entered in your ledger currency separately from balances converted to your ledger currency, you must run the Generate Upgrade for Balances Entered in Ledger Currency program. This program automatically launches the following child requests:
Upgrade Balances Entered in Ledger Currency: This program upgrades all balances to enable you to track entered ledger currency balances separately from converted ledger currency balances.
Upgrade Balances Moved by Mass Maintenance: This program upgrades all balances in the interim move/merge tables that were created using Mass Maintenance. This program ensures that all interim tables are properly upgraded in the event that you reverse the move/merge after upgrade.
When you run the Generate Upgrade for Balances Entered in Ledger Currency program, you must specify the following parameters:
Number of Accounts to Process Per Batch: Determines the number of account combinations to process at a time.
The default value is 1000. This means that each worker will process 1000 account combinations at a time when upgrading balances.
Number of Upgrade Workers: Allows multiple upgrade processes to run in parallel to speed processing when you have large volumes of balances to upgrade. If one upgrade process fails due to an error, the other processes will continue.
Specify a number equal to the number of processes you want to run at the same time. The default value is 2, and one worker is always required for the Upgrade Balances Moved by Mass Maintenance program. You can change the default to a higher number to have additional workers submitted for the Upgrade Balances Entered in Ledger Currency program.
For example, if you enter 10 for the Number of Upgrade Workers, then nine programs will be submitted for the Upgrade Balances Entered in Ledger Currency program and one program will be reserved for the Upgrade Balances Moved by Mass Maintenance program.
Note: You can run the Generate Upgrade for Balances Entered in Ledger Currency program at any time after you upgrade from Release 11i.
Note: If you do not run this program, you will not be able to take advantage of the Entered Ledger Currency Balances feature. When you view account balances, you will not be able to view those balances that were entered using the ledger currency.