AP Invoice Interface Table in Oracle Apps R12 - Orapoint

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
				);