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



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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.