Demantra Solutions - EBS (MOSC)

MOSC Banner

Forecast tree hierarchy test can be done in Demantra 7.3.1?

edited Jul 9, 2015 12:29AM in Demantra Solutions - EBS (MOSC) Question

Hi,

Please advise whether Tree Hierarchy Test Can be done in Demantra 7.3.1? When scan through via Engine Administrator, i could not find any option to run it. Then i tried to run it directly from bin folder and its throwing an exception,

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Checking the hierarchy of the forecast tree of

demantra on DEVDEM01

Number of tree levels: 30

There is always hierarchy between level 1 and 2

since level 1 is the ITEM,LOCATION with is the key of MDP_MATRIX

---------------------------------------------------------------

  DB_Command::Execute threw an exception:

  select distinct  t_ep_spf_latest_rev_id, t_ep_L_ATT_2_EP_ID, t_ep_p2a_EP_ID, t_ep_L_ATT_2_EP_ID from mdp_matrix where (t_ep_spf_latest_rev_id, t_ep_L_ATT_2_EP_ID) in (select t_ep_spf_latest_rev_id, t_ep_L_ATT_2_EP_ID from mdp_matrix where do_aggri = 1 AND (prediction_status in (1,97)  OR (prediction_status = 98 and aggri_98=1)     OR (prediction_status = 99 and aggri_99=1))   group by t_ep_spf_latest_rev_id, t_ep_L_ATT_2_EP_ID having count(distinct t_ep_p2a_EP_ID)  > 1)and  do_aggri = 1 AND (prediction_status in (1,97)  OR (prediction_status = 98 and aggri_98=1)     OR (prediction_status = 99 and aggri_99=1))  

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center