My Oracle Support Banner

Stock Count Should Not Process If Snapshot Is Not Taken (Doc ID 3010294.1)

Last updated on MARCH 14, 2024

Applies to:

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

Symptoms

 This request  to handle some check/validation to avoid stock count processing if snapshot is not taken.

Value of system_options (stake_lockout_days set to 1 cycle_count_lag_days set to 0) cause Stock count to be process before snapshot was updated.

Due to this setting stock count results are processed before snapshot is updated in stake_sku_loc.
Snapshot values will get updated based on stake_lockout_days set in system_options and in this case stock count file was processed before snapshot was updated. which cause ‘incorrect’ update on stake_sku_loc.snapshot_on_hand_qty and item_loc_soh.stock_on_hand.

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
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.