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 JULY 16, 2018

Applies to:

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


On : 12.1.3 version, Accounting related

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


EXCEPTION OTHERS in Load_ap_misc_data ORA-12801: error signaled in parallel query server P000, instance (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


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

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