Unit And Amount Approval Returns "ORA-06502: PL/SQL: Numeric Or Value Error" For Negative Qtys (Doc ID 2948295.1)

Last updated on MAY 16, 2023

Applies to:

Symptoms

When attempting to process Third Party Stock Count Import batch job with a UIN item not counted that has a negative stock on hand and all UINs in status sold, the following error occurs.

ERROR
-----------------------

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

Data Setup:

UIN ITEM exists in STORE_ITEM_STOCK table with QUANTITY_TOTAL = -1
UINs associated to the ITEM are all in STATUS = 1 in ITEM_UIN table
Third Party Import file does not contain the UIN item as it is not counted

1. Create a Product Group for a unit and amount third party stock count , auto authorize set to yes.
2. Schedule the Product Group.
3. Move the 3rd party file to the FTS/Imports folder.
4. Run the Third Party Stock Count Import adhoc batch job.

Cause

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