Friday, 14 April 2017

AP Invoice interface table

AP interface tables 

select * from ap_invoices_interface

select * from ap_invoice_line_interface


AP interface error tables

select * from ap_interface_rejections

select * from ap_interface_controls

AP interface sequence for invoice id 

select ap_invoices_interface_s.nextval from dual

Concurrent program for import invoice from interface table to base tables

Payables open interface import

Run above mention program by passing mandatory parameter and check the output of program with error/success status.  

No comments:

Post a Comment

GL Code combination query in oracle fusion

 select  gcc.Code_Combination_id Account_Code_Combination_Id, CONCATENATED_SEGMENTS Account_Code_Combination,  segment1, segment2, segment3,...