Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

Change Data Type Integer to Numeric Considerations

I have custom E1 Data Item (DD Item) that needs to be changed from Type Integer to Numeric (length 10) to eliminate the 5-digit entered-value design limitation for an Integer data type (re: Doc ID 626537.1, Question #18). I was not aware of this design limitation at the time I originally implemented the custom DD Item.

This custom DD Item is used across several tables, BSVWs, applications, etc. and is already in Production. In the JDE SQL DB I believe the column attributes for this data item will change from numeric(18,0) to float when making this Data Type change and regenerating the tables. I am running with a common set of DD tables for all pathcodes (JDE-supported configuration). I do not want to create a new DD item to replace the existing, as this will likely require as much or more change effort than changing the existing DD Item.

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