Payables Provides several open interfaces to import data
into oracle
- • Payables Open Interface
- • Payables Expense Report Open Interface
- • Payables PCard Open Interface
- • Payables Credit Card Open Interface
- • Payables Matching Open Interface
- • Payables Supplier Open Interface
Payables Open
Interface : Payables open
interface is an interface provided by oracle to import invoices into the system
using various sources such as Auto invoice process, EDI ecommerece gateway, invoices from credit card and
procurement card transactions and invoices from external systems. You can load standard invoices as well as
credit memos using the Payables Invoice Open Interface. Once the invoices are
loaded into the system, Payables Import program can be run to import the
invoices into Oracle
Payables Expense
Report Interface: Accounts payables team can key in paper invoices using the expense reports or employees can
submit their expenses using the invoice
expense report.The payables Invoice Import Report can be submitted to validate
the expense report data and create
expense reports in oracle
Payables PCard Open Interface : Some business can streamline the
procure thopay process by using procurement cards. Employees can purchase the
required items using credit cards and suppliers can send the relevant
information to the payables interface. The payables invoice import program can
be submitted to generate invoices for
these transactions..
Payables Credit
Card Expenses Businesses use SQL loader scripts to load credit card
expenditure related system into the interface tables which can later be
imported into the system to create expense reports. Oracle has predefined the
Loader Scripts for credit cards like : American Express, Visa etc.
Payables Matching
Open Interface: Use SQL*Loader to load the required information into
the purchasing interface tables. You will need to create a SQL*Loader control
file to format the information you want to load. The file you write will vary
greatly depending on the nature and format of the flat file you use. You match
invoices to purchase order shipments during invoice entry.
Payables Supplier
Interface : Businesses use this interface to enter the supplier and
supplier site information in the system. Once the data is entered Payables
Supplier import program can be run to create
suppliers in the system
Hi Ashwini,
ReplyDeleteCan u please mention the interface table names for all the interfaces you have mentioned above?
And another thing is that all the interfaces are talikng about the sources of POs? If yes then which interface should be populated and when?
Hi Tanoy,
ReplyDeleteThe Interfaces you need to populate when creating invoice are:
ap_invoices_interface and ap_invoice_lines_interface .
For the sources , the data is loaded into the table via the loader programs and the sources can be multiple depending on from where you get the data