Sunday, 8 July 2018

Oracle MTL_TRANSACTION_INTERFACE - Locking Issue Resolve Query

UPDATE mtl_transactions_interface
    SET
        process_flag = 1,
        lock_flag = 2,
        transaction_mode = 3,
        validation_required = 1,
        error_code = NULL,
        error_explanation = NULL
WHERE
    process_flag IN (1,3);

No comments:

Post a Comment