My Oracle Support Banner

Stock Count Authorization Timestamp Set To Schedule Date When Manually Authorizing (Doc ID 2694222.1)

Last updated on JULY 30, 2020

Applies to:

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

Symptoms

SIM sets the authorization timestamp to the scheduled date when the stock count was manually authorized via SIM PC and following timestamp sales processing.

Note: Default Time frame parameter setting should not come into play since Sales Processing is set to Timestamp.

Steps to Reproduce:

Count Type: Scheduled Unit Only

System Parameter: STOCK_COUNT_SALES_PROCESS_UNIT = 0 (Timestamp Processing)

Verify Stock Count parameters:

STOCK_COUNT_SALES_PROCESS_UNIT = 0 (Timestamp Processing)
STOCK_COUNT_DEFAULT_TIMEFRAME=2 (After Store Close)

SIM PC:


1. Create Unit Only Product Group
2. Schedule Count & Explode now
3. Select Count
4. Take Snapshot
5. Count items and make sure you have a variance to Authorize Note: Timestamp for Counted Items (STOCK_COUNT_LINE_ITEM.counted_date_time)
6. Complete Count
7. Select Authorize
8. Select Child 1 – Update Auth Quantity
9. Save Child
10. Select Child 2 – Manually enter Auth Quantity
11. Save Child

STOCK_COUNT_LINE_ITEM. APPROVED_DATE_TIME = schedule date
STORE_ITEM_STOCK. LAST_STK_CNT_APPROVE_DATE = schedule date
STORE_ITEM_STOCK. LAST_STK_CNT_TIMEFRAME = A (after store close)

Expected: Approved Timestamp should have been set to Sys Date since user was overriding counted qty

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.