Oracle Open Interfaces Lession 4

Purchasing Open Interfaces
Receiving , Open Requisitions , Purchasing Documents
Open Requisitions helps you automatically import and review requisitions from other Oracle Applications or other systems, approve or reserve funds for them, place them on purchase or internal sales orders, and integrate Oracle Purchasing quickly with new or existing applications such as material requirements planning, inventory management, and production control systems. Oracle Purchasing automatically validates data and imports your requisitions.
Purchasing documents helps automatically import and validate price/sales catalog information and responses to requests for quotation (RFQs) from suppliers and convert the data in the Purchasing documents open interface tables into blanket purchase agreements or catalog quotations in Purchasing. It uses application programming interfaces to process catalog data in the Oracle Applications Interface tables to ensure that it is valid before importing it into purchasing.
Receiving helps you automatically import and validate receipt data, such as Advance Shipment notices, from other Oracle Applications and integrate Oracle Purchasing quickly with new or existing applications, such as loading barcoded and other receiving data from scanners and radio frequency devices. It maintains new and existing receipt data integrity.

Payable Open Interfaces
.AP_INVOICES_INTERFACE
.AP_INVOICE_LINES_INTERFACE
.Expense Report Interface
.Payables Procurement Card Transactions Interface
.Supplier Open Interface

Payables Open Interface - Uses invoice data stored in the Payables Open Interface tables to create invoices to import into Payables. The invoice data is from invoices entered in the Invoice Gateway window, invoices from you suppliers loaded by e-Commerce Gateway, rent invoices from Property Manager,, Lease Payment invoices from Oracle Assets, Invoices that you loaded with Oracle SQL loader and credit card transaction data. Oracle Payables provides sophisticated purchase order matching feature to ensure that you only pay for goods and services you ordered, received and accepted.

Expenses Report Interface - Used to import Expense Reports into Payables, Contains functionality that will create supplier records for employees on submission of the first expense report.

Payables Procurement Card - Transaction Interface: Submit the Procurement Card Transaction validation report, for records where the CREATE_DISTRIBUTION_FLAG is set to Y, Payables uses the data in the AP_EXPENSE_FEED_LINES table to create distributions with proper accounts in the AP_EXPENSE_FEED_DISTS table, uses the data in this table to confirm transactions with your employees and managers. After Employees and managers have verified and approved the transactions, you submit the Procurement Card Invoice Interface Summary tables and optionally summarize the interface import program to create invoices from the data.

Supplier Open Interface- Used to input Supplier records for use in Payables and Purchasing Payables has three new supplier open interface tables. Each interface table corresponds to one of the Oracle Purchasing supplier tables.

AP_SUPPLIERS_INT for importing supplier level information
AP_SUPPLIER_SITES_INT is for importing supplier site information
AP_SUP_SITE_CONTACT_INT is for importing supplier site contact information.

Oracle Open Interfaces Lession 3

General Ledger Open Interfaces
Importing Journals
Loading Daily Rates
Uploading Budgets

We can use theree open interfaces available for General Ledger to bring information from other Oracle Applications or from non Oracle Applications and data source into General Ledger.

GL_Interface
Use this Journal Import to integrate data from other application with Oracle General Ledger and import historical data from your previous accounting system.

Journal Import creates journal entries from accounting data you import from Oracle and other application feeder systems. For each accounting period, we can import accounting data from other journal entry. The journals are created from the GL_INTERFACE table. All data in the interface table is validated before a journal entry is created.

GL _DAILY_RATES_INTERFACE
Use the GL_DAILY_RATES_INTERFACE table in Oracle General Ledger to insert, update, or delete daily rates automatically in the GL_DAILY_RATES table. GL validates the rows in the interface table before making changes in the GL_DAILY_RATES table. Do no load rates directly into the GL_DAILY_RATES table to avoid data corruption. We do not need to run any import programs. We only need to develope a process that populates the interface table with daily rates information.

Uploading Budgets
Navigation - Budgets ->Enter ->Upload
Budget upload lets you prepare and analyze your budget outside of Oracle General Ledger, such as on a personal computer using a spreadsheet program, and then transfer your budget information into Oracle General Ledger.
If you have Microsoft excel installed, you can use Oracle Applications Desktop Integrator ADI to create budget worksheets in Excel, view and modify your budget information, and then upload revised budget information to Oracle General Ledger automatically.

GL_BUDGET_INTERFACE
table to upload budget data into Oracle General Ledger from a spreadsheet or other external source.
Each row includes the budget amounts for once account for once fiscal year by period.
When we load this table
Account combinations in SEGMENT columns must agree with your chart of accounts structure.
Budget amounts must be in the appropriate AMOUNT columns.

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.

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.