Tables used in Auto Invoice Master Program

When the Auto invoice program is run, data is populated into the tables listed below.

1. RA_BATCHES_ALL
2. RA_CUSTOMER_TRX_ALL
3. RA_CUSTOMER_TRX_LINES_ALL
4. RA_CUST_TRX_LINE_GL_DIST_ALL
5. RA_CUST_TRX_LINE_SALESREPS_ALL
6. AR_RECEIVABLE_APPLICATIONS_ALL
7. AR_PAYMENT_SCHEDULES_ALL
8. AR_PAYMENT_SCHEDULES_ALL
9. RA_INTERFACE_ERRORS_ALL

Query to check Invoices in Error

SELECT
,ria.line_type
,ria.description
,ria.currency_code
,ria.amount
,ria.trx_date
,ria.quantity
,ria.quantity_ordered
,ria.sales_order
,ria.sales_order_line
,ria.sales_order_date
,ria.inventory_item_id
,riea.interface_line_id
,riea.MESSAGE_TEXT
,riea.org_id
FROM
,ra_interface_errors_all riea
,ra_interface_lines_all ria
WHERE
,riea.interface_line_id = ria.interface_line_id
AND
,riea.org_id = ria.org_id