Recipe Validity Rules Standard Oracle API Setting/calculating Incorrect Inv Min And Max Quantities (Doc ID 2380859.1)

Last updated on NOVEMBER 21, 2022

Applies to:

Symptoms

On :  12.1.3 version, API Issues

ACTUAL BEHAVIOR  
---------------
The Recipe Validity Rules API: GMD_RECIPE_DETAIL.CREATE_RECIPE_VR API setting/calculating incorrect Inv Min and Inv Max quantities (INV_MIN_QTY and INV_MAX_QTY in GMD_RECIPE_VALIDITY_RULES) is supposed to calculate INV MIN and MAX quantities in ORG level primary UOM of the item(product) whereas the API calculating quantities in master org primary UOM (most  of the cases).  Found that there is an issue in deriving primary UOM of the item within recipe validity rules standard API. The cursor which is fetching primary UOM has just select from MTL_SYSTEM_ITEMS without having organization and the first record from the cursor is considering as PUOM hence the INV quantities are calculated based on the first records (most of the time MASTER ORG "PUOM").


EXPECTED BEHAVIOR
-----------------------
Expect this to work like the forms with the correct calculations

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Note -Item at MASTER ORG has LBS as PUOM and for the same item ORG1 has KLG as PUOM.

1) Using the API- GMD_RECIPE_DETAIL.CREATE_RECIPE_VR
2) Create recipe validity rule in KLG, the standard API supposed to set INV_MIN_QTY and INV_MAX_QTY in KLG (org PUOM) but quantities are in LBS (Master PUOM).
3) Create recipe validity rule in LTR, the standard API supposed to calculate and set INV_MIN_QTY and INV_MAX_QTY in KLG (org PUOM) but quantities are in LBS (Master PUOM).

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see the correct calculation which is causing production issues.

Cause

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