EGL 9.2: SQL Error in Review Financial Info > Ledger After Security Change

(Doc ID 2310975.1)

Last updated on NOVEMBER 03, 2017

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 STATEMENT
---------------
After setting up security on project, encountered an error while drilling down Activity in Ledger inquiry
 
ERROR
---------------
A fatal PeopleCode SQL error Occurred. Please consult your system log for details.
click OK and then new message:

SQL error in Exec, (2, 280) INQ_CRIT_WRK.PB_SEARCH.FieldFormula Name: Populate TotalScroll_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 occured in the Exec subroutine. The preceding message should have described the SQL being executed

STEPS
---------------
The issue can be reproduced with the following steps:
1. Go to Setup Financials/Supply Chain -> Security -> Chartfield Security -> Secure Chartfield Options and change method to user and click on project
2. Go to Setup Financials/Supply Chain -> Security -> Chartfield Security -> Maintain Security Rules -> Define Security Rules and create a rule and associate VP1 and business unit US001
3. Build the security rule
4. Go to General Ledger -> Review Financial Information -> Ledger and search. When the results come up, try to drill down in inquiry.
 
Please see attached document for printscreens.

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