Search Results org_group




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

MSC_INSTANCE_ORGS is a table in the MSC schema owned by Oracle Advanced Supply Chain Planning (ASCP). It stores the association links between each inventory organization and an MSC application instance. In practice, it acts as the registry that tells the planning engine which organizations belong to a given source instance, and it carries the collection and plan-refresh flags that govern how data is gathered for each organization before planning runs.

The table is central to multi-org and multi-instance planning deployments. Every organization that participates in ASCP must have a corresponding row here, keyed to a valid source instance in MSC_APPS_INSTANCES. In 12.1.1 and 12.2.2 the object is defined as VALID with 57 columns; the ETRM documentation notes it is documented identically across both releases.

Under a heuristic Data Vault classification mined from the foreign-key structure, MSC_INSTANCE_ORGS leans toward a satellite role: it holds descriptive and attribute-level detail about the association between two business keys (instance and organization) rather than defining the key relationship itself.

Key Information Stored

The documented primary key MSC_INSTANCE_ORGS_PK is composite, comprising SR_INSTANCE_ID and ORGANIZATION_ID. A unique index, MSC_INSTANCE_ORGS_U1, exists on ORGANIZATION_ID and SR_INSTANCE_ID, making the pair the effective business-key candidate.

Common Use Cases and Queries

Typical scenarios include confirming which organizations are collected for an instance, auditing enabled versus disabled organizations, and troubleshooting stale collections by inspecting the LRN and last-success timestamps.

To list enabled organizations for an instance:

  • SELECT ORGANIZATION_ID, ORG_GROUP, ORGANIZATION_TYPE FROM MSC.MSC_INSTANCE_ORGS WHERE SR_INSTANCE_ID = :instance AND ENABLED_FLAG = 'Y';
  • SELECT i.INSTANCE_CODE, o.ORGANIZATION_ID, o.ENABLED_FLAG FROM MSC.MSC_INSTANCE_ORGS o, MSC.MSC_APPS_INSTANCES i WHERE o.SR_INSTANCE_ID = i.SR_INSTANCE_ID;

Related Objects