CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Index _PK causing issues in TCs

edited May 6, 2018 9:36AM in CNC, DB and Operating System - JDE1 (MOSC) 1 commentAnswered ✓

Indexes being created with _PK, causing issues with Table Conversions, anyone faced this issue before

We were able to identify Indexes, causing issue running TC's using the below query

************************************************

select DISTINCT INDEX_NAME from SYS.ALL_IND_COLUMNS where TABLE_NAME in ( SELECT DISTINCT TABLE_NAME FROM SYS.ALL_IND_COLUMNS WHERE INDEX_NAME like '%_PK' AND INDEX_OWNER = 'CRPDTA') and INDEX_OWNER='CRPDTA';

************************************************

Normally these Indexes are not supposed to be there, as Indexes usually created within JDE have a numeric, creation eg. INDEX_0 or INDEX_1 and so forth.. for sample " F0022_0 "

not " F0022_PK "

We were then able to drop the Indexes using the below commands

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center