needle-in-haystack

Needle – Overview of Specifications (SPEC) in Oracle JDE EnterpriseOne

Read Time:1 Min, 55 Sec

needle-in-haystackI’m starting a new category of posts called “Needles”. It is going to have Oracle Support Documents that I have found useful or interesting. Sometimes finding documents that meet that criteria are hard to find among the many documents on My Oracle Support site.

Here is my first one…

Overview of Specifications (SPEC) in EnterpriseOne (Doc ID 1142313.1)

***My Oracle Support access is required to take advantage of most of the links in this post***

Have you ever wondered about how all the “specs” were related in JDE? There are at least 34 database tables that contain some sort of data required to manage object specs from creation to deployment not to mention files like DDDICT, DDTEXT & GLBLTBL.

The Overview of Specifications (SPEC) in EnterpriseOne (Doc ID 1142313.1) gives a really good overview of all the parts and pieces involved. In fact, one of the first things they mention is the many names of “Specs”:

Depending on encoding, location and usage, specs may be called any of the following:

Object Description
Central Object This object implies it is the central repository of specifications.
TAMSpec This is JDE’s specific SPEC format with file extensions of *.xdb & *.ddb
SPEC The short name for specification
Metadata In this example, other than Business/Control data it may also be called metadata
Serialized Object These objects have been generated into JAVA code that the JAS/HTML Server can interpret and use.

Probably the most valuable part of the document are the many links to other documents:

What is one of the “needles” within the My Oracle Support haystack that you have found useful?

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.

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

SQL Packages Previous post IBM iSeries SQL Packages FAQ
E1Tips.com - SQL Ninja Next post Quick Tip: Limit The Number Of Rows Returned From A SQL Query