When
Runing adconfig.sh on apps tier after clone some time this error.
[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>
[SETUP PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /f11/app/applp032/inst/apps/P032_tgpora3/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 /f11/app/applp032/inst/apps/P032_tgpora3/admin/log/ApplyAppsTier_07180828.log for details.
ApplyApplTop Completed Successfully
Raised by oracle.apps.ad.clone.ApplyApplTop
ERROR: AutoConfig completed with errors. Check logfile at /f11/app/applp032/inst/apps/P032_tgpora3/admin/log/ApplyAppsTier_07180828.log for details.
ApplyApplTop Completed Successfully
REASON :
1. Received the following error
running Autoconfig:
[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>
[SETUP PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /apps/ifswmisc/common/admin/install/MISC_findvcl2
txkWfClone.sh INSTE8_SETUP 1
[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>
[SETUP PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /apps/ifswmisc/common/admin/install/MISC_findvcl2
txkWfClone.sh INSTE8_SETUP 1
2. The adconfig.log shows
txkWfClone.sh errors with the following:
ERROR at line 1:
ORA-06550: line 10, column 7:
PLS-00201: identifier 'WF_CLONE.DETERMINECLONE' must be declared
ORA-06550: line 10, column 3:
PL/SQL: Statement ignored
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
ERROR at line 1:
ORA-06550: line 10, column 7:
PLS-00201: identifier 'WF_CLONE.DETERMINECLONE' must be declared
ORA-06550: line 10, column 3:
PL/SQL: Statement ignored
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
Solution
1. Please verify if WF_CLONE is valid in the database. If it is not,
pleaserecompile 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.
No comments:
Post a Comment