Datafix 10109415 - Purge Old Rlm_demand_exceptions Data
Last updated on APRIL 25, 2018
Applies to:Oracle Release Management - Version: 18.104.22.168
Information in this document applies to any platform.
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.
The issue has the following business impact:
Due to this issue, table size is growing and does not need to have all these demand exceptions
pointing to old purged schedules.
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 hundreds of Community platforms