EAP: Voucher Budget Checking, FS_BP, Abends at Step FS_BP_PROC.uLStatus.SetUnst (Action SQL) -- RC = 1031. SQL Error: ORA-01031:Insufficient Privileges in An ADB-S DATABASE on OCI
(Doc ID 2992536.1)
Last updated on DECEMBER 13, 2023
Applies to:
PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Symptoms
Voucher Budget Checking, FS_BP, is failing when run against an ADB-S database on OCI. PeopleSoft delivered FS_BP_PROC Engine code contains "alter session ..." commands which are not allowed in an ADB-Shared environment. This delivered PeopleSoft App Engine program is not compatible with ADB-Shared.
ERROR
-----------------------
SQL error. Stmt #: 1738 Error Position: 0 Return: 1031 - ORA-01031: insufficient privileges
Failed SQL stmt: ALTER SESSION SET "_unnest_subquery"= TRUE
Process 18371727 ABENDED at Step FS_BP_PROC.uLStatus.SetUnst (SQL) -- RC = 1031 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
DoMessageLogError [1134] Exception logged: RC=8.
SQL Error: ORA-01031: insufficient privileges
CommonMain [1731] Exception logged: RC=8.
STEPS
-----------------------
1. Add multiple vouchers: Accounts Payable > Vouchers > Add/Update > Regular Entry > Business Unit = US005
2. Budget Check: Accounts payable > Batch processes > Vouchers > Budget Check
a. Process Requests = AP_VOUCHER, AP_ACCT_LN, AP_VCHR_NP, AP_ACCTDSE
b. Box checked for Process All Business Units for all requests
3. Process ends in No Success
Changes
ADB-S Database on OCI
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 |