Tuesday, April 5, 2016

Patch Fails With Ora-20001: Updating Pa_projects_all:Ora-04063: Package

Patch Fails With Ora-20001: Updating Pa_projects_all:Ora-04063: Package 

ERROR
Patch fails with ora-20001: updating pa_projects_all:ora-04063: package
sqlplus -s APPS
sqlplus -s APPS/*****
&batchsize 1 8
DECLARE
*
ERROR at line 1:
ORA-20001: Updating pa_proj_elem_ver_structure:ORA-04063: package body
"APPS.PA_PROJ_TASK_STRUC_PUB" has errors
ORA-06512: at line 141

Cause:

The issue is the package PA_PROJ_TASK_STRUC_PUB was invalid.
*
ERROR at line 1:
ORA-04043: object PA_PROJ_TASK_STRUC_PUB does not exist

Solution:

To implement the solution, please execute the following steps:

1) Run APPSORA.env
2) Compile the package PA_PROJ_TASK_STRUC_PUB.
3) Run the sql's manually

$ sqlplus apps/apps @paupgr46.sql

SQL*Plus: Release 8.0.6.0.0 - Production on Wed Sep 13 10:29:31 2006

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

Enter value for 3: 1
Enter value for 4: 1
Enter value for 1: PA
Enter value for 2: 100

PL/SQL procedure successfully completed.

$ sqlplus apps/apps @paupgr72.sql

SQL*Plus: Release 8.0.6.0.0 - Production on Wed Sep 13 10:29:31 2006

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

Enter value for 3: 1
Enter value for 4: 1
Enter value for 1: PA
Enter value for 2: 100

PL/SQL procedure successfully completed.

Reference metalink Doc ID 391271.1

No comments:

Post a Comment