When Callling the GME_API_PUB.create_pending_product_lot API Pending Product Lot Numbers are not Being Generated Correctly When Organization Level Lot Uniqueness Parameter is Set to 'Across Items' (Doc ID 2774561.1)

Last updated on MAY 06, 2021

Applies to:

Symptoms

On : 12.2.8 version, API Issues

ACTUAL BEHAVIOR
---------------
Using the API gme_api_pub.create_pending_product_lot to create pending lots, it was found that some lot numbers were not being generated correctly based the setup.
It appears that the Inventory API, INV_LOT_API_PUB.auto_gen_lot is truncating zeros when the organization level Lot Uniqueness parameter is set to 'Across Items'.
When the Lot Uniqueness parameter is set to 'NONE', the issue does not occur.

If the lot_alpha_prefix is set to "L" and start_auto_lot_number is set like "0010", Lot is generated as "L10" [instead of "L0010"] and value is updated
in mtl_system_items table to "11" after the lot is generated. The problem is Lot number is expected to be generated as "L0010".

EXPECTED BEHAVIOR
-----------------------
Lot number is expected to be generated as "L0010".

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

1. Use customer wrapper to call the  gme_api_pub.create_pending_product_lot API to create pending lots

Changes

 Upgraded from 12.1.3 to 12.2.8

Cause

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