ExtractUnitStockCount and ExtractUnitAmountStockcount Batches Fail when No Items on Stock Count

(Doc ID 1517245.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Store Inventory Management - Version 13.2.4 and later
Information in this document applies to any platform.

Symptoms

When a Product Group Schedule is created for a Product Group where Counting Method = Third Party, Hierarchy Breakdown = Subclass and there are no items (Total # of Items = 0) for the chosen merchandise hierarchy, the ExtractUnitStockCount batch process fails with below error.

 

Steps to reproduce:

Scenario 1: 

  1. Create a product group where Counting Method = Third Party, Hierarchy Breakdown = Subclass and chose a merchandise hierarchy (dept, class and subclass) that contains 0 items.
  2. Create a product group schedule with Type = 'Unit' and the product group created previously, and select the start and end date as Today (so it creates the stock count immediately).
  3. Click on Done, and confirm if stock count is to be created (simulates the batch process that was failing), and an alert with the error ' Error from Error in PRODUCT_GROUP_ITEMS.DO_BREAK_DOWN_BY_SUBCLASS procedure: ORA-06502: PL/SQL: numeric or value error' pops up.

Scenario 2:

1. Create a Unit & Amount product group with counting method as 'Unguided' and hierarchy breakdown as 'Subclass'.
2. Choose the product group components and add it to the group.
3. Click on Done.
4. Navigate to Product group scheduler and choose product type as Unit & amount and product group as the product group that you created in step 1.
5. choose an available location and enter suitable description.
6. Click on Done.
7. Now run the batch job EXTRACTUNITAMTSTOCKCOUNT and observe that it aborts.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms