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.


On : 9.2 version, Journal / Ledger Inquiry

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

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.

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.

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


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