Period Parameter for Trial Balance - Translation Report Does Not Have Any Values Even Though Translation Was Run
Last updated on MARCH 08, 2017
Applies to:Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
Translation was run for the first time for a ledger, for the USD currency.
The Translation completed successfully, but when attempting to run the Translation Trial Balance, there are no values for the Period parameter.
A query of gl_ledger_relationships shows there are 2 rows for the USD reporting currency.
One row (with relationship_id 1234) has -1 for all of the ledger_id fields (source_ledger_id, target_ledger_id, sla_ledger_id, primary_ledger_id).
One row (with relationship_id 5678) has the correct value for all of the ledger_id fields.
Only one reporting currency is seen in Accounting Setup Manager.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms