AutoConfig could not successfully execute the following scripts: txkWfClone.sh INSTALL_SETUP 1

AutoConfig could not successfully execute the following scripts: txkWfClone.sh  INSTALL_SETUP  1

Error :

[SETUP PHASE]

  AutoConfig could not successfully execute the following scripts:

    Directory: /r12uat1app/PROJ4/inst/apps/PROJ4_acod1rka001/admin/install

      txkWfClone.sh           INSTALL_SETUP      1


AutoConfig is exiting with status 1

RC-50014: Fatal: Execution of AutoConfig was failed

Raised by oracle.apps.ad.clone.ApplyApplTop

ERROR: AutoConfig completed with errors. Check logfile at /r12uat1app/PROJ4/inst/apps/PROJ4_acod1rka001/admin/log/ApplyAppsTier_02130640.log for details.

ApplyApplTop Completed Successfully.


# Checking the status of AutoConfig run of ApplyApplTop

Warning : AutoConfig has completed with  errors .

Please review the AutoConfig section in the logfile. If required, you can re-run AutoConfig from command line  after fixing the problem


Cause:

This error means one of the following:
(a) WF_CLONE pkg and/or pkg body doesn't exist in the db or is invalid
or
(b) The DETERMINECLONE method/procedure doesn't exist within WF_CLONE pkg/pkg body.
(c) Some time Permission issue

(d) Bounce the listner (or) check status of listener


Solution:


1.    Please check the of the file txkWfClone.sh

    /r12uat1app/PROJ4/inst/apps/PROJ4_acod1rka001/admin/install

2    Give 755 txkWfClone.sh and then rerun AutoConfig, it will be executed succesfully.

        [OR]

1. Please verify if WF_CLONE is valid in the database. If it is not, please recompile it.

2. If the actions in #1 do not resolve the issue, then do the following:

     a. Run the following SQL query:


        SQL> select text

        2 from all_source

        3 where name = 'WF_CLONE' and line < 7;


     b. Go to the $FND_TOP/patch/115/sql directory and obtain the version of wfclones.pls

        and wfcloneb.pls.

     c. Compare the two versions. If they are different, then go to the

        $FND_TOP/patch/115/sql directory and recreate the spec/body by running:


- sqlplus apps/<passwd> @WFCLONES.pls

- sqlplus apps/<passwd> @WFCLONEB.pls


3. Rerun AutoConfig.