After 12.2 upgrade adop failed ORACLE error 6550 in FDPSTP Cause: FDPSTP

Issue:

[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-00802: 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-2020 10:18:48 and ended on 23-MAR-2020 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 2020/08/23 10:18:57] Unlocking sessions table
[STATEMENT] [END 2020/08/23 10:18:58] Unlocking sessions table
*******FATAL ERROR*******
PROGRAM : (/<DIR>/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME : Sun Mar 23 10:18:54 2020
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]

PLS-00108: Encountered the symbol “PATCH_CP” when expecting one of the

Cause:

The issue is caused by a desynchronization of the fs1 and fs2 setup after finish upgrade process.

Solution:

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 b.concurrent_program_name||’ – ‘||a.user_concurrent_program_name, a.description,
decode(b.execution_method_code,
‘P’, ‘Oracle Reports’,
‘E’ ,’Perl Concurrent Program’,
‘Q’ ,’SQL*Plus’,
‘L’ ,’SQL*Loader’,
‘A’ ,’Spawned’,
‘B’ ,’Request Set Stage Function’,
‘I’ ,’PL/SQL Stored Procedure’,
‘K’ ,’Java Concurrent Program’,
‘J’ ,’Java Stored Procedure’,
‘S’ ,’Immediate’,
‘H’ ,’Host’
) Execution_Method
from fnd_concurrent_programs_tl a, fnd_concurrent_programs b where
b.concurrent_program_name=’ADZDPATCH’;

Note : If the select returns “PL/SQL Stored Procedure”, 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

Note : If the select returns “SQL*Plus”, 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.
5. Migrate the solution as appropriate to other environments.