My Oracle Support Banner

R12: ORA-12801: error signaled in parallel query server P000 while Running Accrual Reconciliation Load Run (Doc ID 2228821.1)

Last updated on AUGUST 16, 2023

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
CSTACRLR module: Accrual Reconciliation Load Run

Symptoms

On : 12.1.3 version, Accounting related

When attempting to run Accrual Reconciliation Load Run,
the following error occurs.

ERROR

EXCEPTION OTHERS in Load_ap_misc_data ORA-12801: error signaled in parallel query server P000, instance gitsaepdb01.arg.ae:AEPRD1 (1)
ORA-01555: snapshot too old: rollback segment number 183 with name "_SYSSMU183_64958
Load_ap_misc_data API fails with
 x_msg_count :1
 x_msg_data :BOM


Steps to reproduce:

1. Responsibility: Purchasing
2. Navigate to: Reports > Run
3. Select Accrual Reconciliation Load Run from the List of Values

Changes

 

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


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