Creation of Index PO_VENDORS_OBS_F1 Failed When Applying 12.1.1 Upgrade Patch 6678700 (Doc ID 859556.1)

Last updated on NOVEMBER 04, 2013

Applies to:

Oracle Purchasing - Version 12.1 to 12.1 [Release 12.1]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

During application of 12.1.1 upgrade <patch.6678700>, an error occurs when PO_VENDORS_OBS_F1.xdf is executed.

The error is detailed in the adworker log file as follows:

XDF file application started. Current time is: Tue Jul 14 13:30:16 CDT 2009



================================================================================
Applying XDF file :
/oracle/apps11/X7/apps/apps_st/appl/po/12.0.0/patch/115/xdf/PO_VENDORS_OBS_F1.xdf
================================================================================

Index hashcode(s) extracted from the XDF.

Hashcodes generated for DB indexes.

Index PO_VENDORS_OBS_F1 does not exist in PO.

CREATE INDEX "PO"."PO_VENDORS_OBS_F1" ON "PO"."PO_VENDORS_OBS"
(NVL("END_DATE_ACTIVE",TO_DATE('9999-12-31 00:00:00', 'yyyy-mm-dd hh24:mi:ss')))
PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 16384 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT)
TABLESPACE "APPS_TS_TX_IDX"
Start time for statement above is Tue Jul 14 13:30:16 CDT 2009
A Differnt index with same column name exists
Updating task with status 1

AD Worker error:
The utility FndXdfCmp returned error for the above task.

AD Worker error:
The above program failed. See the error messages listed
above, if any, or see the log and output files for the program.


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