AP invoice interface

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