My Oracle Support Banner

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.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.