My Oracle Support Banner

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.


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.


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.


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


ADB-S Database on OCI


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

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