My Oracle Support Banner

Datafix 10109415 - Purge Old Rlm_demand_exceptions Data (Doc ID 1246154.1)

Last updated on APRIL 25, 2018

Applies to:

Oracle Release Management - Version: 11.5.10.2 and later   [Release: 11.5.10 and later ]
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2 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.



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
-----------------------
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.


BUSINESS IMPACT
-----------------------
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.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.