ERPstuff - Oracle EBS Community

Hi everybody

Can anybody tell me which tables are populated(at header and line level) in AP and AR when the Open Interface Standard programs are executed

regards
prema

Hi

To import invoices through the open interface, you must
populate the AP_INVOICES_INTERFACE and
AP_INVOICE_LINES_INTERFACE tables.
Once the import process is complete, the data from the
interface tables will be in the AP_INVOICES_ALL and
AP_INVOICE_DISTRIBUTIONS_ALL tables.

For AR

You Need to populate
ra_interface_lines_all
RA_INTERFACE_DISTRIBUTIONS_ALL
RA_INTERFACE_SALESCREDITS_ALL

Hope this helps

Regards
Sivakumar

Hi,
The following base tables will be populated with data for AP and AR Invoices Interfaces:
For AP:
1) ap_batches_all (if batch controll is using)
2) ap_invoices_all
3) ap_invoice_distributions_all
4) ap_payment_schedules_all

For AR:
1) ra_batches_all
2) ra_customer_trx_all
3) ra_customer_trx_lines_all
4) ra_cust_trx_line_gl_dist
5) ra_cust_trx_line_salesreps
6) ar_payment_schedules_all
7) ar_receivable_applications
ar_adjustments

Hope this will hwlp

Thanks
Best Regards
ramkic

thanks a lot