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

Note: 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.

Caution: 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	Run the Delete Translated Balances process and after the process completes, rebuild the balances cube. On the Edit Balance Level Reporting Currency page, select the correct translation rule. Rerun the translation process.
Translation rate type	Run the Delete Translated Balances process and after the process completes, rebuild the balances cube. On the Edit Balance Level Reporting Currency page, select the correct rate types. Rerun the translation process.
CTA account	Run the Delete Translated Balances process and after the process completes, rebuild the balances cube. On the Specify Ledger Options page, edit the Cumulative Translation Adjustment Account value. Rerun the translation process.
Retained earnings account	Before deleting translated balances, follow the steps documented in the FAQ on changing retained earnings accounts. Run the Delete Translated Balances process and after the process completes, rebuild the balances cube. Rerun the translation process.
Initial translation period	Run the Delete Translated Balances process and after the process completes, rebuild the balances cube. Rerun the translation process using the new 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. Run the Delete Translated Balances process and after the process completes, rebuild the balances cube. Rerun the translation process.