My Oracle Support Banner

A&IP: Lookup Procedure Is Incorrect for Seeding Customer Returns (Doc ID 2481223.1)

Last updated on MARCH 08, 2019

Applies to:

Oracle Retail Assortment & Item Planning Enterprise Edition Cloud Service - Version 17.1 and later
Information in this document applies to any platform.


Seeding customer returns is not working correctly at the store cluster level. The configuration is making use of the <-lookup procedure, but the source and target measures have different base intersections. The source measure uses a base intersection of week/sku/store, while the target measure has a base intersection of week/sku/store cluster. It seems that in this case the lookup procedure is using the 'max' aggregation method and not 'total' aggregation method. For the (Gross) Sales Unit measure, the base intersections match and therefore the results are correct. 




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.