E1: TDA: Coexistence Index Generation Fails on F43199 and F43121 (Doc ID 631579.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.

Symptoms

We are using EnterpriseOne in coexistence with the World software. A custom index has been added over the F43199 and F43121 tables in EnterpriseOne. When generating indices in OMW, the message 'Index Generation has Failed' is displayed. The jde.log shows that indices F43199_1 & F43121_1 have not been created due to a duplicate key constraint.  All other indices have been created. Upon reviewing the two tables, there are over 500,000 records of duplicates based on the F43199_1 and F43121_1 indices.

Cause

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