AR invoice interface error tables in oracle apps r12

AR invoice interface error tables in oracle apps r12

In this post , We will be discuss about the AR invoice interface error tables in oracle apps r12. AR invoice Interface helps to import or create the AR invoices from external system into the Oracle apps r12.AR Invoice interface error tables helps to store the rejected AR invoices error description which failed to import or create in the Oracle apps.We do get the AR invoices error information from these AR interface error table in oracle apps. Please find below the complete detail and the SQL query using the AR invoice interface error tables in oracle apps r12.

2 Important AR invoice interface error tables

1.RA_INTERFACE_ERRORS_ALL

2.RA_INTERFACE_LINES_ALL

Detail SQL Query using AR invoice interface error tables in oracle apps r12

This below SQL helps to extract the complete error details for rejected AR interface lines. We are using the AR interface error table in this sql query. We can refer this sql query to extract the AR interface error information's in oracle apps r12.

select rila.line_type,rila.description,

rila.amount,rila.waybill_number,

rila.sales_order,rila.sales_order_line,rila.purchase_order,rila.interface_line_CONTEXT,

MESSAGE_TEXT AR_LINE_ERROR_MESSAGE

from apps.ra_interface_lines_all rila,apps.RA_INTERFACE_ERRORS_all riea

where rila.interface_line_id=6628353

and rila.interface_line_id=riea.interface_line_id