Transaction Date Cannot be Future Date (Stuck in Transaction Open Interface)

Step 1: Query the record which needs to be updated

SELECT 
TRANSACTION_DATE,  MTI.*  

FROM  MTL_TRANSACTIONS_INTERFACE MTI
WHERE 
TRANSACTION_HEADER_ID='';     ---(From Transaction Open Interface)

Step 2: Update the record

UPDATE MTL_TRANSACTIONS_INTERFACE
SET TRANSACTION_DATE = ''
WHERE TRANSACTION_HEADER_ID =''
AND ERROR_EXPLANATION LIKE 'Transaction date cannot be a future date%';

#oracleebs #prodissues #mtltransactions #ordermanagementr12 #inventoryr12 #query #receivablesr12