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

Last updated on MARCH 07, 2023

Applies to:

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

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