My Oracle Support Banner

Period Parameter for Trial Balance - Translation Report Does Not Have Any Values Even Though Translation Was Run (Doc ID 1664993.1)

Last updated on FEBRUARY 28, 2019

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.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.