18042430 Internal Order Quantities Messed Up After Rescheduling Partially Received IR (Doc ID 1915879.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Materials Requirement Planning - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.2 version, Materials Requirements Plan.

Users are running a DRP plan within the MRP module. They generate internal requisitions (IR's) and internal sales orders (ISO's) between organizations. There are times when they will ship partial quantities on the ISO and receive same quantity on the IR. This goes smoothly and without problem. They then run the DRP plan and the appropriate changes are picked up by the DRP plan as expected. The problem comes when an IR in this condition (remaining quantity) has a reschedule in or rescheduled out action message. Users will release this action from the DRP workbench.

Please note that profile POR: Sync up Need by date on IR with OM = Yes

This inserts a record into table po_reschedule_interface and then calls concurrent request POXRSR module: Reschedule Requisitions which processes this change and is successful. However while the date change occurs successfully on the IR/ISO, the quantity on both becomes corrupted. Example:

A. For a particular item the initial quantity on the IR/ISO = 20. Ship quantity = 12 on the ISO. This splits the the ISO line into two lines (line 1.1 is the qty = 12 that's shipped/closed. Line 2.1 is the remaining qty = 8 yet to be shipped

B. Receive the qty = 12 on the IR into on hand. The IR will show in the Requisition Summary form Quantity = 20 (original qty of the IR) and Qty Delivered = 12 which is correct

C. Rerun the DRP plan - the changes are picked up and now we show IR/ISO with qty = 8. Now at this point because of demand/supply changes, there will be reschedule in messages for the IR

D. Disable POXRSR module: Reschedule Requisitions to capture the record when released from the DRP workbench in table po_reschedule_interface

E. Release the IR change from the DRP workbench based in Reschedule In message. Record is inserted into po_reschedule_interface. What we found on this record which may be part of the problem is only the following columns were populated:

line_id = 904083
Quantity = 8
Need_by_date = 07-JAN-2014
last_update_date = 22-DEC-2013
last_updated_by = 15893
creation_date = 22-DEC-2013
created_by = 15893

All other columns are NULL including ORIG_QUANTITY and ORIG_NEED_BY_DATE. Not certain this is the problem but it could be

F. Enable and run POXRSR module: Reschedule Requisitions manually. This processes the record in the table and removes it as request was successful

G. Review the ISO: Line 1.1 for qty = 12 is still there as it's shipped and closed. However Line 2.1 originally had qty = 8 now shows qty = 4

H. Review the IR: Quantity changed from 20 to 8 (original quantity) and Qty Delivered stays the same = 12

I. Rerunning DRP plan with these changes results in new planned orders due to the corrupt qty changes in the existing IR/ISO

Please note that support tried this in 3 different internal instances but for whatever reason, releasing the IR change from the DRP workbench did not generate a record in po_reschedule_interface

EXPECTED BEHAVIOR
-----------------------
Expect the quantities on the IR/ISO Not to change at all. The only thing expected to change is appropriate date

Cause

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