Symptoms:
Patch 31856789 completes but says fails at the end
$ adop phase=apply apply_mode=downtime patches=31856789 restart=yes abandon=no patchtop=/mnt/install_images/oracle/EBS122Patches/EBS12211/12211 workers=16 wait_on_failed_job=yes
Enter the APPS password:
Enter the EBS_SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /dodiapps/prod/prodapps/fs1/inst/apps/PROD_prodapp/appl/admin/PROD_prodapp.xml
Patch edition context: /dodiapps/prod/prodapps/fs2/inst/apps/PROD_prodapp/appl/admin/PROD_prodapp.xml
Patch file system free space: 503.85 GB
Validating system setup.
Node registry is valid.
Checking for existing adop sessions.
Session Id : 4
Prepare phase status : NOT APPLICABLE
Apply phase status : ATLEAST ONE PATCH IS ALREADY APPLIED
Cutover phase status : NOT APPLICABLE
Abort phase status : NOT APPLICABLE
Session status : RUNNING
Continuing with existing session [Session ID: 4].
===========================================================================
ADOP (C.Delta.14)
Session ID: 4
Node: prodapp
Phase: apply
Log: /dodiapps/prod/prodapps/fs_ne/EBSapps/log/adop/4/20230411_124938/adop.log
===========================================================================
Applying patch 31856789.
Log: /dodiapps/prod/prodapps/fs_ne/EBSapps/log/adop/4/20230411_124938/apply/prodapp/31856789/log/u31856789.log
***
Continue as if it were successful :
***
AutoPatch could not find a response to the above prompt
in the defaults file.
The patch has FAILED,
Please check the adpatch logs for more details.
You should check the file
/dodiapps/prod/prodapps/fs_ne/EBSapps/log/adop/4/20230411_124938/apply/prodapp/31856789/log/u31856789.log
for errors.
[UNEXPECTED]Error occurred executing “adpatch abandon=no restart=yes workers=16 wait_on_failed_job=yes options=hotpatch console=no interactive=no defaultsfile=/dodiapps/prod/prodapps/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/mnt/install_images/oracle/EBS122Patches/EBS12211/12211/31856789 driver=u31856789.drv logfile=u31856789.log”
[UNEXPECTED]Refer to the log files for more information.
[UNEXPECTED]Apply phase has failed.
[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)
prodapp(oracle):/mnt/install_images/oracle/EBS122WD_GOLIVE/12211/pay_us_tax_types_tab_xdf_fail/332726936591
$
Solution:
1. Take a backup of existing PAYGBTX.fmb
cd $AU_TOP/forms/US
mv PAYGBTAX.fmb PAYGBTAX.fmb.69
2. Copy PAYGBTX.fmb from patch top:33738081 to $AU_TOP/forms/US
cd /mnt/install_images/oracle/EBS122Patches/EBS12211/Post12211/33738081/pay/forms/US/
cp PAYGBTAX.fmb $AU_TOP/forms/US
3. Make sure the copied PAYGBTAX.fmb is version 120.67.12020000.81
4. Generate fmx
cd $AU_TOP/forms/US
$ORACLE_HOME/bin/frmcmp_batch module=$AU_TOP/forms/US/PAYGBTAX.fmb userid=APPS/APPS output_file=$PAY_TOP/forms/US/PAYGBTAX.fmx module_type=form compile_all=special
Oracle Reference:
SR 3-32752554737 : Applying 12.2.11 Patch 31856789 fail with: ERROR generating form “forms/US/PAYGBTAX.fmx”
Orama.blog 