Posting Errors in glpubr: ORA-12801: error signaled in parallel query server
(Doc ID 2650244.1)
Last updated on FEBRUARY 06, 2023
Applies to:
Oracle General Ledger - Version 11.5.10.0 and laterInformation in this document applies to any platform.
GLPPOS module: Posting
Symptoms
Posting errors with these details in the logfile - see below.
Other GL programs work fine, including Open/Close periods or other programs affecting gl balances.
ERROR
GLPPOS module: Posting
>> glpubr() 17-FEB-2020 12:07:11
>> glpubr.concurrency() 17-FEB-2020 12:07:11
<< glpubr.concurrency() 17-FEB-2020 12:07:11
SHRD0030: glpubr() encountered an error returning from errexit:
>> gluerr() 17-FEB-2020 12:07:12
Error in ROUTINE: glpubr, status: 0
SHRD0043: ERROR:
***************************************************
sqlcaid: sqlabc: 0 sqlcode: -12801 sqlerrml: 70
sqlerrmc:
ORA-12801: error signaled in parallel query server [..]
ORA-01502: ind
sqlerrp: sqlerrd: 0 0 0 0 0 0
sqlwarn: sqltext:
*****************************************************
SHRD0044: Process logging off database and exiting ...
<< glpddi() 17-FEB-2020 12:07:13
PPOS0002: Posting terminated with fatal errors
STEPS
The issue can be reproduced at will with the following steps:
1. Gl responsibility > Post
2. Observe the error in the log file
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 |