Demantra Solutions - EBS (MOSC)

MOSC Banner

Dead Address Logic

edited Aug 4, 2017 11:15AM in Demantra Solutions - EBS (MOSC) 9 commentsAnswered

Hello Everyone,

I need some help in understanding how combinations in MDP MATRIX were updated to dead address (predictive status = 99),  when I check dying time parameter which is set to 27 week.

While running following sql, which is supposed to give me sales data of dead address combination. But this query gave me sales date of future as well some from past 2 week. Then how these combinations are dead when dying time is 27 week.

Mature age is set as 2 week.

select teo.organization,

       sales_date,

       load_sig,

       tei.item,

       sd.sdata15,

       sd.actual_quantity

from mdp_matrix mm,

      sales_data sd ,

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