Oracle JDEdwards EnterpriseOne Table Trivia

July 12, 2013

Read Time:47 Sec

Deepesh, at JDESource, has a great post about the JDEdwards table property limits.

Prior to version 8.9, the maximum number of columns in a table was 254. However, since then, the table property limits have been stored in the F9300 (Database Property Values) table.

The F9300 contains values for the following properties:

Maximum Column Name Length
Maximum Index Name Length
Maximum Number Of Blobs In Table
Maximum Number Of Columns In Index
Maximum Number Of Indexes In Table
Maximum Table Name Length
Maximum Total Index Length
Maximum Total Row Length
Minimum Column Name Length
Minimum Index Name Length
Minimum Number Of Blobs In Table
Minimum Number Of Columns In Index
Minimum Number Of Columns In Table
Minimum Number Of Indexes In Table
Minimum Table Name Length
Minimum Total Index Length
Minimum Total Row Length

Changing the defined values in the F9300 – Database Property Values table is not recommended or supported.

Source – My Oracle Support Doc 1077277.1

Author

Stewart Schatz

Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it. Side Hustle: Owner/Operator of E1Tips.com Location: Lancaster, PA USA What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.

stewart@9rains.com

http://stewartschatz.com