My Oracle Support Banner

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 later
Information 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


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