R12 : GL : GLOOAP: Periods - Open Periods Program Completing With Error Ora-12801: Error Signaled in Parallel Query Server Pxxx
(Doc ID 2925120.1)
Last updated on JULY 18, 2023
Applies to:
Oracle General Ledger - Version 12.0.0 and laterInformation in this document applies to any platform.
Symptoms
When attempting to open a General Ledger(GL) accounting period, the following error occurs in the GLOOAP: Periods - Open Periods program.
ERROR
------
<x glopib: errexit()
*****************************************************
sqlcaid: sqlabc: 0 sqlcode: -12801 sqlerrml: 70
sqlerrmc:
ORA-12801: error signaled in parallel query server P002
ORA-27090: Una
sqlerrp: sqlerrd: 0 0 0 65 0 538976288
sqlwarn: sqltext:
*****************************************************
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in to GL Super user
2. Navigate to Setup > System > Open / Close
3. Enter the desired period to open and Click on open target period, GLOOAP: Periods - Open Periods program is submitted
4. Review the completion status of the program, it completes with error.
Changes
N/A
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 |