SLA Hot Patch Failure (Doc ID 1595578.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Install Patching & Upgrade issue

When user ran the SLA Hot Patch the following error is retuned :
  There are now 1161 jobs remaining (current phase=A0):
  0 running, 1 ready to run and 1160 waiting.
 
  Assigned: file xlaugspe2.sql on worker 1 for product xla username XLA.
  FAILED: file xlaugspe2.sql on worker 1 for product xla username XLA.
  Deferred: file xlaugspe2.sql on worker 1 for product xla username XLA. (Deferment number 1 for this job)
  Assigned: file xlaugspe2.sql on worker 1 for product xla username XLA.
  FAILED: file xlaugspe2.sql on worker 1 for product xla username XLA.
  Deferred: file xlaugspe2.sql on worker 1 for product xla username XLA. (Deferment number 2 for this job)
  Assigned: file xlaugspe2.sql on worker 1 for product xla username XLA.
  FAILED: file xlaugspe2.sql on worker 1 for product xla username XLA.

  ATTENTION: All workers either have failed or are waiting:

  FAILED: file xlaugspe2.sql on worker 1.

  ATTENTION: Please fix the above failed worker(s) so the manager can continue.

 

Issue verified from adwork001.log file
sqlplus -s APPS/***** @/erpapp/d01/oracle/PROD/apps/apps_st/appl/xla/12.0.0/patch/115/sql/xlaugspe2.sql &un_xla
Connected.
DECLARE
*
ERROR at line 1:
ORA-20501: There is no date for the upgrade. Please enter the profile option
SLA: INITIAL DATE FOR HISTORICAL UPGRADE.
ORA-06512: at line 75

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