FAILED: File Poreq.odf While Applying Patches - PO_REQUISITION_LINES_U2
(Doc ID 2005765.1)
Last updated on DECEMBER 10, 2024
Applies to:
Oracle Purchasing - Version 12.1.3 and laterOracle iProcurement - Version 12.1.3 to 12.1.3 [Release 12.1]
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
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 |