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.
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
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms