OracleEBSerror

FS_CLONE give error at ADOPValidationUtils

FS_CLONE give error at ADOPValidationUtils

 

When executing fs_Clone, the following error is encountered.

ERROR

[UNEXPECTED]Error occurred running “perl /u01/app/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/u01/app/PROD/fs1/inst/apps/PROD_prodapps/appl/admin/PROD_prodapps.xml -patchctxfile=/u01/app/PROD/fs2/inst/apps/PROD_prodapps/appl/admin/PROD_prodapps.xml -phase=fs_clone -logloc=/u01/app/PROD/fs_ne/EBSapps/log/adop/48/20231102_181022/fs_clone/validate/funoracleapps -promptmsg=hide”
[UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on funoracleapps

Checking log further below error is noticed.

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

SOLUTION

 

1) Execute the following query to check if the patch context file entry exists.

 

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

2) To resolve this problem, it’s necessary to upload the patch context file.

 

a) Source your PATCH file system

[apps@testebs ~]$ . EBSapps patch

[apps@testebs ~]$ echo $FILE_EDITION

patch

Get the value of your patch context file.

 

[apps@testebs ~]$ echo $CONTEXT_FILE

/u01/oracle/PROD/fs2/inst/apps/PROD_prodapps/appl/admin/PROD_prodapps.xml

b) Source the RUN filesystem and Execute the following command on the run filesystem to upload the patch context file to the database.

 

$ADJVAPRG oracle.apps.ad.autoconfig.oam.CtxSynchronizer
action=upload
contextfile='Enter Your Full Patch Context XML File Location as per step 1'
logfile=/tmp/patchctxupload.log

[apps@testebs ~]$ echo $FILE_EDITION

run

[apps@testebs ~]$ $ADJVAPRG oracle.apps.ad.autoconfig.oam.CtxSynchronizer
> action=upload
> contextfile=/u01/oracle/PROD/fs2/inst/apps/PROD_prodapps/appl/admin/PROD_prodapps.xml
> logfile=/tmp/patchctxupload.log
Enter the APPS password:

NOTE: The context file parameter must be directed to the actual location of the patch context file on your system.

 

3) Execute the query below, which should yield a single entry corresponding to the newly uploaded context file

 

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

PATH
-----
/u01/oracle/PROD/fs2/inst/apps/PROD_prodapps/appl/admin/PROD_prodapps.xml

4) Execute fs_clone once more, and it should now complete successfully.

 

 

 

    About Syed Saad

    With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

    Check Also

    EBS_Latest_Configurations

    Apply EBS AD-TXK Release 16 Update

    Step By Step Guide to Apply Oracle E-Business Suite R12.2 ADTXK Update 16 Oracle Applications …

    Leave a Reply