Upgrade U10124646.drv Driver Failing at Igibud.odf
(Doc ID 2723246.1)
Last updated on NOVEMBER 02, 2020
Applies to:Oracle Public Sector Financials (International) - Version 12.1.3 and later
Information in this document applies to any platform.
While upgrading EBS 12.1.3 to 12.2, upgrade driver fails at igibud.odf files with the below error:
The table is missing the index IGI_BUD_JOURNAL_PERIODS_PK or index IGI_BUD_JOURNAL_PERIODS_PK exists on another table.
Create it with the statement:
Start time for statement below is: Sun Sep 06 2020 06:39:12
CREATE UNIQUE INDEX IGI."IGI_BUD_JOURNAL_PERIODS_PK" ON
IGI.IGI_BUD_JOURNAL_PERIODS (BE_HEADER_ID, BE_LINE_NUM, PERIOD_NUMBER)
LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE 10 INITRANS 11
MAXTRANS 255 COMPUTE STATISTICS TABLESPACE APPS_TS_TX_IDX
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 BE_HEADER_ID, BE_LINE_NUM, PERIOD_NUMBER, count(*)
GROUP BY BE_HEADER_ID, BE_LINE_NUM, PERIOD_NUMBER
EBS 12.1.3 to 12.2 upgrade.
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