My Oracle Support Banner

Planning Manager Errors But Shows No Error Message In The Log When Processing Records In Table MRP_SCHEDULE_INTERFACE - Also Seen After Upgrade to 12.2.8 and Higher (Doc ID 1570999.1)

Last updated on JUNE 21, 2023

Applies to:

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


For 12.1.3 - Symptoms were - 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

For 12.2.8 and higher after upgrade from earlier release - after starting the planning manager, it errors with no error message in the log and resubmits again and again after first cycle  - similar log messages as shown below


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

  mrp_schedule_interface int1
SET request_id = :sql_req_id,
  process_status = 3
WHERE inventory_item_id IN
  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
....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)

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 being imported and see the same item, same qty, same date printed over and over again.

The issue can be reproduced at will with the following steps:
1. For 12.1.3 - Insert records into mrp_schedule_interface
    For 12.2.8 and higher - no special steps - after upgrade - see program continually restarts after log file messages showing attempt to check for records in 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


 For 12.2.8 and higher problem seen after upgrade or for a fresh install


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

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