Wednesday, December 7, 2016

ADOP Phase=prepare Is Failing Status = 255 Error : PLS-00302: component 'PATCH_CP' must be declared

[STATEMENT] [START 2014/03/23 10:18:49] Checking status of the ADZDPATCH concurrent program
  [STATEMENT] Status of ADZDPATCH: 
  [STATEMENT] This request finished with an error and produced the following completion
message: ORACLE error 6550 in FDPSTP Cause: FDPSTP failed due to
ORA-06550: line 1, column 18: PLS-00302: component 'PATCH_CP' must be
declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored . The SQL
statement being executed at the time o The processing began on
23-MAR-2014 10:18:48 and ended on 23-MAR-2014 10:18:48. You may find more
information on the cause of the error in the request log or the concurrent
manager log. 
  [STATEMENT] [START 2014/03/23 10:18:57] Unlocking sessions table
  [STATEMENT] [END 2014/03/23 10:18:58] Unlocking sessions table
*******FATAL ERROR*******
PROGRAM : (/appgu/gfnhu/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME : Sun Mar 23 10:18:54 2014
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ] 
MESSAGES:
SQLPLUS error: buffer=

SQL*Plus: Release 10.1.0.5.0 - Production on Sun Mar 23 10:18:54 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> SQL> Connected.
SQL> ORA-06550: line 1, column 18: PLS-00302: component 'PATCH_CP' must be
                                                    *
ERROR at line 5:
ORA-06550: line 5, column 53:
PLS-00103: Encountered the symbol "PATCH_CP" when expecting one of the
following:




To implement the solution, please execute the following steps:

1. Ensure that one has taken a backup of the environment.

2. Run the following select:
select EXECUTION_METHOD_CODE from fnd_concurrent_programs where
CONCURRENT_PROGRAM_NAME='ADZDPATCH';

3.1 If the select returns I, do the following:

a. Backup the table: fnd_concurrent_programs.

b. Run the following to update the execution method:
update fnd_concurrent_programs set EXECUTION_METHOD_CODE='Q' where
CONCURRENT_PROGRAM_NAME='ADZDPATCH';
commit;

c. Run autoconfig on fs1 and fs2.

OR

3.1 If the select returns Q, run autoconfig on fs1 and fs2.

Source the env file for fs1:
cd $ADMIN_SCRIPTS_HOME
./adautocfg.sh
following the prompts.

Source the env file for fs2:
cd $ADMIN_SCRIPTS_HOME
./adautocfg.sh
following the prompts.

4. Retest the issue by re-running adop phase=prepare.
 

No comments:

Post a Comment