In this post we will discuss on important AP Invoice Interface table in Oracle Apps R12, Oracle has provided AP Invoice interface table to import external invoice into Oracle database.
Important AP Invoice Interface table in Oracle Apps R12
AP_INVOICE_INTERFACE: This table stores single records against each invoices.
AP_INVOICE_LINES_INTERFACE: This table stores stores Invoice line level information, this table can stores multiple lines of each invoices.
Script to insert records in AP Invoice interface tables
--Inserting records in ap_invoice_lines_interface table INSERT INTO ap_invoice_lines_interface ( invoice_id, invoice_line_id, line_number, line_type_lookup_code, amount, accounting_date, dist_code_combination_id, creation_date, created_by, last_update_date, last_updated_by ) VALUES( v_invoice_id, v_invoice_line_id, v_line_no, v_line_type, v_amount, v_accounting_date, V_CODE_COMBINATION_ID, sysdate, FND_GLOBAL.user_id, sysdate, FND_GLOBAL.user_id ); --Inserting records into ap_invoices_interface table INSERT INTO ap_invoices_interface ( invoice_id, invoice_num, invoice_type_lookup_code, invoice_date, vendor_id, vendor_site_id, invoice_amount, invoice_currency_code, description, status, source, creation_date, created_by, last_update_date, last_updated_by ) VALUES ( v_invoice_id, v_invoice_num, v_inv_type, v_invoice_date, v_vendor_id, v_vendor_site_id, nvl(v_invoice_amount,0), v_invoice_curr, v_description, 'NEW', 'TEST SOURCE', sysdate, FND_GLOBAL.user_id, sysdate, FND_GLOBAL.user_id );