Results for “msc_allocations”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
MSC_ALLOCATIONS is a table in the MSC schema owned by Oracle Advanced Supply Chain Planning (ASCP). It stores allocation definitions used during the planning process to distribute constrained supply across demand classes, trading partners, and partner sites. The table operates as part of the allocation rule framework in ASCP, allowing planners to assign a percentage of available supply to specific allocation groups based on priority, service level, and time-phased rules. Its presence is fundamental to constrained and unconstrained plan runs that must respect allocation priorities defined by the enterprise.
From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure suggests MSC_ALLOCATIONS behaves as a link entity. It connects trading partners, partner sites, allocation rule time phases, and levels through its foreign key columns, capturing relationship-level allocation percentages and priorities. This classification is a modeling suggestion rather than a prescribed Oracle design, but it accurately reflects the table's role as a junction between allocation rule definitions and their target recipients.
Key Information Stored
The table contains 35 documented columns, of which the following are most significant:
- ALLOCATION_ID — The surrogate primary key, enforced by the unique index MSC_ALLOCATIONS_PK.
- TIME_PHASE_ID — Foreign key to MSC_ALLOC_RULE_TIME_PHASES; identifies the time phase within the allocation rule to which the allocation applies.
- DEMAND_CLASS — The demand classification against which the allocation is applied; combined with TIME_PHASE_ID, forms the business-key candidate MSC_ALLOCATIONS_U2.
- ALLOCATION_PERCENT — The percentage of supply allocated to the associated partner, site, or level.
- PRIORITY — The execution order in which the allocation is consumed relative to other allocations.
- SERVICE_LEVEL — Target service level associated with the allocation.
- PARTNER_ID — Foreign key to MSC_TRADING_PARTNERS; identifies the trading partner receiving the allocation.
- PARTNER_SITE_ID — Foreign key to MSC_TRADING_PARTNER_SITES; identifies the specific partner site.
- LEVEL_ID — Foreign key to MSD_LEVELS; identifies the allocation level in the supply chain hierarchy.
- LEVEL_ALLOC_PERCENT, LEVEL_PRIORITY — Level-specific allocation percentage and priority values.
- MIN_ALLOCATION_PERCENT, MIN_LEVEL_ALLOC_PERCENT — Minimum allocation thresholds that must be respected before remaining supply is distributed.
- CLASS — Class identifier supporting grouping of allocation records.
- ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield columns for client-specific extensions.
- LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE — Standard audit columns tracking record lifecycle.
Common Use Cases and Queries
Planners and technical teams query this table to audit allocation logic, verify percentage totals by time phase and demand class, and validate priority assignments before launching a plan. A typical reporting query joins MSC_ALLOCATIONS to MSC_TRADING_PARTNERS to display partner-level allocations:
- SELECT a.ALLOCATION_ID, tp.PARTNER_NAME, a.ALLOCATION_PERCENT, a.PRIORITY FROM MSC_ALLOCATIONS a, MSC_TRADING_PARTNERS tp WHERE a.PARTNER_ID = tp.PARTNER_ID;
- Aggregation by TIME_PHASE_ID and DEMAND_CLASS (using unique index MSC_ALLOCATIONS_U2) to confirm that allocation percentages sum to 100 percent within a phase.
- Joins to MSC_ALLOC_RULE_TIME_PHASES to correlate allocations with their effective date ranges.
- Extraction into custom reporting schemas that feed allocation compliance dashboards.
Because the top-level primary key is the surrogate ALLOCATION_ID, most operational queries filter on TIME_PHASE_ID, DEMAND_CLASS, or PARTNER_ID rather than the surrogate itself.
Related Objects
The following objects are most significant to MSC_ALLOCATIONS through documented relationships:
- MSC_TRADING_PARTNERS — joined on PARTNER_ID; provides partner identification.
- MSC_TRADING_PARTNER_SITES — joined on PARTNER_SITE_ID; identifies the receiving partner site.
- MSC_ALLOC_RULE_TIME_PHASES — joined on TIME_PHASE_ID; defines the time-phased rule context.
- MSD_LEVELS — joined on LEVEL_ID; defines the supply chain level hierarchy.
- MSC_ALLOCATIONS_PK / MSC_ALLOCATIONS_U1 / MSC_ALLOCATIONS_U2 — the primary key and unique indexes that enforce uniqueness of ALLOCATION_ID and of the TIME_PHASE_ID plus DEMAND_CLASS combination.
-
This table describes the allocations
-
This table describes the allocations
-
TABLE: MSC.MSC_ALLOCATIONS 12.1.1
-
TABLE: MSC.MSC_ALLOCATIONS 12.2.2
-
VIEW: MSC.MSC_ALLOCATIONS# 12.2.2
-
VIEW: MSC.MSC_ALLOCATIONS# 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
PACKAGE: APPS.MSC_AATP_FUNC 12.2.2
-
12.1.1 DBA Data 12.1.1
-
PACKAGE: APPS.MSC_AATP_FUNC 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2