EGM 9.2: When Permission List Level Security Is Enabled at the Business Unit Secured Field Level, a Fatal SQL Error Occurs When Edit Filter Is Used To Add or Change a Business Unit in the CA_RATE Filter In the Grants WorkCenter
(Doc ID 2856072.1)
Last updated on JUNE 16, 2023
Applies to:
PeopleSoft Enterprise FIN Grants - Version 9.2 to 9.2 [Release 9]PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Symptoms
When Permission List Level Security is enabled at the Business Unit secured field level, a fatal SQL error displays when Edit Filter is used to add or change a business unit in the CA_RATE filter in the Grants WorkCenter.
-----------------------
A fatal PeopleCode SQL error occurred. Please consult your system log for details.
SQL error in Exec. (2,280) FS_FILTER_BUILDER.Configuration.Values.OnExecute Name:DoSaveEdit PCPC:27055 Statement:420
Called from:FSFB_FILTER_VALUES.GBL.FSFB_FLTRVALS.SaveEdit Statement:2
During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.
Replication Steps
-----------------------
1. Set Up Financials/Supply Chain > Security > Security Options and enable Permission List Level Security for Business Unit.
2. Navigate to Grants > Grants WorkCenter. Select “Edit Filters” and then, drilldown to edit the “Contract Lines Missing Rate Set/Plan” filter under Group Label “Pre Process Exceptions”.
3. Edit filter values by adding a PC Business Unit. Then, click “Apply”.
4. The system displays a fatal SQL error.
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 |