Payables Interface

http://aporaclepayables.blogspot.com/2016/01/payables-interface.html

insert into ap_invoices_interface
(INVOICE_ID,  
INVOICE_NUM, 
INVOICE_TYPE_LOOKUP_CODE, 
INVOICE_DATE,   
VENDOR_ID,
VENDOR_SITE_CODE,
INVOICE_AMOUNT, 
INVOICE_CURRENCY_CODE, 
TERMS_NAME,
SOURCE,
GL_DATE,  
ACCTS_PAY_CODE_COMBINATION_ID,  
TERMS_DATE,   
operating_unit)

values (AP_INVOICES_INTERFACE_S.NEXTVAL,'08','STANDARD','25-JUL-15','16563',
'?',8000,'PKR','Immediate','LEGACY SYSTEM',   
'25-JUL-15',102769,'25-JUL-15','TEST_1');
commit;
-------------------------------------------------------------------------------

INSERT
INTO ap_invoice_lines_interface
  (invoice_id,
    invoice_line_id,
    line_number,
    line_type_lookup_code,
    amount,
    dist_code_combination_id
  )
  VALUES
  (AP_INVOICES_INTERFACE_S.CURRVAL
   ,AP_INVOICE_LINES_INTERFACE_S.NEXTVAL
   ,1        --<some unique_number>,
   ,'ITEM'   --<ITEM>/<FREIGHT>/<TAX>
   ,8000     --<line_amount> sum of line_amount should always be equal to invoice_amount,
   ,102769
--'<account code>'
  );
COMMIT;

---------------------------------------------------------------------------------------

the invoice will be made in Open Interface Invoices
------------------------------------------------------

Run Payables import interface Program to Import invoices from interface to Invoices Workbench/Invoices.