After Upgrade From R11i Cannot See RSOB and GLTRBALD Trial Balance - Detail Report Errors with MSG-00123 REP-1401 ORA-01422 REP-0069 REP-57054: In-process job terminated:Terminated with error: (Doc ID 1990896.1)

Last updated on APRIL 17, 2017

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
Report:GLTRBALD.RDF - Trial Balance - Detail

Symptoms

After the upgrade from R11i to R12, the Reporting Sets of Books in R11i are not upgraded correctly in R12.
The Set of Books in R11i was marked as Not Applicable in the Multiple Reporting Currencies tab of the SOB setup form
SQL run on the back end (table level) shows the converted set of book is classified as a Secondary Ledger.
In Accounting Setup Manager, the same Set of Books appears under the Reporting Currencies section, not under the Secondary Ledger section.
The Reporting Set of Books in question is associated with FA Tax books
When run the GLTRBALD Trial Balance - Detail report,the log file for this specific reporting/specific ledger shows the following error:

Error
------
MSG-00123: NVL(GLB.TRANSLATED_FLAG,'x') != 'R' AND GLB.CURRENCY_CODE='MXP'
REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-01422: exact fetch returns more than requested number of rows
 
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1401: MSG-00123: NVL(GLB.TRANSLATED_FLAG,'x') != 'R' AND  
GLB.CURRENCY_CODE='MXP'
REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-01422: exact fetch returns more than requested number of rows 

Cause

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