Datafix Script to Delete OE_HEADER_IFACE_ALL Records up to Date: 31-DEC-17
(Doc ID 2474838.1)
Last updated on MARCH 28, 2019
Applies to:Oracle Order Management - Version 12.2.4 and later
Information in this document applies to any platform.
On : 12.2.4 version, Transaction Control
Records showing in the Interface tables "Up-to Date: "
Please suggest if only the below tables will be included in the script :
Confirmed there are approximately 2800+ records in OM Interface in
system in total across multiple Operating Units.
Observed: All orders are closed and workflows have been purged,
but the orders are still appearing in Open interface data fetched
by query :
Requesting a script to cleanup the interface up to 31st Dec, 2017.
1. Responsibility: Order Management Super User
2. Above Interface Tables show OLD data
3. Observed over 2800+ records with following select
4. select *
where CREATION_DATE < '01-JAN-2018'.
5. All records are Closed and Workflow has been Purged
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document