How Translated Balances Are Deleted
You can rerun the translation process if you change rates or post additional journal entries. However, some accounting configuration changes require that you delete all previously translated balances, rebuild the balances cube, and rerun translation after making the changes.
If the changes listed in the following table are required after already translating, you must run the Delete Translated Balances process. The following table lists the type of change and whether all translated periods, balancing segment values, and related balance level reporting currencies are affected.
Type of Change |
Affects All Translated Periods? |
Affects All Translated Balancing Segment Values? |
Affects All Related Balance Level Reporting Currencies of the Ledger? |
---|---|---|---|
Translation rules |
Yes |
Yes |
No, can be specified for each balance level reporting currency. |
Period End and Period Average translation rate types |
Yes |
Yes |
No, can be specified for each balance level reporting currency. |
Cumulative translation adjustment (CTA) account |
Yes |
Yes |
Yes |
Retained earnings account |
Yes |
Yes |
Yes |
Initial translation period |
Yes |
Yes |
No, can be specified for each balance level reporting currency. |
Account type classification for natural account segment values |
Yes |
Yes |
Yes |
When making any of these changes, consider whether other areas are impacted. For example:
-
Reports may have been based on translated balances.
-
Translated balances could have been used as a source in previous balance transfers.
-
A primary ledger may have journal or subledger level reporting currencies associated with it.
-
A related secondary ledger may have balance level reporting currencies.
How Translated Balances Are Deleted
When you submit the process from the Scheduled Processes page, you must provide values for the following parameters:
-
Ledger: Select the ledger for the reporting currency.
-
Target Currency: Select the currency.
-
From Accounting Period: Select the earliest period for which balances must be deleted
The To Accounting Period parameter is display-only and represents the last translated period for the selected ledger and target currency.
The process deletes translated balances for all translated balancing segment values from the specified period to the last translated period. You can view the log file for the list of periods processed. After the process completes, you must run the Create General Ledger Balances Cube process to ensure that the balances cube maintains translated balances that are consistent with future translations.
Contact your Oracle Support team for assistance before initiating the Create General Ledger Balances Cube process.
Running the Delete Translated Balances process is only one aspect of making the changes listed in the previous table. The following table describes the required steps for each type of change.
Type of Change |
Steps |
---|---|
Translation rule |
|
Translation rate type |
|
CTA account |
|
Retained earnings account |
Before deleting translated balances, follow the steps documented in the FAQ on changing retained earnings accounts.
|
Initial translation period |
|
Account type classification for natural account segment values |
Before deleting translated balances, follow the steps documented in the topic Correcting Misclassified Accounts: Explained.
|