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.