My Oracle Support Banner

Need Clarification on ITEM RANGING Entity in Data Conversion (Doc ID 2877779.1)

Last updated on JANUARY 15, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.


As per the ITEM RANGING TEMPLATE File, you need two Retail values below as input.

Please confirm these values in the ITEM_LOC table (in v13, the source).

Find that value passed in column 28 STANDARD_UNIT_RETAIL gets into ITEM_LOC.UNIT_RETAIL and ITEM_LOC.REGULAR_UNIT_RETAIL columns in SaaS and SELLING_UNIT_RETAIL gets into ITEM_LOC.SELLING_UNIT_RETAIL value.

For an item/location on clearance in the source (v13), uploading this value creates a mismatch between ITEM_LOC.UNIT_RETAIL vs. ITEM_LOC.SELLING_UNIT_RETAIL

Please confirm if this is the expected behavior?


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.