Header : Load data into oracle receivables transactions
Usage of Heading : Useful to collect amount from customers that has been consumed through invoice number/Trx Number
Description of post :
Business mostly load AR transactions through inbound program by creating custom tables and load data from table into interface table after some validations.
When we run autoinvoice master program while uploading receivable transactions we will get error like “Ensure that supplied rule start date will generate GL Dates that are in Open or Future periods when the GL Date in a Closed Period option is set to Reject in the Transaction Sources window. ”
To overcome this we have take start date of the month and then have update ra_interface_lines_all table and error information will available in ra_interface_errors_all
Conclusion : Query useful in the oracle receivables to load AR Transactions.