My Oracle Support Banner

Functional Area Not Updated in ITEM_UIN Table When Processing the Sale/Return of a UIN Item in SIM (Doc ID 2112417.1)

Last updated on DECEMBER 04, 2019

Applies to:

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


Functional area is not being updated in the ITEM_UIN table when a Point of Service (POS) sale or return is processed in Store Inventory Management (SIM).
This functionality is an important part of the sales for serial items. This field describes the business area and potentially phases of the business area that are affecting the data.

Steps to Reproduce:

  1. Log in to ORPOS
  2. Create a sale transaction for an item that has a serial number
  3. Log in to SIM database and check value of column FUNCTIONAL_AREA in the table ITEM_UIN.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.