My Oracle Support Banner

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 later
Information 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:
 

  ORACLE error 20001 in FDPSTP
 
  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:
 

  *Start date     : 01-DEC-11
  *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


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