Error while Incomplete AR Invoice, APP-AR-11526: ENCOUNTERED AN ERROR IN JAI_AR_TAX_DEP_PKG. dETERMINE_MANUAL_ar_tax

Download & Apply the following Patch: 26410637:R12.JAI.B and Test it.

After Ship Confirmation, The Delivery status is closed but Sales Order status is "Picked". After running Interface Trip Stop SRS program again but Sales Order line is Still with "Picked" Status. Unable to interface the Sales Order

Solution: It's Foreign Currency Sales order. Currency Conversion Type and Conversion Rate are not defined at the Sales Order Level. Now, Updated Conversion Types and Currency Rate. and Rerun Interface trip Stop SRS Program, The sales order line status will changed to "Shipped" and then Run workflow background program, Now the status of sales Order will change to" Closed". Now run the autoinvoice master program, the invoice will be successfully imported to Accounts Receivable.

In India - Debtors Ledger Report particular customer Name and customer No is not found.

Solution: The user has not not created customer in Customer additional info Form. After creating the same, the name of that particular customer appeared in the India - Debtors Ledger Report parameters.

Sales Order line status is "Awaiting Invoice Interface - Incomplete Data". Unable to create RMA Credit Memo in AR

Solution 1:
Query the Sales Order, The Sales order Line status will be " Awaiting Invoice Interface - Incomplete Data"
Now go to 'Actions' > 'Progress Order' > Choose 'Invoice Interface - Eligible'.

Then Sales Order Line Status will be"Closed"

Now the 'Autoinvoice Master Program' and 'Autoinvoice Import Program' will be launched automatically. Check the invoice in the AR.

Solution 2:
Query your OM Transaction Type and check whether AR Transaction Source and Transaction Type are assign to it or not.
If not assigned, assign it and run the workflow background process program.
Now the 'Autoinvoice Master Program' and 'Autoinvoice Import Program' will be launched automatically, and invoice will be generated.

"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.