My Oracle Support Banner

EGL9.2: A SQL Error Occurred When Attempting to Drill to Source on the GL Reconciliation Inquiry. (Doc ID 2002146.1)

Last updated on OCTOBER 03, 2018

Applies to:

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

Symptoms

Issue:
-------

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 to Replicate:
---------------------

  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.



Cause

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
Symptoms
Cause
Solution
References


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