MSC — Advanced Supply Chain Planning
711 documented tables · 182 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
MSC_TRADING_PARTNERS |
This table stores information about the different organizations: customers, vendors, and planned organizations | hub |
MSC_PLAN_ORGANIZATIONS |
This table stores the parameters relative to organizations that participate to the plan in Oracle Advanced Pla | hub-leaning |
MSC_TRADING_PARTNER_SITES |
This table stores information about the different sites of an organization. | hub |
MSC_SYSTEM_ITEMS |
MSC_SYSTEM_ITEMS stores the organization items defined at source applications. It also stores a copy of items | hub |
MSC_PLANS |
This table stores different plans, with their names, and settings in the Oracle Advanced Planning and Scheduli | hub-leaning |
MSC_PARAMETERS |
This table stores information about how the planning process works for a given organization. Each organizatio | hub-leaning |
MSC_SUPPLIER_FLEX_FENCES |
MSC_SUPPLIER_FLEX_FENCES stores the supplier flex fence information for planned items within an MPS, MRP, or D | satellite-leaning |
MSC_SUPPLIER_CAPACITIES |
This table stores the capacity information for planned items within an MPS, MRP, or DRP plan. Each row store | satellite-leaning |
MSC_SALES_ORDERS |
This table stores sales order demand and reservations from source application instances. | satellite-leaning |
MSC_PROJECTS |
This table stores the manufacturing parameters for a given project and organization. | hub-leaning |
MSC_ABC_CLASSES |
This table describes the classification of inventory goods into class A, B, C class types. | hub-leaning |
MSC_ASSIGNMENT_SETS |
This table stores the assignment of sourcing rules (or bills of distribution) to item, organization, category, | hub-leaning |
MSC_ROUTINGS |
This table stores the different routings available for a bill of material. | satellite-leaning |
MSC_ROUTING_OPERATIONS |
This tables stores the operations composing each routing. | hub-leaning |
MSC_PROJECT_TASKS |
This table stores the tasks maufacturing parameters. | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
MSC_REL_PLAN_PUB |
PUB | 33 | 9 packages |
MSC_ATP_PUB |
PUB | 3 | 7 packages |
MSC_SELECT_ALL_FOR_RELEASE_PUB |
PUB | 6 | 4 packages |
MSC_SCATP_PUB |
PUB | 6 | 3 packages |
MSC_RP_PUB |
PUB | 5 | 0 packages |
MSC_ITEM_PUB |
PUB | 1 | 0 packages |
MSC_REL_PS_PLAN_PUB |
PUB | 7 | 0 packages |
MSC_RP_RELEASE_PUB |
PUB | 17 | 0 packages |
MSC_REPPERIODS_PUB |
PUB | 1 | 0 packages |