Adop phase=prepare failing with error [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on ebs1

As part of EBS 12.2.6 integration with OID, i was trying to run adop phase=prepare in the patch file system and i encountered the below error

[UNEXPECTED]Error occurred running "perl /u01/r12/application/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl  -contextfile=/u01/r12/application/fs1/inst/apps/PROD_ebs1/appl/admin/PROD_ebs1.xml -patchctxfile=/u01/r12/application/fs2/inst/apps/PROD_ebs1/appl/admin/PROD_ebs1.xml -phase=prepare -logloc=/u01/r12/application/fs_ne/EBSapps/log/adop/3/20170226_034703/prepare/validate/ebs1 -promptmsg=hide"
    [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on ebs1


[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.


adop exiting with status = 1 (Fail)



The detailed error was




Use of uninitialized value $result in split at /u01/r12/application/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 1291.
No such file or directory at /u01/r12/application/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 230.



The solution is mentioned in one of the metalink note:Error "Use of uninitialized value $result in split" In File txkADOPValidations.error When Running fs_clone (Doc ID 2090393.1)

[applmgr@ebs1 validations]$ sqlplus apps

SQL*Plus: Release 10.1.0.5.0 - Production on Sun Feb 26 04:34:29 2017

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

Enter password:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> 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';

no rows selected

SQL>
[applmgr@ebs1 application]$ . ./EBSapps.env

  E-Business Suite Environment Information
  ----------------------------------------
  RUN File System           : /u01/r12/application/fs1/EBSapps/appl
  PATCH File System         : /u01/r12/application/fs2/EBSapps/appl
  Non-Editioned File System : /u01/r12/application/fs_ne


  DB Host: ebs1.oracle.com  Service/SID: PROD


  E-Business Suite Environment Setting
  ------------------------------------
  - Enter [R/r] for sourcing Run File System Environment file, or
  - Enter [P/p] for sourcing Patch File System Environment file, or
  - Enter anything else to exit

  Please choose the environment file you wish to source [R/P]:P

  Sourcing the PATCH File System ...

[applmgr@ebs1 application]$ echo $CONTEXT_FILE
/u01/r12/application/fs2/inst/apps/PROD_ebs1/appl/admin/PROD_ebs1.xml
[applmgr@ebs1 application]$


$ADJVAPRG oracle.apps.ad.autoconfig.oam.CtxSynchronizer \
action=upload \
contextfile=/u01/r12/application/fs2/inst/apps/PROD_ebs1/appl/admin/PROD_ebs1.xml \
logfile=/tmp/patchctxupload.log
run the query to validate

Run the below query again to validate


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') =