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

Interview Question in Oracle OTBI Report

What is Subject Area In OTBI, a Subject Area is a logical view of business data. Under a Subject Area, we have multiple folders , which are...