The eTRM allows you to perform the following tasks in the eTRM Search Home page:
After logging to the eTRM, you can quickly browse the eTRM object metadata on the left pane of the Search home page by clicking the following links in the Browse eTRM tree node to locate your desired database object:
FND Data Dictionary: This displays the FND Data Dictionary page where you can browse and search desired FND objects.
See: Browsing and Searching Objects in the FND Data Dictionary Page.
DBA Data Dictionary: This displays the DBA Data Dictionary page where you can browse and search desired DBA objects.
See: Browsing and Searching Objects in the DBA Data Dictionary Page.
PDF Files: This retrieves the FND objects containing PDF files in the List of Objects table of the FND Data Dictionary page, with the following search values populated automatically:
Product: All
Object Type: FILE
Object Name: %.pdf
HTML Files: This retrieves the FND objects containing HTML files in the List of Objects table of the FND Data Dictionary page, with the following search values populated automatically:
Product: All
Object Type: FILE
Object Name: %.html
Logical Data Models: This retrieves the FND objects containing entity relationship diagrams (ERD diagrams) in the List of Objects table of the FND Data Dictionary page, with the following search values populated automatically:
Product: All
Object Type: FILE
Object Name: %ERD%.pdf
Summarization Diagram: This retrieves the FND objects containing DBI diagrams in the List of Objects table of the FND Data Dictionary page, with the following search values populated automatically:
Product: All
Object Type: FILE
Object Name: DBI%.pdf
Click a desired object from the search results table to access the selected object details.
For information about the selected file details, see Viewing File Details Page.
For information about the PDF diagrams and HTML reports, see Diagrams and Reports.
The eTRM allows you to enter free text search in the Search home page. The search text can include one or more words separated by space character. The search engine performs search against the table and column descriptions in the FND Model, specifically against the following for the text you entered in the Search field:
Name and Description fields of Tables, Views, and Columns in the FND model
DBA Object Name
For example, if you enter "contract compliance" and then click Search, the eTRM will look for tables, views, and columns that contain that phrase for an exact match or a partial match of any word in that phrase if needed.
Search Tab in the Welcome to Electronic Technical Reference Manual - eTRM Page
The search engine retrieves objects that match your criteria and lists them in the Search Results table. Each object in the table has the following information:
Object Name: Name of the object. Click the name link to drill down to see the selected object details.
Object Type: Classification of an object across FND Dictionary and DBA Dictionary should be displayed. Based on the retrieved objects, this field can be of any object types, such as TABLE, VIEW, SYNONYM, TRIGGER, etc.
Product: Oracle E-Business Suite product owns the database object.
Schema Owner: Database schema owner for the database object.
Description: Description text for the database object.
If the search returns no records, then a message "No records found in eTRM for your search <Search text>
" is displayed.