Value Chain Planning - EBS (MOSC)

MOSC Banner

why is table msc_safety_stocks not a partitioned table?

edited Sep 30, 2011 7:01AM in Value Chain Planning - EBS (MOSC) 2 commentsAnswered
 Most MSC schema tables are partitioned = 'YES" by plan partition and instance partition. But surprisingly msc_safety_stocks is not a partitioned table. If someone from Oracle Product Management/Development is monitoring this community discussions, can they take a look as to why is this the case.

you can check this by

select * from dba_tables where table_name = 'MSC_SAFETY_STOCKS' and for 'partitioned' column, it shows 'NO'.

At sites where they are using the safety stocks planning significantly in Planning and for large number of records, this sees degraded performance.

Thanks

Amol

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center