-- Execute the below query to update with item details and process this.

UPDATE APPS.RA_INTERFACE_LINES_ALL
  SET REFERENCE_LINE_ATTRIBUTE15 = ( SELECT NEW_DISTRICT_CODE FROM OLD_NEW_DISTRICTS
                                      WHERE OLD_DISTRICT_CODE =REFERENCE_LINE_ATTRIBUTE12 
                                        AND ATTRIBUTE1 ='IT')
	 ,REFERENCE_LINE_ATTRIBUTE1  = (SELECT NEW_DISTRICT_CODE 
	                                  FROM OLD_NEW_DISTRICTS
                                     WHERE OLD_DISTRICT_CODE =REFERENCE_LINE_ATTRIBUTE12 
                                       AND ATTRIBUTE1 ='IT')
     ,INVENTORY_ITEM_ID          = (SELECT DISTINCT INVENTORY_ITEM_ID 
	                                  FROM APPS.MTL_SYSTEM_ITEMS_B 
                                     WHERE SEGMENT1 = REFERENCE_LINE_ATTRIBUTE11||' - '||(SELECT NEW_DISTRICT_CODE 
								                                                            FROM OLD_NEW_DISTRICTS
                                                                                           WHERE OLD_DISTRICT_CODE =REFERENCE_LINE_ATTRIBUTE12 
                                                                                             AND ATTRIBUTE1 ='IT'))
WHERE Interface_line_id in 
(select ril.interface_line_id
  from apps.ra_interface_errors_all riea,
       apps.ra_interface_lines_all ril
  where riea.interface_line_id = ril.interface_line_id
    and ril.interface_line_context like 'IT%'
    and message_text is not null
	and message_text = 'Please complete the offset account assignments')
;

COMMIT;


-- execute the autoinvoice master program. if the error still not solved, 
--then check whether the inventory item id populate . if not populated, it seems
-- item may not exists in the system or item may not be active.

select REFERENCE_LINE_ATTRIBUTE11||' - '||(SELECT NEW_DISTRICT_CODE 
								             FROM OLD_NEW_DISTRICTS
                                            WHERE OLD_DISTRICT_CODE =REFERENCE_LINE_ATTRIBUTE12 
                                            AND ATTRIBUTE1 ='IT') item,
	    TRX_NUMBER,
		AMOUNT,
	(SELECT DISTINCT INVENTORY_ITEM_ID 
	   FROM APPS.MTL_SYSTEM_ITEMS_B 
      WHERE SEGMENT1 = REFERENCE_LINE_ATTRIBUTE11||' - '||(SELECT NEW_DISTRICT_CODE 
								                            FROM OLD_NEW_DISTRICTS
                                                           WHERE OLD_DISTRICT_CODE =REFERENCE_LINE_ATTRIBUTE12 
                                                              AND ATTRIBUTE1 ='IT')) INVENTORY_ITEM_ID
  from apps.ra_interface_errors_all riea,
       apps.ra_interface_lines_all ril
  where riea.interface_line_id = ril.interface_line_id
    and ril.interface_line_context like 'IT%'
    and message_text is not null
	and message_text = 'Please complete the offset account assignments'
	;
 -- Provide the above details to Functional team to check and inform us to after corrective action from their side.