Compute_std_err Procedure: ORA-20002: -904 ORA-00904: Errors (Doc ID 2031353.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

Customer is on 12.2.4.1 and mentions that when they run the compute std err procedure, they get an error which states:
"ORA-20002: -904 ORA-00904: "MDP_MATRIX"."T_EP_ACCT_TYPE_EP_ID": invalid identifier Error in PROCEDURE line 113"

This column actually exists on mdp_matrix

Customer has defined the Demand Variability Calculation Process with the Covariance series that is on an mdp_matrix table

As per Bug 12415516 - TST122:UIC:SAFETY STOCK: COMPUTE_STD_ERR PROCEDURE RUNS WITH ERRORS

it is mentioned that Safety stock interface should allow to choose covariance series, based on mdp_matrix.

This seemed to have been fixed in 12.2 , but the customer is still facing the issue

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