My Oracle Support Banner

While Executing Patch 28946976:R12.AP.B Facing Error (Doc ID 2483725.1)

Last updated on FEBRUARY 24, 2019

Applies to:

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

Symptoms

On : 12.1.3 version, Patch Application Issues

When executing patch 28946976:R12.AP.B, the following error occurs.

Error in Worker log :

SQL> CREATE UNIQUE INDEX PO.PO_ATTRIBUTE_VALUES_TLP_U2 ON

PO.PO_ATTRIBUTE_VALUES_TLP (PO_LINE_ID, REQ_TEMPLATE_NAME,

REQ_TEMPLATE_LINE_NUM, INVENTORY_ITEM_ID, ORG_ID, LANGUAGE) LOGGING

STORAGE (FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE 10 INITRANS 11 MAXTRANS

255 COMPUTE STATISTICS TABLESPACE APPS_TS_TX_IDX 2 3 4 5

6 /

PO.PO_ATTRIBUTE_VALUES_TLP (PO_LINE_ID, REQ_TEMPLATE_NAME,

*

ERROR at line 2:

ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

 

SQL>

Use the following SQL statement to identify the duplicate keys:

SELECT PO_LINE_ID, REQ_TEMPLATE_NAME, REQ_TEMPLATE_LINE_NUM, INVENTORY_ITEM_ID, ORG_ID, LANGUAGE, count(*)

FROM PO.PO_ATTRIBUTE_VALUES_TLP

GROUP BY PO_LINE_ID, REQ_TEMPLATE_NAME, REQ_TEMPLATE_LINE_NUM, INVENTORY_ITEM_ID, ORG_ID, LANGUAGE

HAVING count(*)>1

AD Worker error:

Unable to compare or correct tables or indexes or keys ecause of the error above

STEPS TO REPRODUCE

The issue can be reproduced at will with the following steps:

1. Apply Patch 28946976:R12.AP.B

2. Get the above error.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.