R12 UPGRADE FAILS ON RGRFSGDF.SQL when creating index RG_ROW_SEGMENT_SEQUENCES_U3 (Doc ID 1502213.1)

Last updated on MARCH 06, 2017

Applies to:

Oracle General Ledger - Version 12.1.1 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Goal

Upgrade from Release 11i to Release 12 fails with

CREATE UNIQUE INDEX RG.RG_ROW_SEGMENT_SEQUENCES_U3 ON
RG.RG_ROW_SEGMENT_SEQUENCES (ROW_ORDER_ID, STRUCTURE_ID,
APPLICATION_COLUMN_NAME) 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 ROW_ORDER_ID, STRUCTURE_ID, APPLICATION_COLUMN_NAME, count(*)
 FROM RG.RG_ROW_SEGMENT_SEQUENCES
GROUP BY ROW_ORDER_ID, STRUCTURE_ID, APPLICATION_COLUMN_NAME
HAVING count(*)>1

AD Worker error:
Unable to compare or correct tables or indexes or keys because of the error above



Time when worker failed: Thu Sep 20 2012 09:08:58
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms