apexp.odf failed to create unique index AP.AP_EXPENSE_REPORT_HEADERS_U1 when upgrading from 11.5.10.
when applying patch (American English) unified driver (u6678700.drv) on the new 12.1.1 aix 6.1 environment, the apexp.odf fail to create index with the following error:
CREATE UNIQUE INDEX AP.AP_EXPENSE_REPORT_HEADERS_U1 ON
AP.AP_EXPENSE_REPORT_HEADERS_ALL (REPORT_HEADER_ID) LOGGING STORAGE
(FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE 10 INITRANS 11 MAXTRANS 255
COMPUTE STATISTICS TABLESPACE APPS_TS_INTERFACE
Statement executed.
AD Worker error:
The index cannot be created as the table has duplicate keys.
we have duplicate rows since the index existed in 11.5.10.2 with unikness on 3 columns ("REPORT_HEADER_ID", "SET_OF_BOOKS_ID", "ORG_ID").
i think it's a bug like for the bug described in the note ID 1304983.1, but i can't find any related document to this issue.