APPPROC_CALC_ACCURACY FAILS WITH PL/SQL: ORA-00904

(Doc ID 2324065.1)

Last updated on NOVEMBER 01, 2017

Applies to:

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

Symptoms

Using Oracle Demantra Demand Management / MAPE
On 12.2.6,
When attempting to perform APPPROC_CALC_ACCURACY
the following kind of error occurs in each PARALLEL_MANAGER.JOB_THREAD:

ERROR
-----------------------

-- Steps To Reproduce:

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

2. Observe the noted errors on rows of DB_EXCEPTION_LOG where
PROC_NAME=PARALLEL_MANAGER.JOB_THREAD

Cause

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