My Oracle Support Banner

Purge Orders Is Not Purging Data From OE_HOLD_RELEASES Table (Doc ID 2424404.1)

Last updated on JULY 18, 2018

Applies to:

Oracle Order Management - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Transaction Control
Find that order purge was is not purging the hold related data from OE_HOLD_RELEASES Table.This is leaving orphan records in OE_HOLD_RELEASES Table and it is growing bigger .
Data gets purged  successfully from OE_ORDER_HOLDS_ALL and OE_HOLD_SOURCES_ALL except OE_HOLD_RELEASES .

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!


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