Request ID Stuck in AR Interface Lines

SYMPTOM:- When importing sales order from Order Management to Receivable, 'Auto-invoice Import Program' goes in error. Resulting in request id of 'Auto-invoice Import Program' got stored in receivable interface lines and unable to import order in receivables.

Analysis: The standard error due to which this issue occurs is that at time of 'Third Party Registration' of customer where registration number is entered incorrect, which leads in error-ed out of 'Autoinvoice Import Program'.

SOLUTION:-

Alternative 1 :-  

1. Do RMA for that particular sales order which will bring back the quantity of the item into the inventory. And delete both record of sales order and RMA order from receivable interface lines 
2. Correct the registration number at 'Third Party Registration Level'.
3. Create the sales order again and import it in receivables. 

Alternative 2 :-

create table RA_INT_LIN_BKP

as

select *

from RA_INTERFACE_LINES_ALL

where INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'

and INTERFACE_LINE_ATTRIBUTE1 = ''    ------(with Order Number)

and INTERFACE_STATUS is null;

-- 1 row should be backed up

create table RA_INT_SCR_BKP

as

select *

from RA_INTERFACE_SALESCREDITS_ALL

where INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'

and INTERFACE_LINE_ATTRIBUTE1 = ''    ------(with Order Number)

and INTERFACE_STATUS is null;

-- 1 row should be backed up

update RA_INTERFACE_LINES_ALL

set REQUEST_ID = null

where INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'

and INTERFACE_LINE_ATTRIBUTE1 = ''         ------(with Order Number)

and INTERFACE_STATUS is null;

-- 1 row should be updated

update RA_INTERFACE_SALESCREDITS_ALL

set REQUEST_ID = null

where INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'

and INTERFACE_LINE_ATTRIBUTE1 = ''         ------(with Order Number)

and INTERFACE_STATUS is null;

-- 1 row should be updated

commit;

Now re-run 'Autoinvoice Import Program' and now it will let us import from data from interface lines.

(NOTE: If using alternative 2, then data will be imported correctly but with incorrect registration number, which we can check it in 'India Tax Details' form as shown by below steps)

• Open 'India Tax Details Form'.
• Click on Tax Rate Name.
• Go to Help--Diagnostics--Examine
• Search 'THIRD_PARTY_PRIMARY_REG_NUM' in field column and check registration number.

#EBSR12 #receivablesR12 #datafix  #autoinvoiceimport #oracle #salesorder #arinvoice #arinterfacelines