Problem: While running patch 6678700, the following error occurs:

FAILED: file fem_bal_nacc_hier_l2_mv.xdf on worker  1.

Solution: Use adctrl hidden option ‘8’ to skip the failed worker and complete the upgrade. Then, apply patch 10406817  “ORA-54015 APPLYING FEM_BAL_NACC_HIER_L2_MV.XDF ON ORACLE 11GR2 DATABASE” after the upgrade.

Reference: Patch Fails on Fem_bal_nacc_hier_l2_mv.xdf After Upgrade to Oracle 11.2.0.2 Database (Doc ID 1284055.1)

Problem: While running patch 6678700, the following error occurs:

ATTENTION: All workers either have failed or are waiting:

           FAILED: file apaphuhf.sql on worker  2.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Checking the worker log file showed:

sqlplus -s APPS/***** @D:\oracle\MFGP\apps\apps_st\appl\ap\12.0.0\patch\115\sql\

apaphuhf.sql &un_ap &batchsize 2 2

Error:
Program exited with status 1

Cause: The program terminated, returning status code 1.

Action: Check your installation manual for the meaning of this code on this 
operating system.

DECLARE
*
ERROR at line 1:
ORA-00001: unique constraint (AP.AP_PAYMENT_HISTORY_U2) violated
ORA-06512: at line 55

Solution: There is a duplicate value in the “REV_PMT_HIST_ID” column in the AP_PAYMENT_HISTORY_U2. Locate the duplicate value and set it to null.

Problem: While running patch 6678700, the following error occurs:

FAILED: file xlaraslg4.sql on worker  1.

Check adwork001.log  for more information regarding the error:

sqlplus -s APPS/***** @D:\oracle\MFGPR12\apps\apps_st\appl\xla\12.0.0\patch\115\sql\xlaraslg4.sql &un_ax

Error:
Program exited with status 1

Cause: The program terminated, returning status code 1.
Action: Check your installation manual for the meaning of this code on this operating system.DECLARE
*
ERROR at line 1:
ORA-20100: glraslg4.sql: status_code=SETUP_PL_SLA_OPTIONS error_msg=ORA-20001:
-: XLA-95103: An internal error occurred.  Please inform your system 
administrator or support representative that:
An internal error has occurred in the program xla_acct_setup_pkg.insert_launch_options.  
ORA-01658: unable to create INITIAL extent for segment in tablespace APPS_TS_SEED.
ORA-06512: at line 97

Solution: Add another datafile to APPS_TS_SEED tablespace:

select * from dba_data_files where tablespace_name = 'APPS_TS_SEED';

alter tablespace apps_ts_seed add datafile 
'D:\ORACLE\MFGP\MFGPDB\ORADATA\MFGP\A_REF03.DBF' size 1000M;

Problem: While running patch 6678700, the following error occurs:

FAILED: file GMIG3MIB.sql on worker  1.

Solution: If OPM is not used, the script is not relevant and can be skipped.

If the table IC_LOCT_INV doesn’t exist or the query below returns no rows, the script can be ignored.

select whse_code,migrated_ind,count(*) from
ic_locT_inv
where loct_onhand <>0 or
loct_onhand2 <>0
group by whse_code,migrated_ind;

Use adctrl option 8 to skip and restart.

Reference: GMIG3MIB.sql Is Stuck While Applying 12.1.1 Upgrade Patch 6678700 (Doc ID 1550457.1)

Problem: While running patch 6678700, the following error occurs:

FAILED: file jaircvdff.sql on worker  1.

Check adworker log in D:\ORACLE\MFGPR12\apps\apps_st\appl\admin\MFGP\log.

Solution: The cause of the issue is wrong parameter passed to script. Source the database tier environment and change directory to D:\ORACLE\MFGPR12\apps\apps_st\appl\ja\12.0.0\sql. Run jaircvff.sql and provide the following parameters while running the script manually:-

Enter value for 3: 1

Enter value for 4: 1

Enter value for 1: PO

Enter value for 2: 1000

Once the script completes successfully then skip the worker using adctrl and continue with patching.

Reference: JAIRCVDFF.SQL FAILS ON 12.1.1 UPGRADE PATCH 6678700 (Doc ID 1473255.1)

Problem:

ERROR: While running patch 6678700, the following error occurs:

FAILED: file igipayup.sql on worker  1.

Check adworker log in D:\ORACLE\MFGPR12\apps\apps_st\appl\admin\MFGP\log.

Solution:

To implement the solution, please execute the following steps:

1. The error message you are seeing indicates that the table IGI_UPGRADE_LOG does not exist. Verify this is true by running the following command:

SELECT COUNT(*) FROM IGI_UPGRADE_LOG;

2. Assuming that the table does not exist, look in %IGI_TOP%/patch/115/odf and see if you have a file called ‘igiupg.odf’ in there.

3. If the file exists, use the utility ‘adodfcmp’ to create the missing table.

4. If the file does not exist, download and unzip the patch:10074551:R12.IGI.B and copy ‘igiupg.odf’ into directory $IGI_TOP/patch/115/odf

5. To create the missing object(s) use the following commands:

adodfcmp userid=IGI/igi touser=APPS/apps priv_schema=SYSTEM/manager changedb=YES odffile=%IGI_TOP%\patch\115\odf\igiupg.odf mode=sequences
adodfcmp userid=IGI/igi touser=APPS/apps priv_schema=SYSTEM/manager changedb=YES odffile=%IGI_TOP%\patch\115\odf\igiupg.odf mode=tables

6. Use adctrl (option 2) to continue patch 6678700 from the point of failure and run the script IGIPAYUP.sql.

Reference: R12 Upgrade Patch 6678700 Failed In IGIPAYUP.sql With INSERT INTO IGI_UPGRADE_LOG ORA-00942 Table Or View Does Not Exist (Doc ID 1489757.1)