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:

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

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