Browsing and Searching the eTRM Through the Home Page

Overview

The eTRM allows you to perform the following tasks in the eTRM Search Home page:

• Browsing Objects in the Search Home Page

• Searching Objects in the Search Home Page

Browsing Objects in the 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.

Searching Objects in the Search Home Page

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.

  See:Viewing Object Details Page.

• 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.