Purge Old Rlm_demand_exceptions Data (Doc ID 1246154.1)

Last updated on AUGUST 09, 2021

Applies to:

Symptoms

RLM: PURGE OLD RLM_DEMAND_EXCEPTIONS DATA

Need to Purge Old RLM_DEMAND_EXCEPTIONS data. Have been purging old RLM
schedules data for a long time now. Company only keeps XX months worth of
RLM Schedule data.

OBSERVATION

However, the table RLM_DEMAND_EXCEPTIONS contains a lot of old data for the
schedules that have been purged already. For most of the exceptions data, the
corresponding schedule lines and headers do not exist any more. There are
millions of rows in the exceptions table that need to be purged/deleted.

Need to know how to remove the old data from the demand exceptions table
for the rows that point to purged schedules.
 
EXPECTED BEHAVIOR
Expect clarification on how to remove the old data from the demand exceptions
table for the rows that point to purged schedules.

STEPS
1. Responsibility: Order Management Super User
2. Purge RLM Schedules
3. Observe: Still old demand exceptions data even for purged schedules, the
    table size is growing.

Changes

Cause

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