What are the Oracle Open Interfaces

Oracle Open Interfaces

____________________________________________________

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

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.

Below are Oracle Interfaces.

1) -  Order Import Interface

2)  - Item Import (Item conversion)

3) -  On-hand Quantity

4)  - Customer Conversion

5)  - Customer API

6)  - Auto Invoice Interface

7) -  Receipt API

8)  - Auto Lockbox Interface

9)  - AP Invoice Interface

10) - Vendor Interface/Conversion

11) - Requisition Import

12) - PO receipts interface

13) - GL Interface

14)  -GL Budget Interface

15) - GL Daily conversion rates

〿〿〿〿〿〿〿〿〿〿〿〿〿〿〿〿〿〿〿〿〿〿〿