Planning Manager Errors But Shows No Error Message In The Log When Processing Records In Table MRP_SCHEDULE_INTERFACE (Doc ID 1570999.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Materials Requirements Plan.

When attempting to process records in table mrp_schedule_interface, MRCRLF - Planning Manager log file shows Error in the View/Requests form, but in reviewing the log file there are no significant error messages

Example log file:

schedule import has started
The value of profile option 'MRP_SCHED_MGR_BATCH_SIZE' is 10000
The value of profile option 'MRP_SCHED_MGR_MAX_WORKERS' is 1
LOCK TABLE mrp_schedule_interface IN SHARE ROW EXCLUSIVE MODE

UPDATE /*+ INDEX(int1 MRP_SCHEDULE_INTERFACE_N2) */
  mrp_schedule_interface int1
SET request_id = :sql_req_id,
  process_status = 3
WHERE inventory_item_id IN
  (SELECT /*+ INDEX(int2 MRP_SCHEDULE_INTERFACE_N1) */
  inventory_item_id
  FROM mrp_schedule_interface int2
  WHERE int2.request_id IS NULL
  AND int2.error_message IS NULL
  AND int2.process_status = 2
  AND rownum   AND int2.inventory_item_id NOT IN
  (SELECT distinct inventory_item_id
  FROM mrp_schedule_interface rel2
  WHERE rel2.request_id IS NOT NULL
  AND rel2.error_message IS NULL
  AND rel2.process_status = 3))
AND request_id IS NULL
AND error_message IS NULL
AND process_status = 2

....lock table completed 0:00
....Update of interface table rows completed 6,437 0:00
....Retrieved next mrp_schedule_dates sequence number 1 0:00
....IMP-INVALID QUANTITY OR ACTION 0 0:00
....Invalid Transaction Id 0 0:00
....Invalid Organization Id 0 0:00
....Invalid schedule designator name 0 0:00
....Item does not exist or is not an inventory item 0 0:01
....MPS schedules cannot contain items that are not MPS planned 0 0:00
....Item is not planned 0 0:00
....Rate end date is invalid or is before start date 0 0:00
....Cannot load a repetitive schedule entry for a discretely pl 0 0:00
....Invalid schedule date 0 0:00
....Invalid schedule date 0 0:00
....Rate end date is invalid or is before start date 0 0:00
....Transaction id does not exist or belongs to another organiz 0 0:00
....Invalid Project Id 0 0:00
....Invalid Line Id 0 0:00
....Rows updated where schedule date was adjusted to next or pr 0 0:00
....Rows updated where rate end date was adjusted to next or pr 0 0:00
....Rows updated where new schedule date and new rate end date 0 0:00
....Rows deleted from mrp_schedule_dates 6,437 0:00
....Rows deleted from mrp_schedule_dates 0 0:00
....mrlscl_schedule_int_load has inserted 6437 row(s) from MRP_SCHEDULE_ 0:03

***** End Of Program - Planning Manager *****
Successfully resubmitted concurrent program MRCRLF with request ID 677573 to start at 15-JUL-2013 17:29:26 (ROUTINE=AFPSRS)

Setting MRP:Debug Mode = Yes does print more messaging but does not provide any helpful information

The records in mrp_schedule_interface show that they are in process_status = 3 (running) with no error message. The planning manager continues to fail with no helpful information. Users also review the MPS schedule or MDS schedule entries they're trying to import and all they see if the same item, same qty, same date printed over and over again


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Insert records into mrp_schedule_interface
2. Start the Planning Manager
3. Planning Manager fails with no significant error message and records remain in process_status = 3 in the table

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