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)