My Oracle Support Banner

Metric "Pack – Net Sales Qty" Incorrectly Calculated For Component Items (Doc ID 2796476.1)

Last updated on SEPTEMBER 21, 2021

Applies to:

Oracle Retail Insights Cloud Service Suite - Version 19.0 to 19.0 [Release 19.0]
Information in this document applies to any platform.


Metric "Pack – Net Sales Qty" incorrectly calculated for component items.

When sales occur for a pack item, the metric "Pack – Net Sales Qty" for the component item(s) is not correctly calculated.

The metric should be SLS_QTY*PACK_QTY.

Steps To Recreate:

  1. Make sure 12 units of the Pack Item were sold, and this item is composed of 40 units of the component item , then, in reality, goods sold 12 * 40 = 480 units of item item1 . That should be the value shown in the “Pack – Net Sales Qty” metric for item.




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.