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 “Duplicate invoice number”.Run the attached scripts and then check the ra_interface_lines_all table before running autoinvoice program again.Finally invoice will be create in oracle with new invoice number and error information will available in ra_interface_errors_all
Conclusion : Query useful in the oracle receivables to load AR Transactions.
