Upgrade U10124646.drv Driver Failing at Igibud.odf
(Doc ID 2723246.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle Public Sector Financials (International) - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
While upgrading EBS 12.1.3 to 12.2, upgrade driver fails at igibud.odf files with the below error:
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
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 BE_HEADER_ID, BE_LINE_NUM, PERIOD_NUMBER, count(*)
FROM IGI.IGI_BUD_JOURNAL_PERIODS
GROUP BY BE_HEADER_ID, BE_LINE_NUM, PERIOD_NUMBER
HAVING count(*)>1
Changes
EBS 12.1.3 to 12.2 upgrade.
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 |
| Changes |
| Cause |
| Solution |
| References |