FAILED: File Poreq.odf While Applying Patches - PO_REQUISITION_LINES_U2

(Doc ID 2005765.1)

Last updated on SEPTEMBER 29, 2017

Applies to:

Oracle iProcurement - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

FAILED: file poreq.odf while applying patches

ERROR
-----------------------
ATTENTION: All workers either have failed or are waiting:

  FAILED: file poreq.odf on worker 1.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

AD worker log:
*******************************************************
The table is missing the index PO_REQUISITION_LINES_U2
or index PO_REQUISITION_LINES_U2 exists on another table.
Create it with the statement:

Start time for statement below is: Wed Apr 15 2015 11:58:34

CREATE UNIQUE INDEX PO.PO_REQUISITION_LINES_U2 ON
PO.PO_REQUISITION_LINES_ALL (REQUISITION_HEADER_ID, LINE_NUM) LOGGING
STORAGE (FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE 0 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.

Use the following SQL statement to identify the duplicate keys:

SELECT REQUISITION_HEADER_ID, LINE_NUM, count(*)
 FROM PO.PO_REQUISITION_LINES_ALL
GROUP BY REQUISITION_HEADER_ID, LINE_NUM
  HAVING count(*)>1

AD Worker error:
Unable to compare or correct tables or indexes or keys
  because of the error above


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Applied a patch containing poreq.odf

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create PO_REQUISITION_LINES_U2 index

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