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.
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.
2 comments:
Hi Dylan,
I hope this message finds you well.
I noticed from several of your recent postings that data
management has been a topic of interest.
Based on your valued contribution to the industry dialogue, Informatica Corporation would like to invite you to attend the 2011 Customer Data Forum.
http://www.informatica.com/solutions/customer-acquisition-retention/Pages/index.aspx#page=page-1
The forum will be hosted in up to 10 cities between April and June.
In addition to the opportunity to network with the speakers and attendees, to provide additional insight about this topic, we are pleased to offer an exclusive interview with an Informatica expert. You may be interested in learning more about how IT can empower sales, marketing, and customer service to attract and retain customers by having direct access to complete customer data (including relevant social media data) within their CRM application, with the help of Master Data Management (MDM)
http://www.informatica.com/solutions/master_data_management/Pages/index.aspx.
The 2011 Customer Data Forum brings together IT and their sales, marketing and customer service counterparts to discuss a very hot topic: Leveraging a Complete Customer View. MDM can provide the business with a complete customer view to grow revenue, increase profitability, and improve operational efficiency. Attendees will learn how to:
• Bridge system silos to access and integrate customer data
• Deliver a 360-degree view of customer relationships – one that
takes
into account all products and services your customers own
• Adopt MDM, data quality, and data integration implementation best
practices.
To add a visual and auditory experience to your readers, we would like to offer you a web-exclusive video to include on your blog. In this video, Informatica’s Ravi Shankar, Senior Director of MDM Product Marketing and Jakki Geiger, Senior Director of Global Marketing Campaigns, explain why sales, marketing, customer service and IT should attend the Customer Data Forum. They discuss the customer data struggles faced by sales, marketing
and customer service when trying to attract and retain customers, and the negative impact it has on customer experience and company revenue.
Download the video:
http://www.informatica.com/campaigns/Customer_Data_Forum.wmv
The Customer Data Forum features the following speakers…
An award-winning analyst will share the root cause of the challenges
companies face attracting and retaining customers:
R "Ray" Wang, Principal Analyst, Constellation Research Group
Read full bio: http://vip.informatica.com/?elqPURLPage=8645
Informatica experts will explain how Informatica Customer Centricity
Solution can arm sales, marketing and customer service with trusted and complete customer data:
Chris Boorman, Chief Marketing Officer and Senior Vice President of
Education & Enablement, Informatica
Ramesh Menon, Senior Director of Product Management, MDM and Identity Resolution, Informatica
Arvind Parthasarathi, Senior Vice President and General Manager of Master Data Management Business Unit, Informatica
Ravi Shankar, Senior Director, MDM Product Marketing, Informatica
Experienced consultants will explain how to build and present a business case for MDM:
Scott Vogan, Principal & Enterprise Information Management (EIM) Practice Leader, North America, Capgemini
Duane Lyons, Partner, Infosys Technologies
Sriraj Rajaram, MDM Practice Lead, North America, Cognizant Technology
Register today: http://vip.informatica.com/?elqPURLPage=8645
Please contact me with any questions regarding the event or taking
advantage of our offer. Thank you for your consideration, and I look
forward to hearing from you soon.
Regards,
Becca Vittetoe
Six Spoke Media
press@sixspokemedia.com
san francisco | los angeles | new york | taipei
Six Spoke Media is an agency retained by Informatica Corporation to manage digital media outreach.
We have EBS v11 and we use a tool called Saphir that pulls the metadata out of the EBS 'FND' tables, including relationships which are defined somewhere in these FND Tables. You then have various approached to scoping tables, including grouping the tables by EBS module (e.g. Oracle Receivables). Then you can export these sub sets into things like ERwin or even Visio. We actually use it with PowerDesigner.
Post a Comment