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 laterInformation in this document applies to any platform.
Symptoms
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
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)
-----------------------------------------
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.
STEPS
-----------------------
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
Changes
For 12.2.8 and higher problem seen after upgrade or for a fresh install
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |