My Oracle Support Banner

Forms in Advanced Supply Chain Planning Failing To Open With 'Exception caused in set_unconstrained_mrp_mode' (Doc ID 2810142.1)

Last updated on SEPTEMBER 27, 2021

Applies to:

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

Symptoms

On : 12.2.10 version, User Interface

After upgrade to 12.2.10 certain forms will not open.

The problem occurs in the forms
 Navigation Advanced Supply Chain Planner : Supply Chain Planner : Options
 Navigation Advanced Supply Chain Planner : Supply Chain Planner : Names
 Navigation Advanced Supply Chain Planner : Supply Chain Planner : View Plan Options
 Navigation Advanced Supply Chain Planner : Supply Chain Planner : View Plan

When the DBA kills the session, the following error is seen briefly:


ERROR
-----------------------
Exception caused in set_unconstrained_mrp_mode' appears.

A second error that is appearing in the Instance Organizations form:

APP-FND-00005: Incorrect arguments were passed to user exist #MESSAGE_STRING "FND_FLEX_PRIVATE.FLEX_CLOSE_SPOL failure.  SQLERRM: Please correct the user exist call in your form exit.
FRM-40735:  ON-ERROR trigger raised unhandled exception ORA-01001

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Instance upgraded to R12.2.10.
3. Latest Cumulative Update patch is applied per note 1361221.1.
4. Trying to open the forms mentioned above are resulting in errors impacted.

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!


In this Document
Symptoms
Changes
Cause
Solution


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