My Oracle Support Banner

Unexpected APPROC_CALC_ACCURACY Results (Doc ID 2409880.1)

Last updated on JUNE 11, 2018

Applies to:

Oracle Demantra Demand Management - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

Using Oracle Demantra Demand Management / APPROC_CALC_ACCURACY
On 12.2.6 in Dev:
When attempting to perform APPROC_CALC_ACCURACY as patched by
Bug 26981675 - APPPROC_CALC_ACCURACY FAILS WITH PL/SQL: ORA-00904
on Item = 14472, Organization = AVY:DAL using APPROC_CALC_ACCURACY parameters
  425
  486
  -26
  0
  salesplus
  c_pred
find series "MG NA MAPE" = 0.06569 for all dates


EXPECTED BEHAVIOR
-----------------------------------
Expect value to be about 0.25 to 0.30

-- Steps To Reproduce:

Customer states the issue can be reproduced at will at customer site with the following steps:
1. Run APPROC_CALC_ACCURACY using parameters
  425
  486
  -26
  0
  salesplus
  c_pred
  ACRY_XXMG_MAPE

2. Inspect the results of the series "MG NA MAPE" for Item = 14472, Organization = AVY:DAL

3. Observe values of 0.06569 for all dates

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot upload MAPE data to EBS Inventory Optimization
to drive Safety Stock planning.

Cause

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.