Key Tables

This appendix covers the following topics:

Key Tables

The following table lists the key tables used in Oracle Collaborative Planning. Their descriptions are also listed.

Table Name Description
MSC_SUP_DEM_ENTRIES Stores supplies and demands in Oracle Collaborative Planning. Data is loaded into this table using:

  • Flat file loads

  • XML loads

  • Collections from ERP

  • Manually through the user interface

  • Publish processes in Oracle Advanced Supply Chain Planning and Oracle Demand Planning
MSC_COMPANIES Stores list of companies. The company name in the profile option MSC: Operator Company Name is seeded in this table as Company_ID=1.
MSC_COMPANY_SITES Stores the list of company sites. Sites may be customer sites, supplier sites, or inventory organizations.
MSC_COMPANY_RELATIONSHIPS Stores the relationships between companies in Oracle Collaborative Planning.
MSC_x_EXCEPTION_DETAILS Stores the exceptions generated by the Supply Chain Event Manager, Custom Exceptions, and VMI Replenishment Engine.
MSC_SECURITY_RULES Stores security rules defined in Oracle Collaborative Planning.
MSC_TRADING_PARTNER_MAPS Stores maps between company and company sites with trading partner and trading partner sites.
MSC_ITEMS Stores the repository of items.
MSC_SYSTEM_ITEMS Stores the items for each Organization and Instance combination.
MSC_SUP_DEM_HISTORY Stores the history of transactions. Whenever data is loaded to MSC_SUP_DEM_ENTRIES, existing records are transferred to the MSC_SUP_DEM_HISTORY for archiving.
MSC_ITEM_SUPPLIERS Stores relationships between company items and supplier items.
MSC_ITEM_CUSTOMERS Stores relationships between company items and customer items.