AP invoice interface

AP invoice interface, askHareesh blog for Oracle Apps

AP invoice interface

This interface helps us to import vendor invoices into Oracle applications from external systems into Oracle Applications.

Pre-requisites:
  • Set of Books
  • Code combinations
  • Employees
  • Lookups
Interface tables:
  • AP_INVOICES_INTERFACE
  • AP_INVOICE_LINES_INTERFACE
Base tables:
  • AP_INVOICES_ALL – header information
  • AP_INVOICE_DISTRIBUTIONS_ALL – lines info
Concurrent program:
  • Payables Open Interface Import
Validations:
  • Check for valid vendor
  • Check for Source, Location, org_id, currency_code’s validity
  • Check for valid vendor site code.
  • Check if record already exists in payables interface table.
Important Columns:
Some important columns that need to be populated in the interface tables:
AP_INVOICES_INTERFACE:
  • INVOICE_ID
  • INVOICE_NUM
  • INVOICE_DATE
  • VENDOR_NUM
  • VENDOR_SITE_ID
  • INVOICE_AMOUNT
  • INVOICE_CURRENCY_CODE
  • EXCHANGE_RATE
  • EXCHANGE_RATE_TYPE
  • EXCHANGE_DATE
  • DESCRIPTION
  • SOURCE
  • PO_NUMBER
  • PAYMENT_METHOD_LOOKUP_CODE
  • PAY_GROUP_LOOKUP_CODE
  • ATTRIBUTE1 TO 15
  • ORG_ID
AP_INVOICE_LINES_INTERFACE:
  • INVOICE_ID
  • INVOICE_LINE_ID
  • LINE_TYPE_LOOKUP_CODE
  • AMOUNT
  • DESCRIPTION
  • TAX_CODE
  • PO_NUMBER
  • PO_LINE_NUMBER
  • PO_SHIPMENT_NUM
  • PO_DISTRIBUTION_NUM
  • PO_UNIT_OF_MEASURE
  • QUANTITY_INVOICED
  • DIST_CODE_CONCATENATED
  • DIST_CODE_COMBINATION_ID
  • ATTRIBUTE1
  • ATTRIBUTE2
  • ATTRIBUTE3
  • ATTRIBUTE4
  • ATTRIBUTE5
  • ORG_ID

*/