Sold UIN on Third Party Stock Count Import File Does Not Show Up on Rejected Items List (Doc ID 2089617.1)

Last updated on DECEMBER 21, 2015

Applies to:

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


The issue described in this document is known to Oracle, and a fix is already scheduled for future release.
This article will be updated as official patch becomes available.

In Store Inventory Management (SIM) application, we find that a serialized item that is in "Sold" status is not included in the "Rejected Items" list when a stock count is processed using third party stock count.  This happens only when the primary UPC of item is specified in the input file. If the item ID specified is the parent item ID of the UPC item, then the "Sold" UIN is reported in the "Rejected Items" list of the stock count.

Steps to Recreate:

1. Find an item for which a primary UPC exists
    a. Ensure that the item is a serialized item and have UINs existing.
    b. Ensure that at least one of the UINs is in "Sold" status at the store
2. Create a 3rd Party Unit stock count with manual authorization and add the item to the stock count
3. Schedule and extract and take snapshot
4. Prepare the input file:
    a. Use the UPC item ID for the item ID in the input file
    b. Include UINs that are in "In Stock" status as well as the "Sold" status UIN
5. Run the batch and go to authorization
6. Check for the "Sold" UIN in the "Rejected items" tab and find that the system shows the error "Rejected items do not exist"
7. Find that the authorization screen only shows those UINs that are not in "Sold" status
8. Repeat the testcase, but this time use the item ID instead of the primary UPC ID in the input third party file
9. Now find that the UIN with "Sold" status shows up in "Rejected Items" screen


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