Read Time:1 Min, 55 Sec

I’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:

JD Edwards EnterpriseOne Tools Documentation – Release 9.2.x
JD Edwards EnterpriseOne Tools Documentation – Release 9.1.x
Document 626511.1 E1: DD: Deploying Data Dictionary Changes
Document 944015.1 E1: ENV: Frequently Asked Questions on Caching in EnterpriseOne
Document 650630.1 E1: FDA: Tables Cached by JDBJ on the Web Client (JDBj Database Caches)
Document 2164730.1 E1: ENV: How to Manually Delete Global Tables (including Data Dictionary Specs), Runtime Cache, and UBE Overrides
Document 1090584.1 – E1: BSFN: Frequently Asked Questions on Business Functions and NER Running on JAS
Document 942143.1 – E1: PKG: How to Find Package Management Guide and JD Edwards EnterpriseOne Documentation – Tools Release 8.98 Onwards

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.

stewart@9rains.com

http://stewartschatz.com