Patch: 7303030 - R12.1: ORA-04063: package body "APPS.HR_SECURITY" has errors
VPC Team member opened this thread on behalf of the customer.
================================
In the process of upgrade from 12.0.6 to 12.1.1,
As per ID 1174964.1 , Patch 8940461 was applied later after main patch but the issue is there.
payusbalfeedsupd.sql
[ERROR at line 1:
ORA-04063: package body "APPS.HR_SECURITY" has errors
ORA-06512: at line]
######################
#sqlplus -s APPS/***** @/uora/RPT/apps/apps_st/appl/ap/12.0.0/patch/115/sql/apstca01.sql &un_ap &batchsize 5 12
#DECLARE
#*
#ERROR at line 1:
#ORA-04063: package body "APPS.HR_SECURITY" has errors
#ORA-06512: at line 60
######################
================================
/* $Header: hrscsec.pkh 120.2.12010000.1 2008/07/28 03:46:12 appldev ship $ */
/* $Header: hrscsec.pkb 120.5.12010000.3.1201030.2 2012/06/08 06:35:47 ghshanka ship $ */
================================
SQL> @hrscsec.pkh
Package created.
Commit complete.
SQL> show error