Hi all now its time for ap invoice interface.You can use this interface table to insert invoice information into
oracle application table.Check it out!!
For header level entry
Insert into AP_INVOICES_INTERFACE (INVOICE_ID=>ap_invoices_interface_s.nextval,
INVOICE_NUM,
INVOICE_TYPE_LOOKUP_CODE,
INVOICE_DATE,
VENDOR_ID,
VENDOR_SITE_ID,
INVOICE_AMOUNT,
INVOICE_CURRENCY_CODE,
TERMS_ID,
DESCRIPTION,
SOURCE,
GROUP_ID,
PAYMENT_METHOD_LOOKUP_CODE,
PAY_GROUP_LOOKUP_CODE,
ACCTS_PAY_CODE_COMBINATION_ID,
ORG_ID,
LEGAL_ENTITY_ID,
OPERATING_UNIT,
PAYMENT_METHOD_CODE)
for line level entrt
Insert into AP_INVOICE_LINES_INTERFACE(
INVOICE_ID=>ap_invoices_interface_s.nextval,,
INVOICE_LINE_ID=>ap_invoice_lines_interface_s.nextval,
LINE_NUMBER,
LINE_TYPE_LOOKUP_CODE,
AMOUNT ,
DESCRIPTION
)
Note that while submitting :
parameter=>source:should be "Quick Invoices"
Use "payables open interface import" in ap responsibility to import payables information.
good luck!!
