My Oracle Support Banner

CTO Calculate Dependent Demand Workflow Issue - Dbms Jobs Hanging - ORA-00904: FINAL_FORECAST: invalid identifier (Doc ID 1302624.1)

Last updated on DECEMBER 02, 2014

Applies to:

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


Run the Calculate Dependent Demand workflow, CalculateDependentDemand workflow is hanging, DBMS jobs are hanging.

When trying to run one of the dbms jobs manually from dba_jobs, encountered the following error:

execute cto_calc.dep_demand_job(' mtx.t_ep_cto_base_model_id between 158 and 161', null, null, null, null, 'CTO_PARENT_DEM_HIS' , 'CTO_PARENT_DEM_EXIST' , 'CTO_PARENT_DEM_FINAL' , 'CTO_PLN_PCT' , 'CTO_PLN_PCT_HIS' , 'CTO_DEP_DEM_EXIST' , 'CTO_DEP_DEM_HIS' , 'CTO_DEP_DEM' , 'salesplus' , '' , '' );

ORA-00904: "FINAL_FORECAST": invalid identifier
ORA-06512: at "CTO_CALC", line 488
ORA-06512: at line 1

When checking the final_forecast expression, it also return error:

  select replace(replace(GET_EXP_WITH_NO_TOKEN(exp_template), '#unit#', '1'), '#UNIT#', '1')



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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