My Oracle Support Banner

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.

Symptoms

On : 12.2.4 version, Transaction Control

ACTUAL BEHAVIOR
Records showing in the Interface tables "Up-to Date: "

Please suggest if only the below tables will be included in the script :
OE_HEADERS_IFACE_ALL
OE_LINES_IFACE_ALL
OE_PRICE_ADJS_IFACE_ALL
OE_PRICE_ATTS_IFACE_ALL
OE_CREDITS_IFACE_ALL
OE_LOTSERIALS_IFACE_ALL
OE_RESERVTNS_IFACE_ALL
OE_ACTIONS_IFACE_ALL
OE_CUSTOMER_INFO_IFACE_ALL
OE_PAYMENTS_IFACE_ALL

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 :

EXPECTED BEHAVIOR
Requesting a script to cleanup the interface up to 31st Dec, 2017.

STEPS
1. Responsibility: Order Management Super User
2. Above Interface Tables show OLD data
3. Observed over 2800+ records with following select
4. select *
  from oe_headers_iface_all
  where CREATION_DATE < '01-JAN-2018'.
5. All records are Closed and Workflow has been Purged

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.