Browsing and Searching Objects in the DBA Data Dictionary Page

Overview

The DBA Data Dictionary page provides access to information from the data dictionary (dba_objects view).

From the eTRM Search Home page, you can access the DBA Data Dictionary page through the following ways:

Expand the Browse eTRM tree node and then click the DBA Data Dictionary folder.
Click the DBA Dictionary tab.

In the DBA Data Dictionary page, you can navigate and locate DBA database objects through the following ways:

Browse DBA objects - Select the Database Schemas or Applications Product Prefixes tree node option from the View By field first. Then expand the selected tree node by clicking a desired schema or product name link depending on your selected tree, and then clicking an appropriate link available on the left pane to locate your DBA objects.
Search DBA objects - Enter search criteria in the Object Name, Schema Owner, and Object Type fields to perform a search.

To understand how to navigate and search desired objects in this page as well as how to drill down from the search results, this section includes the following topics:

Browsing Objects in the DBA Data Dictionary Page

Similar to the browse feature used in the Search and FND Dictionary tabs, the eTRM allows you to browse the tree node to locate DBA objects in the DBA Data Dictionary page.

To browse DBA objects from the tree, select either of the following values from the View By field:

Database Schemas (default)

This option displays all the Oracle E-Business Suite database schemas in the tree.

To locate your desired objects, expand the Database Schemas tree by clicking a desired database schema name link, and then clicking an object type link.

For example, to locate all the objects with the "TABLE" object type from the "APPS" schema, click the "APPS" schema link first to display all the object types contained in the schema "APPS". Then, click the "TABLE" object type link.

On the right pane of the page, objects of the selected type "TABLE" are retrieved and shown in the List of Objects table, with the following search values populated automatically:
- Schema Owner: APPS
- Object Type: TABLE
DBA Data Dictionary Page with Database Schemas Tree Node
Applications Product Prefixes

This option allows you to select a desired product first, and then displays the Database Schemas tree only for the product you selected.

To locate your desired objects:
1. Select a desired product name from the Applications Product Prefixes tree node.
  
  When Applications Product Prefixes is selected, all Oracle E-Business Suite products are displayed in the format of <Application Short Name> - <Application Name> under the tree node.
  
  For example, select a product "ALR_Alert" first to limit the schema display only for the selected product "ALR_Alert".
  
  DBA Data Dictionary Page with Applications Product Prefixes Tree Node
  
  Once a product ("ALR - Alert") is selected from the Applications Product Prefixes tree node, then the Database Schemas tree node appears.
2. Select a desired schema and an object type from the Database Schemas tree node.
  
  Note that the Database Schemas tree now displays the schema names (APPLSYS and APPS) and available object types only for the selected product "ALR - Alert".
  
  DBA Data Dictionary Page with Expanded Database Schemas Tree Node for a Product
  
  For example, select the "TABLE" object type from the "APPLSYS" schema.
  
  The objects that match the selection are retrieved and displayed in the List of Objects table, along with the following search values populated automatically on the right pane:
  - Object Name: ALR%
  - Schema Owner: APPLSYS
  - Object Type: TABLE

After browsing the tree node to locate desired objects, you can click an object name link from the List of Objects table to view the corresponding object details. See: Viewing DBA Object Details.

Searching Objects in the DBA Data Dictionary Page

In the DBA Data Dictionary page, you can perform a search against the DBA Dictionary objects through the following fields:

Schema Owner: Select a desired Oracle E-Business Suite database schema from the list of values. If no value is selected, the search will against all Oracle E-Business Suite database schemas.
Object Name: Enter a desired object name with a wild card character %. The maximum character limit is 30.
Object Type: Select a desired object type from the list of values. The available values for selection are: CLUSTER, CONSUMER GROUP, CONTEXT, DIMENSION, DIRECTORY, EVALUATION CONTEXT, FUNCTION, INDEX, INDEX PARTITION, INDEX SUBPARTITION, INDEXTYPE, JAVA CLASS, JAVA DATA, JAVA RESOURCE, JAVA SOURCE, LIBRARY, LOB, LOB PARTITION, LOB SUBPARTITION, LOCATION, MATERIALIZED VIEW, NEXT OBJECT, OPERATOR, PACKAGE, PACKAGE BODY, PROCEDURE, QUEUE, RESOURCE PLAN, RULE, RULE SET, SECURITY PROFILE, SEQUENCE, SUBSCRIPTION, SYNONYM, TABLE, TABLE PARTITION, TABLE SUBPARTITION, TRIGGER, TYPE, TYPE BODY, UNDEFINED, VIEW, XML SCHEMA, and ALL.

Note that "ALL" is the default value in this field.

Click Search to retrieve the DBA objects that match your search criteria.

For example, to obtain all the database objects for schema "AP", select "AP" as the Schema Owner value and then click Search. The search is performed against all object types contained in the selected schema "AP".

DBA Data Dictionary Page with Search Criteria

the picture is described in the document text

Viewing Search Results

Objects that match the search criteria are retrieved and displayed in the List of Objects table as the search results. This table includes information for each retrieved object, including Object Name, Object Type, Product, and Schema Owner.

Click an object name link to display the selected object details in a separate Object Details page. See: Viewing DBA Object Details.

Note: If a search returns no records, then a message is displayed indicating that no records found for your search.

Note: If the search result does not reflect the changes in the DBA object level for Oracle E-Business Suite Releaes 12.2, then you can run the concurrent program "FND eTRM Populate DBA Search Table" to populate the latest DBA objects and reflect any DBA level changes in the eTRM.

On the left pane of this page, the Database Schemas tree node displays the tree structure that matches the search results. That is, only the schemas and object types that match the results are shown in the tree. In this example, only the "AP" schema and available object types within "AP" are shown in the tree.

Viewing DBA Object Details

Through the search and browse features in the DBA Data Dictionary page or the Search Home page, you can find a list of objects displayed as the search results. Clicking an object name link from the List of Objects table allows you to drill down to the object details page.

For information on how to perform a search or browse the tree node to locate DBA objects, see:

Based on the object you selected from the List of Objects table, you can find the following object details pages for the DBA objects:

Note: Although DBA objects contain various object types, the object details page of each object type discussed here always contains object header and dependency information.