Error Applying Patch 14386329 (Doc ID 1915951.1)

Last updated on AUGUST 15, 2014

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

 Apply Patch 14386329, Adworker log file showed the following error:

 

 

CREATE INDEX "PO"."PO_REQUISITION_LINES_F5" ON "PO"."PO_REQUISITION_LINES_ALL" (NVL("LINE_LOCATION_ID",(-999)), NVL("CLOSED_CODE",'OPEN'), "SOURCE_TYPE_CODE", NVL("TRANSFERRED_TO_OE_FLAG",'N'), NVL
("CANCEL_FLAG",'N'), "REQUISITION_HEADER_ID")
 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"
 PARALLEL
Start time for statement above is Mon Jul 07 12:53:13 EST 2014
A Differnt index with same column name exists

Currently the index is  owned by user apps.

OBJECT_NAME                    OBJECT_TYPE         OWNER
------------------------------ ------------------- ------------------------------
PO_REQUISITION_LINES_F5        INDEX               APPS

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