Bookshelf Home | Contents | Index | PDF |
Siebel Connector for Oracle Applications > Developer Procedures > Understanding the Oracle Applications Wizard > Working with Integration ObjectsSQL integration objects are metadata that define the schema of a table hierarchy in the external Oracle database. These objects contain integration components that map directly to Oracle tables and views. They also incorporate the primary key and foreign key relationships that exist between the tables in the external database. Using Metadata to Create Integration ObjectsAs it creates integration objects, the Oracle Applications wizard retrieves metadata information from FND tables in the external Oracle database. Figure 9 shows the relationship between the Oracle Applications integration objects and the Oracle Applications database tables. NOTE: An Oracle Applications integration object may have SQL as the base object, enabling the Adapter to validate the objects. Obtaining Oracle Application MetadataThe Oracle Wizard uses the DB Adapter to obtain information about Oracle Applications metadata. In this process, the Wizard passes integration objects to the DB Adapter that indicate where and how the Adapter should fetch the information. The Adapter obtains the following Oracle Applications database information for the wizard:
Oracle Tables Containing MetadataThe Wizard uses metadata contained in the following Oracle Applications tables:
See the Oracle Application Technical Reference Manuals for descriptions of these tables. Metadata Integration Objects Used to Query the SQL AdapterThe Oracle Applications wizard uses the following metadata integration objects to query the DB Adapter for needed information:
|
Siebel Connector for Oracle Applications |