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.