Misleading Description Of Columns In DEPS Table (Doc ID 3055180.1)

Last updated on OCTOBER 23, 2024

Applies to:

Goal

Customers wish to clarify the purpose of the DEPS table.

1. MAX_AVG_COUNTER - Description provided in data dictionary is: "A maximum average counter will hold the maximum count of days with acceptable data to include in an average for items within the department"
Queries:
a) What does acceptable data mean
b) Which average is being referred, is it sales or inventory or order qty or something else

2. AVG_TOLERANCE_PCT - Description provided in data dictionary is: "A tolerance percentage value used in averaging for items within this value. This value will set up a range for appropriate data and constrain outliers. This column will hold 70% as 70 - not 0.70"
Queries:
a) Which average is being referred, is it sales or inventory or order qty or something else
b) As this column can hold only 1 value, how can it provide a range?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.