R12.1.1 Maintenance Pack Patch 7303030 Failing Apstca01.sql (Doc ID 1610623.1)

Last updated on MARCH 09, 2016

Applies to:

Oracle Payables - Version 12.0.6 and later
Information in this document applies to any platform.
Reported Issue :
===========
DB upgraded from 10.2.0.4 to 11.2.0.3 and migrated from Sun OS to Linux
APPS upgrading from 12.0.6 to 12.1.1 is failing with following Error

Start time for file is: Sat Dec 21 2013 07:36:00

sqlplus -s APPS/***** @/u01/dev/devappl/apps/apps_st/appl/ap/12.0.0/patch/115/sql/apstca01.sql &un_ap &batchsize 2 16
DECLARE
*
ERROR at line 1:
ORA-04063: package body "APPS.HR_SECURITY" has errors
ORA-06512: at line 60


If i tried compiling the APPS.HR_SECURITY manually its failing with the following error
SQL> alter package apps.HR_SECURITY compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY APPS.HR_SECURITY:

LINE/COL ERROR
-------- -----------------------------------------------------------------
155/13 PLS-00323: subprogram or cursor 'IS_USER_RTM' is declared in a
package specification and must be defined in the package body

Symptoms

On : 12.0.6 version, Install Patching & Upgrade issues

ACTUAL BEHAVIOR
---------------
During the upgrade from 12.0.6 to 12.1.1.Running upgrade patch 7303030 ( 12.1.1 Maintenance Pack )
and getting error on apstca01.sql

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply patch 7303030 ( 12.1.1 Maintenance Pack )

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete the upgrade.

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