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.
Showing posts with label Open Interface. Show all posts
Showing posts with label Open Interface. Show all posts
Oracle Open Interfaces Lession 1
What is an Interface ?
An Interface allows us to Import data from a variety of environments, including our system, previous system data collection devices , external systems, and others in the easiest way possible.
Review the results of import runs, including validation, review update , re imports, and error identification.
Export data from Oracle Applications products for use in other systems.
Interface Tables
Interface Tables: Throughout Oracle Applications products, Oracle Developers have developed Interface tables and programs. Tables allows us to load data, and then to run an Application concurrent program. That concurrent program will take the data from the Interface Table, Validate it, and Import it into our Application Instance.
There are numerous Interface tables in the Oracle Applications products to help with the importation of data.
Application Programming Interfaces(APIs) : API's provide tighter integration to Oracle Applications than can be provided with Interface Tables.
Several Oracle Applications products allow for data upload and download via spreadsheets. The spreadsheet formats are predefined. The mechanics of the upload or download are quite simple.
Oracle Applications also support data uploads and downloads to Oracle Discoverer and word processing files.
Open Interface Overview
Through open interfaces in Oracle Financials, we also can import historical data from our previous accounting, sales order, or other management systems to keep our records consistent and up-to-date. We can review the results of our import run and identify which data has been successfully imported and which errors have occurred during the import process.
We must select a tool for writing a feeder program to extract data from the printed reports, flat file, relational database, or other repository of application information of our existing application system.
Use feeder program to populate an Oracle Application import table with the information we want to introduce to Oracle Financials system.
SQL*Loader is a powerful and easy-to-use tool for writing a feeder program because it helps us to map elements of character delimited or fixed format file, such as a listing or flat file, and to specify which columns of which tables they populate.
An Interface allows us to Import data from a variety of environments, including our system, previous system data collection devices , external systems, and others in the easiest way possible.
Review the results of import runs, including validation, review update , re imports, and error identification.
Export data from Oracle Applications products for use in other systems.
Interface Tables
Interface Tables: Throughout Oracle Applications products, Oracle Developers have developed Interface tables and programs. Tables allows us to load data, and then to run an Application concurrent program. That concurrent program will take the data from the Interface Table, Validate it, and Import it into our Application Instance.
There are numerous Interface tables in the Oracle Applications products to help with the importation of data.
Application Programming Interfaces(APIs) : API's provide tighter integration to Oracle Applications than can be provided with Interface Tables.
Several Oracle Applications products allow for data upload and download via spreadsheets. The spreadsheet formats are predefined. The mechanics of the upload or download are quite simple.
Oracle Applications also support data uploads and downloads to Oracle Discoverer and word processing files.
Open Interface Overview
Through open interfaces in Oracle Financials, we also can import historical data from our previous accounting, sales order, or other management systems to keep our records consistent and up-to-date. We can review the results of our import run and identify which data has been successfully imported and which errors have occurred during the import process.
We must select a tool for writing a feeder program to extract data from the printed reports, flat file, relational database, or other repository of application information of our existing application system.
Use feeder program to populate an Oracle Application import table with the information we want to introduce to Oracle Financials system.
SQL*Loader is a powerful and easy-to-use tool for writing a feeder program because it helps us to map elements of character delimited or fixed format file, such as a listing or flat file, and to specify which columns of which tables they populate.
Subscribe to:
Posts (Atom)
Posts
