My Oracle Support Banner

Inventory Item Min-Max Calculation Using Policy Profile Is Not Working (Doc ID 2569648.1)

Last updated on JANUARY 27, 2020

Applies to:

Oracle Fusion Manufacturing Cloud Service - Version 11.13.19.04.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.19.04.0 version, Inventory Management

Inventory Item Min-Max Calculation using Policy Profile is not calculating. Customer requirement is to calculate automatic Min-Max calculation using Min-Max Policy.

ERROR
-----------------------
Exception occured in compute_policy_params_for_si ORA-06503: PL/SQL: Function returned without value


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Manage Min-Max Planning Classification Group
2. Setup and Maintenance => Manufacturing and Supply Chain Materials Management => Manage Min-Max Planning Classification Groups
3. Navigate to Manage Min-Max Planning Policy Profile, (N) : Setup and Maintenance => Manufacturing and Supply Chain Materials Management => Manage Min-Max Planning Policy Profile
4. Navigate to Manage Min-Max Planning Policy Profile Assignments (N) : Setup and Maintenance => Manufacturing and Supply Chain Materials Management => Manage Min-Max Planning Policy Profile Assignments
5. Click on ‘Calculate Min-Max Planning Policy Parameters’ Button
6. Wait for the ESS Program ‘Calculate Min-Max Parameters’ to complete.


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
References


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