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

AOL SYLLABUS: PREREQUISITE SQL PL/SQL D2K GENERAL INTRODUCTION KNOW HOW OF ERP Version of Oracle Apps 11i Comparison of 10.7/11...