"Stuck in the Interface" , Invoice not created in AR and no error is showing in the interface. (or) The AutoInvoice Master Program (RAXMTR) may complete without error but will not spawn the AutoInvoice Import Program. And Sales Order Line status is "closed"

Verify that the Request ID is null on the transactions to be imported, If the request_id is not null then any run of Auto invoice with a different request id will ignore that line. Now Receivables Module, we need to clear the request IDs so that Autoinvoice can pick up the line.

Accounts Receivables Navigation: Control --> Autoinvoice --> Interface Lines.

Ensure you clear the request ids for all below fields.

• request_id
• SET interface_line_id
• customer_trx_id
• ink_to_line_id

Or use the SQL Script to clear the request ID's

UPDATE ra_interface_lines_all

SET interface_line_id = null,

customer_trx_id = null,

request_id = null,

link_to_line_id = null

WHERE nvl(interface_status,'x') != 'P';

Once you delete the Request ID's . Rerun Auto invoice master program and check it.