Monday, December 13, 2010

Oracle EBS Data Model

Oracle EBS provides the technical reference guide in eTRM. eTRM is a documentation service provided by Oracle to the customers that have the support contract - etrm.oracle.com.

Oracle EBS stores the tables and descriptions in FND_TABLES and FND_COLUMNS. If the table and columns are registered using AD_DD, the table and column descriptions will be stored in the above tables.

See Also:

http://oracledollars.forums-free.com/all_tab_cols-t30.html
http://www.allguru.net/oracle-apps-dba/fnd_tables-fnd_columns/

To get the correct list of columns for a table, the Oralce database data dictionary should be used. FND tables store the design time data. The FND table and column definition may be stored ahead of time before you apply a patch. The obsolete columns may still be represented in the tables.

Here is a script I found that merge the FND and Oracle database data dictionary.

http://www.sap-img.com/oracle-database/script-to-create-a-data-dictionary-listing-which-combines-the-oracle-dictionary-with-the-oracle-apps-dictionary.htm


Oracle EBS does not define the foreign keys within the database. In order to get the reference information, FND tables should be used. Oracle EBS does not use the USER_TAB_COMMENTS or USER_COL_COMMENTS.
Post a Comment