EGL9.2: A SQL Error Occurred When Attempting to Drill to Source on the GL Reconciliation Inquiry.

(Doc ID 2002146.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Journal / Ledger Inquiry

When attempting to Drill to Source on the GL Reconciliation Inquiry the following error occurs.

ERROR
-----------------------
A SQL error occurred. Please consult your system log for details.

Error in PeopleCode ScrollSelect processing. (2,213) GLRCN_INQ_WRK.DRILL_DOWN.FieldFormula Name:GetDrillData PCPC:7291 Statement:92
Called from:GLRCN_BI_DRILL.Activate Statement:1

A SQL error occurred during processing of the PeopleCode ScrollSelect (or ScrollSelectNew, RowScrollSelect, RowScrollSelectNew) built-in function.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Add a new Inquiry in General Ledger > GL Subsystem Reconciliation > GL Reconciliation Inquiry.
  2. Create a Run Control ID for Load Reconciliation Data in General Ledger > GL Subsystem Reconciliation > Load Reconciliation Data and run GL_RECN Application Engine process.
  3. Navigate General Ledger > GL Subsystem Reconciliation >GL Reconciliation Inquiry. Click 'Search' to open the 'Reconciliation Overview' page.
  4. Click on 'Detail' icon to open the “Drill to Source” page and SQL Error is displayed.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot perform GL Subsystem Reconciliation.

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