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)

Last updated on SEPTEMBER 14, 2016

Applies to:

Oracle Public Sector Financials (International) - Version 12.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 21-Feb-2014***
IGIPAYUP.sql

Symptoms

When attempting to run R12 upgrade and apply <patch:6678700>, IGIPAYUP.sql fails with the following error.,

ERROR
-----------------------
sqlplus -s APPS/***** @/u03/oracle/apps/apps_st/appl/igi/12.0.0/patch/115/sql/igipayup.sql
INSERT INTO IGI_UPGRADE_LOG(SEQUENCE_ID, COMPONENT, MODULE, MESSAGE_TEXT,
  *
ERROR at line 36:
ORA-06550: line 36, column 14:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 36, column 2:
PL/SQL: SQL Statement ignored

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms