Expanding nodes and selecting tables, views, stored procedures, and synonyms/nicknames

After you configure all initialization properties for OracleAppsODA, Business Object Designer Express connects to the specified database and displays a tree with all the schema names in the database. These names, which are presented as nodes in the tree, are expandable. Click on them to display all the tables, views and stored procedures in each schema. Figure 7 illustrates this dialog box with some schema expanded.

Figure 7. Tree of schema with expanded nodes

To identify all the database objects that store data for the generated business object definition, select all the required tables and views, stored procedures, and synonyms/nicknames and click Next. For information on how to filter the objects returned, see the Business Object Development Guide.

The schema name ALL SCHEMAS is used to facilitate the retrieval of objects such as tables and views from databases that don't have schemas associated with the objects. When you expand ALL SCHEMAS, a tree is shown with tables, views, stored procedures, and synonyms/nicknames. When each of these nodes is expanded, all the relevant objects from the database appear, regardless of the schema to which the object belongs.

Copyright IBM Corp. 2004, 2005