My Oracle Support Banner

All Book Transfer Messages Updated Snapshot On Hand For Open Stock Counts (Doc ID 3035441.1)

Last updated on JULY 17, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 to 19.3 [Release 19.3]
Information in this document applies to any platform.

Symptoms

On : 19.3 version, Merch - Inventory Tracking

ACTUAL BEHAVIOR
---------------
NAM SaaS - All book transfer messages updated snapshot on hand for open stock counts

We are seeing issues with our stock counts where all book transfers (not late polled) posted after 7-Feb-2024 (patch 19.3.006.21 deployment) are updating snapshot_on_hand_qty in stake_sku_loc table for all open stock counts.
This has a significant impact on our stock counts and we cannot proceed with incorrect inventories.

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

1. Create stock count with vdate
2. Post book transfers after snapshot with date > vdate + 1.
3. Notice that transaction updates the snapshot on hand qty


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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