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:
Oracle General Ledger - Version 12.0.0 and laterInformation in this document applies to any platform.
GLPPOSS: Posting: Single Ledger
GLAMAS: MassAllocation
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
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 |