ERPstuff - Oracle EBS Community

Can any one explain about the interface tables in Account payables and purchasing in financials


Madhu

<b>AP Interface Tables</b>

SQL*Loader to load invoice information into the interface tables, AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE. When you initiate importing invoices, the import program validates all required invoice data in these tables. After it validates the information, Payables Open Interface Import creates invoices from the information in the Payables Open Interface tables. Payables also creates scheduled payments based on the payment terms.

<b>PO Interface Tables</b>

Create Purchase Order for the Item
- Creation of Purchase Orders (PO_HEDERS_INTERFACE , PO_LINES_INTERFACE, PO_DISTRIBUTIONS_INTERFACE)

Receive PO
- Receiving Transactions (RCV_HEADERS_INTERFACE,RCV_TRANSACTIONS_INTERFACE)

Hi,

I think the earlier reply from co-member would have helped you knowing the interfaces available. Let me give you an idea of what is an interface.

The term Open Interfaces actually refers a programming interface, usually a database table, that automates the execution of Oracle APIs.

Open Interfaces provide a single, simple interface for a specified business procedure.

These are called as a collection of ?Black Box? interfaces that provide programatic access into the Oracle ERP database.

The term API refers to stored procedure driven interfaces, where you call a stored procedure to perform an action within an Oracle Module, and the data from your external application is passed through the stored procedure?s parameters.

Thanks.

Vijayasarathy R
Vijayasarathyr@gmail.com