When creating or updating Discrete Jobs unnecessary MRP_RELIEF_INTERFACE records are created which leads to excess MRP/MPS relief records (Doc ID 1632167.1)

Last updated on JANUARY 23, 2025

Applies to:

Symptoms

MRP/MPS relief

When creating Discrete Jobs, unnecessary MRP_RELIEF_INTERFACE records are created which leads to unnecessary MRP/MPS relief records

This issue does not affect the MPS quantity but the relief history records are showing records with positive and negative quantity for the discrete job on Master Production Schedule Reliefs form.
This issue occurs when Discrete Job start date and completion date are different date.

STEPS
-----------------------
1. Create Discrete Job

Job: 285413
MRP Net : 5
Start      : 04-MAR-2014 06:00:00
Completion : 06-MAR-2014 14:00:00

2. Check record created in MRP_RELIEF_INTERFACE. 2 record are being created for single relief.

 select * from MRP_RELIEF_INTERFACE where disposition_id = 805084;

TRANSACTION_ID  NEW_ORDER_DATE  OLD_ORDER_DATE  DISPOSITION_ID   NEW_ORDER_QUANTITY  OLD_ORDER_QUANTITY
------------------------------------------------------------------------------------------------------------
3129804         04-MAR-14       (NULL)          805084           5                   (NULL)
3129805         06-MAR-14       04-MAR-14       805084           5                   5

3. Check Master Production Schedule Reliefs form. 3 record are being created for single relief.

MRP
(N)MPS > Names > Items(B) > Detail(B) > Relief(B)

Order Type   Order Number  Schedule Date   Order Date    Order  Relief
-------------------------------------------------------------------------------------------
Work Order   285413        10-MAR-2014     06-MAR-2014   5       5
Work Order   285413        10-MAR-2014     04-MAR-2014   5      -5 <========== ★
Work Order   285413        10-MAR-2014     04-MAR-2014   5       5 <========== ★

The above 2 records (Relief = -5 and 5) are not necessary.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.