Results for “instance_ou_id”

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

Overview

The CSI_I_ORG_ASSIGNMENTS table is a core Install Base (CSI) object that stores the association between an installed instance record and an operating unit (organization). In Oracle EBS 12.1.1 and 12.2.2, this table governs which operating units are permitted to view, transact against, or administratively own a given customer product instance. Because Install Base records can span multiple operating units in a shared or global deployment, this association table effectively acts as the security and visibility bridge between the item instance and the organizational hierarchy.

The documented foreign keys reference both CSI_ITEM_INSTANCES (via INSTANCE_ID) and FND_SECURITY_GROUPS (via SECURITY_GROUP_ID), reinforcing its role as the intersection of instance identity and organizational access control. Based on the foreign-key topology mined from the metadata, the table exhibits a hub-leaning characteristic within a Data Vault modeling heuristic: the unique business key (INSTANCE_OU_ID) is highly stable and referenced by multiple dependent structures, making it a natural candidate for a hub entity in a Data Vault representation.

Key Information Stored

The table contains 30 documented columns. The most operationally significant are:

• INSTANCE_OU_ID — The surrogate/primary key defined by the unique index CSI_I_ORG_ASSIGNMENTS_U01 and the constraint CSI_I_ORG_ASSIGNMENTS_PK. This is the business-key candidate for the association.
• INSTANCE_ID — Foreign key to CSI_ITEM_INSTANCES, identifying the installed instance being assigned.
• OPERATING_UNIT_ID — The operating unit to which the instance is associated.
• RELATIONSHIP_TYPE_CODE — Classifies the nature of the association between instance and organization.
• ACTIVE_START_DATE / ACTIVE_END_DATE — Define the effective period of the association, enabling date-tracked reporting.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, controlling multi-org security visibility.
• OBJECT_VERSION_NUMBER — Supports optimistic locking for concurrent updates.
• MIGRATED_FLAG — Indicates whether the record was migrated from a legacy system.
• MIGRATED_FLAG, CONTEXT, ATTRIBUTE1–15 — Descriptive flexfield context and attribute columns for extensibility.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns.

Common Use Cases and Queries

Typical reporting and integration scenarios include verifying which operating units can view a given instance, auditing assignments over time, and reconciling interface-loaded records against the base table.

• Retrieve all active organizations for an instance:

  SELECT INSTANCE_ID, OPERATING_UNIT_ID, RELATIONSHIP_TYPE_CODE, ACTIVE_START_DATE
  FROM CSI.CSI_I_ORG_ASSIGNMENTS
  WHERE INSTANCE_ID = :instance_id
  AND SYSDATE BETWEEN ACTIVE_START_DATE AND NVL(ACTIVE_END_DATE, SYSDATE);

• Join to CSI_ITEM_INSTANCES to resolve instance serial numbers or product descriptions for multi-org reporting.
• Compare current versus historical assignments via CSI_I_ORG_ASSIGNMENTS_H.
• Detect records pending migration using MIGRATED_FLAG.
• Validate interface data staged in CSI_INSTANCE_INTERFACE against existing assignments.

Related Objects

• CSI_ITEM_INSTANCES — Joined on INSTANCE_ID; provides the instance master record.
• FND_SECURITY_GROUPS — Joined on SECURITY_GROUP_ID; enforces multi-org security.
• CSI_I_ORG_ASSIGNMENTS_H — History table referencing INSTANCE_OU_ID; tracks prior versions.
• CSI_T_ORG_ASSIGNMENTS — Interface/translator table referencing INSTANCE_OU_ID.
• CSI_INSTANCE_INTERFACE — Staging interface referencing INSTANCE_OU_ID for inbound loads.