ERPstuff - Oracle EBS Community

Hi

I have requirement to develop a custom report to daily list all the rejected invoices based on the AR interface table.

From what i know

ra_interface_lines_all
ra_interface_sales_credits
ra_interface_distributions

is interface tables for AR but i am not able to figure out how to know which one is rejected invoice? what flag to look at and which table?

cheers
Arvin

Hello.
INTERFACE_STATUS (from RA_INTERFACE_LINES_ALL)
This column is used by AutoInvoice and should be left null. If AutoInvoice sets this column to ?P? then the line has been transferred successfully.

Octavio