My Oracle Support Banner

Memory Based Planner (MSONWL64) Fails APP-FND-01564: ORACLE Error 3149 In Mrcrfp_create_fp_file (Doc ID 2378576.1)

Last updated on MARCH 26, 2018

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.6.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6.2 version, Memory Based Planner

While running the plan, the Memory Based Planner (MSONWL64) is failing with the following error:

ERROR
-----------------------
APP-FND-01564: ORACLE error 3149 in mrcrfp_create_fp_file
Cause: mrcrfp_create_fp_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_full_pegging (plan_id,sr_instance_id,pegging_id,invent and was executed from the file .
APP-MRP-22075: An internal error has occurred (mrfrec_flush_full_pegging, 11, 16577, )
@ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
Error string=
Statement with the error:
insert into msc_full_pegging (plan_id,sr_instance_id,pegging_id,invent

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run plan

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot access plan results.

Changes

 

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!


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