Purge Old Rlm_demand_exceptions Data
(Doc ID 1246154.1)
Last updated on AUGUST 09, 2021
Applies to:Oracle Release Management - Version 18.104.22.168 and later
Information in this document applies to any platform.
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.
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.
Expect clarification on how to remove the old data from the demand exceptions
table for the rows that point to purged schedules.
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.
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