ORA-04063 Error Applying SLA Hot Patch - FAILED: file cstmtaupgpost.sql on worker (Doc ID 1623751.1)

Last updated on NOVEMBER 30, 2016

Applies to:

Oracle Cost Management - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Oracle Subledger Accounting - Version 12.0.0 and later
Information in this document applies to any platform.
Run the SLA Hot Patch or SLA post-upgrade process as follows:
1.Run AutoPatch with options=hotpatch.
2.Specify $XLA_TOP/patch/115/driver/xla5584908.drv when prompted for the unified driver.

Symptoms

The SLA hot patch fails with:

FAILED: file cstmtaupgpost.sql on worker 1.
FAILED: file cstmtaupgpost.sql on worker 2.
FAILED: file cstmtaupgpost.sql on worker 3.
FAILED: file cstmtaupgpost.sql on worker 4.
FAILED: file cstmtaupgpost.sql on worker 5.
FAILED: file cstmtaupgpost.sql on worker 6.
FAILED: file cstmtaupgpost.sql on worker 7.
FAILED: file cstmtaupgpost.sql on worker 8.

The adworker logs show the following error:

sqlplus -s APPS/***** @/u05/app/oracle/apps/apps_st/appl/bom/12.0.0/patch/115/sql/cstmtaupgpost.sql &un_inv &batchsize 4 8
Connected.
DECLARE
*
ERROR at line 1:
ORA-04063: package body "APPS.CST_SLA_UPDATE_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"APPS.CST_SLA_UPDATE_PKG"
ORA-06512: at line 58

Tried to manually compile the APPS.CST_SLA_UPDATE_PKG package.
Received the following error:
[Error] ORA-00942 (2191: 35): PL/SQL: ORA-00942: table or view does not exist

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