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 laterInformation 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 |