My Oracle Support Banner

Stock Count Pack Into Piece Conversion Issue/Stock Count Is Not Considering Quantities From Pack's (Doc ID 2959322.1)

Last updated on JULY 04, 2023

Applies to:

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



You are facing a problem regarding stock counts and pack items.

- Scenario (multiple pack items issue), If the user changes Pack quantities in the recount, then the system voids those quantities and takes the quantities from the first count.

- You are using Unit Stock counts.

When you have, let's say, a pack item where ITEM A is a pack item from ITEM B and ITEM A corresponds to a pack of 6 units of ITEM B.

The user in the store has 4 items A and 1 item B (25 items B if you count the units from the pack).

In the count, users insert quantities of 4 for ITEM A and 1 unit for ITEM B.

It is expected that ITEM B, being a breakable pack item appears with 25 units and not 1.

However, SIM is adjusting ITEM A to only 1 unit instead of 25.

Recounted Quantity should be considered

The issue can be reproduced at will with the following steps:
1. Create a product group

2. Setup Product Group Components

3. Create a Product Group schedule

4. Select the Inventory Mangmt option to pick desired stock count from the list

5. Click on Take Snapshot

6. Enter the First Count
Enter count Qty of Items in PCS
Enter count Qty of Items in Outer
Enter count Qty of Items in Cases

In the count, users insert quantities of 11 to ITEM A and 10 to ITEM B, and 24 to ITEM C.

7. Complete count

8. Click on Take Snapshot

In the count, users insert quantities of 17 to ITEM C only

9. Click on Complete

Click on Yes

10. Click on Complete count

11. Click on Authorize

Count Qty should be: (11 * 6 + 10 * 1 + 17 * 24) = 484

Count Qty Displayed on the screen: (11 * 6 + 10 * 1 + 24 * 24 ) = 652

The issue was recreated, Count Qty on Recount is shown wrong


To view full details, sign in with your My Oracle Support account.

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

In this Document

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