Datafix 10109415 - Purge Old Rlm_demand_exceptions Data
(Doc ID 1246154.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Release Management - Version: 220.127.116.11
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.
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|