Stock Count Approval Date/LAST_STK_CNT_APPROVE_DATE/LAST_STK_CNT_TYPE are not Updated Properly (Doc ID 2131233.1)

Last updated on APRIL 03, 2017

Applies to:

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

Symptoms

In Store Inventory Management(SIM), approve stock count fails to update the following columns:
STOCK_COUNT_LINE_ITEM.APPROVED_DATE_TIME
STORE_ITEM_STOCK.LAST_STK_CNT_TYPE
STORE_ITEM_STOCK.LAST_STK_CNT_APPROVE_DATE

Steps to reproduce:
1. Create Product Group for Third Party Unit and Amount Stock Count. Select the check box: Auto Authorize = Yes
2. Create a Product Group Schedule for the Third Party Unit and Amount Stock Count
3. Run ExtractUnitAmountStockCount.sh batch to generate the stock count
4. Take Snapshot
5. Run ThirdPartyStockCountImport.sh to import the third party stock count file
6. Once the process is completed. Go to Stock Count list screen and validate:
Authorization is completed, Stock count type = Authorize and status is Completed
Observer the following are not updated:
STOCK_COUNT_LINE_ITEM.APPROVED_DATE_TIME
STORE_ITEM_STOCK.LAST_STK_CNT_TYPE
STORE_ITEM_STOCK.LAST_STK_CNT_APPROVE_DATE

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