The file txkADOPValidations.error for adop session shows the following:
Use of uninitialized value $result in split at
/u01/TESTASCP/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 1294.
Root Cause is Patch context file is missing in the FND_OAM_CONTEXT_FILES table
Solution :
1. Get the value of the Context file
Source the PATCH file system
2. Echo value of $CONTEXT FILE, Note the Context_file, use in step: 4
3. Source the RUN File system
4. on the Master node, execute the command in the Run file system to upload the patch context file in the database
$ADJVAPRG oracle.apps.ad.autoconfig.oam.CtxSynchronizer
action=upload contextfile=<Enter Your Full Patch Context XML File Location>
logfile=/tmp/patchctxupload.log
Example :
$ADJVAPRG oracle.apps.ad.autoconfig.oam.CtxSynchronizer
action=uplod contextfile=/u01/oracle/PROD/fs2/inst/apps/PROD_ebsapp/appl/admin/PROD_ebsapp01.xml
logfile=/tmp/patchctxupload.log
5. Finally run the query and should return some values :
select distinct(PATH) from FND_OAM_CONTEXT_FILES where NAME not in (‘TEMPLATE’,’METADATA’,’config.txt’) and CTX_TYPE=’A’ and (status is null or upper(status) in (‘S’,’F’)) and EXTRACTVALUE(XMLType(TEXT),’//file_edition_type’) = ‘patch’;
now Once again start the ADOP phase=prerpare
now the issue has been solved.