Compute_std_err Procedure: ORA-20002: -904 ORA-00904: Errors
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.
Customer is on 220.127.116.11 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
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