What Is The Functional Impact If Move Order Headers Are Deleted By Mistake ? (Doc ID 2269888.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle Inventory Management - Version 11.5.10.CU2 and later
Information in this document applies to any platform.

Goal

After running the Move Order Purge program for one year old data, the following data fix is ran by mistake for sysdate-3.
It deleted few more move order header records.

Is there any functional impact because of this?

Create table ora_mtrh_backup as
select * from mtl_txn_request_headers mtrh
where not exists
(select 1 from mtl_txn_request_lines mtrl where
mtrl.header_id=mtrh.header_id)
and mtrh.creation_date < sysdate - 3;

delete from mtl_txn_request_headers mtrh where
mtrh.header_id in (select omtrh.header_id
from ora_mtrh_backup omtrh
where
omtrh.header_id=mtrh.header_id);

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms