While Applying Patch Worker Failed on Apiaw.odf for AP_INV_APRVL_HIST_U1 Index (Doc ID 2137850.1)

Last updated on MAY 13, 2016

Applies to:

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

Symptoms

When applying a patch, the worker fails on the apiaw.odf file when creating index AP_INV_APRVL_HIST_U1.

The adwork##.log shows the following errors:

 

ALTER INDEX AP.AP_INV_APRVL_HIST_N1 STORAGE (FREELISTS 4)

Statement executed.

*******************************************************
The table is missing the index AP_INV_APRVL_HIST_U1
or index AP_INV_APRVL_HIST_U1 exists on another table.
Create it with the statement:


Start time for statement below is: Wed May 04 2016 22:19:51

CREATE UNIQUE INDEX AP.AP_INV_APRVL_HIST_U1 ON AP.AP_INV_APRVL_HIST_ALL
(APPROVAL_HISTORY_ID) LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4 )
PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS   TABLESPACE
APPS_TS_TX_IDX

Statement executed.

AD Worker error:
The index cannot be created as the table has duplicate keys.

Changes

As a fix for performance bug 10425273, a new index was introduced in file apiaw.odf. This fix adds the index AP_INV_APRVL_HIST_U1 in the following versions or higher.

R12.0.X: 120.10.12000000.3
R12.1.X: 120.10.12010000.4
R12.2.X: 120.10.12020000.4

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