Saturday, January 20, 2024

ERROR "Use of uninitialized value $result in split "at /u01/TESTASCP/fs1/EBSapps/appl/au/12.0.0/perl/TXK/ADOPValidationUtils.pm line 1294.

 





I started adop patch, the first phase  I got this type of Error


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.







No comments:

Post a Comment

How to bounce the(restart) Apache server in Oracle EBS R12.2 ?

   1. login to our EBS instance using the putty tool 2. login applmgr user  3. Set the Apps Environment file applmgr  32497     1  0 Aug23 ?...