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

Last updated on MAY 18, 2017

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms