GLTRBALD Trial Balance - Detail" Report Errors With REP-1416 When a Specific Accounting Flexfield Segment Is Used In The Parameters. (Doc ID 2987905.1)

Last updated on NOVEMBER 21, 2023

Applies to:

Symptoms

After upgrade from 12.0.6 to 12.2.12, an error is seen in the log file of the Trial Balance - Detail report when it is run.

REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1416: MSG-00123: NVL(GLB.TRANSLATED_FLAG,'x') != 'R' AND GLB.CURRENCY_CODE='XXX'  -- XXX is the currency code such as 'USD'.
REP-1416: 'pagebreak_value_dsp_2formula': User exit 'FND'. APP-FND-01618: Column :PAGEBREAK_VALUE_DSP_2 not found

STEPS TO REPRODUCE THE ISSUE
-----------------------------------------
1) Using a General ledger Responsibility.
2) Navigate to Reports -> Request -> Standard
3) Select the Trial Balance - Detail report. Populate the required parameters and submit.
4) Note the that concurrent request ends in error and the log shows the error noted above.

While on 12.0.6 the solution for a similar issue was seen and resolved with a patch provided in note:
R12 "Trial Balance - Detail" Report (GLTRBALD) Errors With REP-1416: 'pagebreak_value_dsp_2formula' And Column :PAGEBREAK_VALUE_DSP_2 not found (Doc ID 1338672.1)
This issue has returned after upgrade to 12.2.12.

The accounting flexfield has been compiled and there are no invalid General Ledger objects on the instance.
The issue is seen in all languages, not only English. The issue is specific seen when run for a specific segment value when run for other segment values it completes without the error.

Changes

 Upgrade from 12.0.6 to 12.2.12.

Cause

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