19c Database Upgrade: Concurrent Programs Such as Journal Posting Program / Mass Allocation Completing In Error: ORA-01031: insufficient privileges / ORA-06512: at "SYSTEM.AD_DDL" (Doc ID 2960969.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

After upgrading Oracle Database to 19c, some General Ledger programs like Posting: Single Ledger(GLPPOSS), Mass Allocations (GLAMAS) are completing with error in the logfile.

Note the issue occurs only when Database Vault is enabled.
 

ERROR

PERF0005: Oracle error detected in glpdit() - ORA-01031: insufficient privileges
ORA-06512: at "SYSTEM.AD_DDL", line
>> gluerr()
Error in ROUTINE: glpdit, status: 0
SHRD0043: ERROR: SHRD0030: glpdit() encountered an error returning from errexit

***************************************************
sqlcaid: sqlabc: 0 sqlcode: 0 sqlerrml: 0
sqlerrmc:
ORA-01031: insufficient privileges
ORA-06512: at "SYSTEM.AD_DDL", line
sqlerrp: sqlerrd: 0 0 1 0 0 0
sqlwarn: sqltext:
*****************************************************
SHRD0044: Process logging off database and exiting ...


STEPS TO REPRODUCE
1. Go to "General Ledger Responsibility -> Journals -> Enter";
2. In the "Find Journals" window, enter the batch name and press "Find" button;
3. In the "Enter Journals" window, select the journal and press "Post" button;
4. Go to "View -> Reuqest -> Find" and notice the posting program ends in error;
5. Open the log file and notice the error message.

Changes

 Upgraded the Database to 19c.

Cause

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