Value Chain Planning - EBS (MOSC)

MOSC Banner

ASCP exception_details; how can I see the connection between msc_exception_details and plan outcome

edited Apr 2, 2020 5:03AM in Value Chain Planning - EBS (MOSC) 7 commentsAnswered

I looking some primary keys to connect tables together, because we building BI -reports and we want bring more information from other tables in same time.

in MSC_exceptions or MSC_exception_details or MSC_exception_detail_v tables has multiple keys like organization_id, inventory_item_id, plan_id, but then there are lot of other like transaction_id,demand_id,etc where there are not always values. Therefore I looking how to connect to tables like MSC_orders_v or MSC_supplies or MSC_tables together with exception tables?

do anyone of you have ideas to do the joins on SQL for those tables? or do I missing table where is located connecting information?

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