please_complete_offset_account_ra_interface_lines_all
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 “Please complete the offset account assignments” and “Please correct the revenue account assignment”
Run the attached scripts and then check the ra_interface_lines_all table before running autoinvoice program again
and error information will available in ra_interface_errors_all
Conclusion : Query useful in the oracle receivables to load AR Transactions.
please_complete_offset_account_ra_interface_lines_all
please_correct_revenue_account_ra_interface_lines_all
