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.

Requisition Not Getting Imported for Drop Shipment Order

Step 1:You will need to run: 
select * from PO_Requisitions_interface_all 
and see what the transaction_id is 
Then run 
update po_requisitions_interface_all 
set request_id = null 
, process_flag = null 
where transaction_id = (from above) 
Then rerun the Requisition Import. 

Step 2:Please run Run "Requisition Import Exceptions Report" & choose yes in delete exceptions in parameter.

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.