Period Parameter for Trial Balance - Translation Report Does Not Have Any Values Even Though Translation Was Run

(Doc ID 1664993.1)

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms