Demantra Solutions - EBS (MOSC)

MOSC Banner

item_price in future time buckets

edited Aug 18, 2011 10:09PM in Demantra Solutions - EBS (MOSC) 3 commentsAnswered
I needed to populate the last non-zero number from sales_data.item_price per item_id/location_id into the future buckets. When I started looking into the table, I found prices in future buckets already exist. As item_price is an average of historic price from TMPL, I have two questions:
1) What procedure/package/function is loading the future prices? - Testing shows this is done by the batch engine;
2) What is the logic for determining the price to populate? - Not sure - but perhaps it is using Fill Causals - Note: Price in my model is NOT a causal and thus no FIll Casual flag set.

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