My Oracle Support Banner

Failed Records Are Not Purged from 'STOCK_COUNT_IMPORT' Table During 'ThirdPartyStockCountImport' Process (Doc ID 2467716.1)

Last updated on NOVEMBER 01, 2021

Applies to:

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

Symptoms

In Store Inventory Management (SIM), 'ThirdPartyStockCountImport' process is not deleting records from from STOCK_COUNT_IMPORT table whose Status = 10.

Step to Reproduce :

1. Create 3rd-party count file with invalid FHEAD.stock count ID (use a previously completed ID)
2. Run ThirdPartyStockCountImport batch
Note: STOCK_COUNT_IMPORT includes records with status =10
4. Correct import count file
5. Re-run ThirdPartyStockCountImport batch

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.