Oracle ERP ER Diagrams

Oracle Advanced Supply Chain Planning (ASCP) ER Diagram

Most of you probably already know this.  Plan_id = -1 will be Operational Data Store (ODS collection data) & plan_id <> -1 will be the Planning Data Store (PDS - plan output data). There are a few master data tables like item_categories, trading_partners etc which do not have plan_id columns. This is because the plan does not alter them.  We have included them as well in the ER diagram.

Start with MSC_PLANS, which is the master table.

Oracle Advanced Supply Chain Planning ER Diagram

Call 866-531-9587 / Fill out the contact form.