My Oracle Support Banner

EGL 9.2: Ledger Inquiry SQL error in Exec. (2,280) INQ_CRIT_WRK.PB_SEARCH.FieldFormula Name:PopulateTotalScroll_2 PCPC:3007 Statement:51 (Doc ID 2644067.1)

Last updated on JULY 06, 2020

Applies to:

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

Symptoms


When attempting to go to Activity from Ledger Inquiry, the following error occurs.

ERROR

SQL error in Exec. (2,280) INQ_CRIT_WRK.PB_SEARCH.FieldFormula Name:PopulateTotalScroll_2 PCPC:3007 Statement:51
Called from:INQ_CRIT_WRK.INQ_ACT_DRL_LNK.FieldChange Name:DrillFromSummary Statement:15
Called from:INQ_CRIT_WRK.INQ_ACT_DRL_LNK.FieldChange Statement:165
During the execution of SQL, an error occurred in the Exec subroutine


Steps to Replicate

1. Apply <bug 30181067>
2. No ChartField Security setup
3. Enter Ledger Inquiry parameters
   - Ensure Show Transaction Details is selected
4. Click on Activity link from result

See replication document attached




Changes

 

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
Changes
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.