There are many validations Auto-invoice does to create the transaction for the orders in ra_interface_lines_All. Below are the steps to check the validations which are failed if the transaction is not generated after you have run Auto-invoice and its completed.
select * from ra_interface_lines_all
where interface_line_attribute1 = :p_order_number.
get the interface_line_id from the above query and pass it to the below query.
select * from ra_interface_errors_all
where interface_line_id = :p_interface_line_id
The above query will list down the errors where the transaction validations were failed.
Check the data and verify the setups listed in the error.
select * from ra_interface_lines_all
where interface_line_attribute1 = :p_order_number.
get the interface_line_id from the above query and pass it to the below query.
select * from ra_interface_errors_all
where interface_line_id = :p_interface_line_id
The above query will list down the errors where the transaction validations were failed.
Check the data and verify the setups listed in the error.
