Oracle Open Interfaces Lession 2

Open Interface Model
Source Applications - This feeder system supplies data you want to import into Oracle Applications. For example, the source application for Oracle General Ledger journal import may be Oracle Receivables or another Oracle Receivable application.

Interface Table- The intermediary table where the data from your source application temporarily resides. We enter data into this table to load data into an Oracle Application.

Validate Function- A Set of programs used by Oracle Applications to ensure the inbound data integrity before data is moved from the interface table to the permanent application tables. It inserts rows into the error table or updates the error column in the interface table if validation fails. It resides in the destination application.

Load- A Set of programs that selects and accumulates data from your source application and inserts them into the Oracle Application interface table. Its programming languages and tools depend on the hardware and system software of your source application. For example , Oracle functions that load an open interface are written in Pro*C or PL /SQL. If you are importing data from a non Oracle Application, you would probably use a procedural language available on the source application, convert it into an ASCII file, and use SQL*Loader to insert the data into the Oracle Interface table.

Process Function - Residing in the destination application, this import function is the set of programs that processes data from the interface table into the destination tables, inserts rows into the errors table, or updates the error column in the interface table if processing error are encountered. With the Validate function, it is frequently invoked through the same concurrent process. Rows are validated first before processed.

Errors Table - Stores all errors found by the validate and Process function; shows several errors for the same data row at once; resides in the destination application; can be shared by several open interface tables in an application. In addition, some oracle Applications open interfaces use error columns in the Interface table and a log/report file to list the error. For example Oracle General Ledger Journal import always generates a report. Entries is an error table or report are the output of the Validate process.

Maintain Function- A form based program residing in the destination application, to query update and resubmit interface table rows, In its absence in some Oracle Applications interfaces, we can review the log file or report for errors or use SQL*PLUS to query and correct errors, such as deleting such as deleting all rows in the interface table, fixing the problem in the LOAD function and reimporting.