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.

 

ADOP Failed At Prepare Stage With Invalid Credential Error ORA-12514


*******FATAL ERROR*******
PROGRAM : (/fh09/UPG1T/apps/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME : Sat Apr 6 20:02:22 2013
FUNCTION: ADOP::Phase::executeSQL [ Level 1 ]
ERRORMSG: Invalid Credentials


adop patch log file has below error:

AutoPatch error:
The following ORACLE error:

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor




The issue can be reproduced at will with the following steps:
1. adop phase=prepare

To implement the solution, execute the following steps:

1. Add following line to init.ora:

local_listener = _LOCAL

In this SID is database instance name.

e.g 

local_listener = VIS_LOCAL

2. Restart database.

3. Retest the issue.