AP invoice interface tables

AP invoice interface tables

Oracle application has provided AP invoice interface to import invoices from External system to the Oracle Application. With the Help to AP invoice interface , we create Oracle AP invoices from External System. AP invoice Interface also helps to do the Integration of Oracle application  with the External System. Oracle has provided AP invoice interface tables , in which we put the External invoices information as a records and then run the standard Payables Open interface import program to import these records from Interface table to the Oracle Payables Base Tables.

 

These are the two tables of AP Invoice Interface. These tables uses to import AP invoices from External System to the Oracle application.

 

 

For example , This is the Invoice Test Data which we got from the External System and how i will insert this Data in these Two Interface tables As Below.

 

 

 

AP_INVOICE_INTERFACE :-

 

We will create Single record for Each Invoice in this AP invoice Interface table. Like for above Example , where we have two lines for Single Invoice but we will insert Single record in this Interface table for this above case.

 

AP_INVOICE_LINES_INTERFACE:-

In this table , We creates multiple Lines for the Single Invoice as like above case , We will create two records for the Invoice 'A001'.

 

AP invoice interface tables Example :-

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

 

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