Transformable Items Are Not Available In Retail Insights

(Doc ID 2350111.1)

Last updated on JANUARY 25, 2018

Applies to:

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


Transformable items are not available in Retail insights.

Transformable items both orderable and sellable are not extracted into Retail insight due to the filter ITEM_XFORM_IND<>'Y' filter being used in the item extraction script.

Due to this any transaction available RMS will not flow in analytic system for the analysis. 

Steps to Recreate:
1. Create transformable orderable and sellable items in RMS.
2. Run the SDE "SDERetailItemDimension" package in the RDE.
3. Check if the transformable items are present in the extracted file.


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