My Oracle Support Banner

IL.UNIT_RETAIL Is Populated as NULL Using NEW_ITEM_LOC Functionality (Doc ID 2663659.1)

Last updated on APRIL 27, 2020

Applies to:

Oracle Retail Merchandising System - Version 16.0.2 and later
Information in this document applies to any platform.


IL.UNIT_RETAIL is populated as NULL using NEW_ITEM_LOC functionality.

Steps to reproduce:
1. Set RPM_IND as 'N'.
2. Set a VAT_REGION with VAT_CALC_TYPE = 'E'.
3. Create a Franchise Store and associate with this VAT_REGION, where VAT_CALC_TYPE = 'E'.
4. Call NEW_ITEM_LOC functionality to range an item for this Franchise Store.
5. Item will range at this Franchise Store location but IL.UNIT_RETAIL and IL.SELLING_UNIT_RETAIL is populated with NULL value.




To view full details, 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 a vibrant support community of peers and Oracle experts.