This appendix covers the following topics:
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:
|
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. |