R12: AP: Payables SLA On Demand Upgrade Child Process, Ends In Error: ORA-20001 And ORA-06512
(Doc ID 1505133.1)
Last updated on JANUARY 03, 2023
Applies to:
Oracle Payables - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Running Upgrade Historical Subledger Transaction Accounting concurrent ends in errors.
1) APXLASUB module: Payables SLA On Demand Upgrade Child Process ends in Errors:
Cause: FDPSTP failed due to ORA-20001:
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.AP_XLA_UPGRADE_PKG", line 2404
ORA-06512: at line 1
.
The SQL statement being executed at the time of the error was: an
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Inside SLA On Demand Upgrade Subworker
AP_XLA_UPGRADE_SUBWORKER(+)
Starting at 17:18:01
Invoices: p_start_rowid:AAFHm1AKHAAAz0JAAA p_end_rowid:AAFHm1AKHAAAz2ICcP
Error: -1: ORA-00001: unique constraint (XLA.XLA_DISTRIBUTION_LINKS_U1)
violated
2) Log of XLAONDEUPG module: Upgrade Historical Subledger Transaction Accounting has also errors:
*End date : 01-JAN-12
*Periods updated to P for ledger_id: X are : 1
*Periods updated to P for ledger_id: Y are : 1
*Return code from ZX: 0
AP_XLA_UPGRADE_ONDEMAND(+)
Starting at 17:18:00
Number of workers 1
New script name for invoices apidstln.sql10001
New script name for payments appdstln.sql10001
Submitting concurrent request for worker 1
Inside Loop for checking the child request status
Error in procedure AP_XLA_UPGRADE_SUBWORKER
*Return code from AP: 2
*Migration status code Updated to NULL for ledger_id : 1 are : 0
*Migration status code Updated to NULL for ledger_id : 2 are : 1
*Migration status code Updated to NULL for ledger_id : 23 are : 1
Error in procedure AP_XLA_UPGRADE_SUBWORKER
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 |
Cause |
Solution |
References |