The eTRM provides PDF diagrams and HTML reports for FND data objects. You can search and view these diagrams and reports through the Search tab and the FND Dictionary tab. These reports and diagrams are:
ERD Diagram
DBI Diagram
Tables Report
Dependencies Report
Product External Dependencies Report
In addition, you can generate the HTML reports if it's needed.
To understand each HTML report and how to locate these diagrams and reports, this chapter includes the following topics:
To generate the HTML reports, you need to submit a concurrent program called FND Generate eTRM HTML Report with the following parameters:
Note: All the HTML reports are static in nature. They are generated based on data model in your Oracle E-Business Suite instance.
Report: Select a desired report type that you want to generate for the report. The available selection from the list of values are:
All (default)
If no value is chosen, then the default value "All" is selected to generate all three HTML reports.
Tables Report
An HTML report (<application_short_name>_Tables.html) documents the table and view definitions in a product.
Dependencies Report
An HTML report (<application_short_name>_Dependencies.html) documents dependencies to tables and views in a product.
External Dependencies Report
An HTML report (<application_short_name>_Product_Dependencies.html) documents external dependencies to tables and views in a product.
Product: Select a desired product to generate the report you selected earlier.
If a specific application <application_short_name> is selected, then the report is only generated for the selected application.
If no value is chosen, then the default value "All" is selected to generate the desired report for all Oracle E-Business Suite applications.
Note that this FND Generate eTRM HTML Report concurrent program is a long running backend program. If the report is generated for "All" products, it may take a while to complete the concurrent processing. Once it's completed, it generates the desired HTML report for the selected application.
You can browse and search PDF diagrams and HTML reports through the following ways:
HTML Reports Only
Expand the Browse eTRM tree node of the Search Home page, and then the "HTML" folder.
PDF Diagrams Only
Expand the Browse eTRM tree node in the Search Home page, and then the "PDF Files" folder (for both ERD and DBI diagrams), "Logical Data Models" folder (for ERD diagrams only), or "Summarization Diagram" folder (for DBI diagrams only).
Note: ERD and DBI diagrams are Oracle seeded database diagrams. They are available as PDF files for most of the products.
Both HTML Reports and PDF Diagrams
Expand a Product folder in the Products tree node of the FND Data Dictionary page, and then the "Diagrams & Reports" link.
Select "FILE" as the Object Type value in the FND Data Dictionary page.
Click a desired HTML report or PDF diagram file name link from the List of Objects search result table. The File Details page appears where you can view the selected report or diagram in the File Details page. See: Viewing File Details Page.
Note that if the selected HTML report file name is not yet available, the following message may occur:
"The report is not yet available. It will be generated by the concurrent program FND Generate eTRM HTML Report. You can check its status with System Administrator and come back later to view the report."
In this situation, work with your system administrator to submit the concurrent program FND Generate eTRM HTML Report to generate your desired report. Once the report is generated, you should be able to access the HTML report.
See: Generating HTML Reports.