Purge Old Rlm_demand_exceptions Data
(Doc ID 1246154.1)
Last updated on FEBRUARY 20, 2019
Applies to:Oracle Release Management - Version 220.127.116.11 and later
Information in this document applies to any platform.
On : 18.104.22.168 version,
Need to Purge Old RLM_DEMAND_EXCEPTIONS data. Have been purging old RLM
schedules data for a long time now. Company only keeps 4 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.
The issue can be reproduced at will with the following 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.
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