MBP Fails When Calculate Resource Requirements Is Enabled (Doc ID 1449100.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 27-Sep-2013***

Symptoms

Memory Based Planner fails with below error message when plan option Calculate Resource Requirements is enabled. When we run a plan with this disabled, the plan completes normally.

The error message is:
APP-FND-01564: ORACLE error 3149 in mrcrsf_create_res_file

Cause: mrcrsf_create_res_file failed due to ORA-03149: Invalid Oracle error code
.

The SQL statement being executed at the time of the error was: insert into msc_resource_requirements (plan_id,transaction_id,last_upd and was executed from the file .
APP-MRP-22075: An internal error has occurred (mrfrsp_flush_res_plan, 11, 159531, )
Error string=
Statement with the error:
insert into msc_resource_requirements (plan_id,transaction_id,last_upd


Total memory usage: 225467

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