Friday 6 July 2012

Payables Open Interfaces


Payables Provides several open interfaces to import data into oracle
  1.        Payables Open Interface
  2.         Payables Expense Report Open Interface
  3.        Payables PCard Open Interface
  4.        Payables Credit Card Open Interface
  5.         Payables Matching Open Interface
  6.         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


2 comments:

  1. Hi Ashwini,

    Can 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?

    ReplyDelete
  2. Hi Tanoy,
    The 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

    ReplyDelete