After configuring connection properties, run a query for database objects. You can browse the metadata tree structure to understand the structure of the objects in the enterprise information system (EIS), and select objects needed for the service description. For this sample, you run a query on the applications (APPS) schema and select the stored procedure that the business object will represent.
- Specify filter properties
In the Find and Discover Enterprise Services window, click Edit Query. In the Query Filter Properties window, type APPS in the Schema Name Filter property field to display the applications (APPS) schema.
The Types property field lists the entries: tables, views, stored procedures, and synonyms - nicknames. Remove the nodes for tables, views, and synonyms - nicknames, and click OK.
- Run the metadata query
- Display objects covered by the query
Click Execute Query. The APPS schema and data elements of the schema are displayed in the top pane.
- Select the object for import
Expand the APPS schema. Click Stored Procedures but do not expand them. Use a filter to help you locate and select the stored procedure.
Click the filter button. In the Filter Properties window, type EXECUTABLE in the Object Name Filter field and click OK.
Expand the
Stored Procedures node and select
FND_PROGRAM.EXECUTABLE from the list of stored procedures. Click
Add to Import List.
Note: Because of the high number of stored procedures, the list might not be populated immediately.
From the Configuration Parameters for FND_PROGRAM.EXECUTABLE window, click OK.
.
Terms of use |
Last updated: Mon 30 Oct 2006 03:46:26
(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)