Error in Line Number 1 - jai_rgm_claims_pkg.get_term_id => Location ID cannot be NULL- IRTP concurrent error message.

Error in Line Number 1 - jai_rgm_claims_pkg.get_term_id => Location ID cannot be NULL- IRTP concurrent error message.

RMA Sales order receipt’s India – Receiving Transaction Processor concurrent completed with Error.

Issue: 1. Receipt details not updated in RG register Part 2 and Part II.

             2. Cenvat on receipt not completed against the Receipt.

            3.  Accounting entries not generated for India localization transactions

 

Solution: 

Location_id is NULL against the shipment_header_id. Update the Location id and rerun the India Receiving Transaction Concurrent.

Script for update the location_id in RCV_TRANSACTIONS Table against the Shipment_header_id

Update RCV_TRANSACTIONS
set Location_id = 176
where
location_id is null and
shipment_header_id = 367630;

Script for update the location_id in JAI_RCV_TRANSACTIONS Table against the Shipment_header_id

UPDATE JAI_RCV_TRANSACTIONS
SET Process_Status = '' ,
CENVAT_RG_STATUS = '',
RECEIPT_NUM=NULL,
Process_Vat_Status = NULL,
Process_Vat_Message = NULL
where shipment_header_id = 367630;

 

Script for update the location_id in JAI_RCV_LINES Table against the Shipment_header_id

UPDATE jai_rcv_lines
SET tax_modified_flag ='Y'
WHERE shipment_header_id = 367630;

Commit

Now Run the “India –Receiving Transaction Processor” concurrent with Organization and Receipt number parameter.