Search Results inventory_enabled_flag

Overview

MSD_ORGANIZATION_DEFINITIONS is an APPS-owned database view within the Oracle EBS Demand Planning (MSD) product family. It presents a consolidated, business-friendly picture of the inventory organizations defined in an EBS instance, joining organization unit definitions to their inventory parameters, accounting configurations, and operating unit assignments. The view exposes organization-level attributes required by planning and reporting processes that need to know which organizations are valid, inventory-enabled, and associated with a set of books.

Because the underlying definitions span several distinct EBS schemas and modules (HR organization units, inventory parameters, and General Ledger sets of books), the view provides application developers, report writers, and integration developers with a single access point rather than requiring them to reconstruct the join logic themselves. Its role is primarily read-only reference data for demand planning setup, organization validation, and cross-module reporting.

Underlying Base Objects

The documented view definition references the following base objects: FND_PRODUCT_GROUPS (synonym), GL_SETS_OF_BOOKS (view), HR_ALL_ORGANIZATION_UNITS_VL (view), HR_ORGANIZATION_INFORMATION (synonym), and MTL_PARAMETERS (synonym). The organization identity and names are drawn from HR_ALL_ORGANIZATION_UNITS (the base of the _VL view), which stores the organization unit record and its effective dates. Classification and accounting attributes come from HR_ORGANIZATION_INFORMATION, which is joined twice — once for the inventory classification context and once for the accounting information context. Inventory parameters (organization code and calendar) come from MTL_PARAMETERS, while set of books and chart of accounts data come from GL_SETS_OF_BOOKS. FND_PRODUCT_GROUPS supplies the multi-organization flag that controls how the operating unit value is derived.

Key Columns

• ORGANIZATION_ID — Primary organization identifier joining all source tables.
• BUSINESS_GROUP_ID — The business group to which the organization belongs.
• USER_DEFINITION_ENABLE_DATE / DISABLE_DATE — Effective dating (DATE_FROM / DATE_TO) for the organization definition.
• ORGANIZATION_CODE — The short inventory organization code from MTL_PARAMETERS.
• ORGANIZATION_NAME — The descriptive organization name.
• SET_OF_BOOKS_ID / CHART_OF_ACCOUNTS_ID — Accounting configuration associated with the organization.
• INVENTORY_ENABLED_FLAG — Sourced from HOI1.ORG_INFORMATION2. In the view text this column is populated only for rows where the inventory class context equals 'INV' and the flag equals 'Y', so returned rows are inventory-enabled organizations.
• OPERATING_UNIT — Derived conditionally; populated only when the multi-org flag is 'Y'.
• LEGAL_ENTITY — The legal entity identifier, populated only for the accounting information context.
• CALENDAR_CODE — The inventory calendar assigned to the organization.

Common Use Cases and Queries

The most frequent use case is retrieving the list of inventory-enabled organizations for planning or validation. Because the view filters on INVENTORY_ENABLED_FLAG = 'Y', a simple select returns only enabled organizations:

• Populating LOVs or validation lists in custom planning reports.
• Confirming which organizations are mapped to a given set of books or operating unit.
• Extracting organization setup data for demand planning configuration audits.

A representative query:

SELECT organization_id, organization_code, organization_name,
  set_of_books_id, operating_unit, calendar_code
 FROM apps.msd_organization_definitions
 WHERE inventory_enabled_flag = 'Y'
 ORDER BY organization_code;

Reports restricting by operating unit should test for NULL, since OPERATING_UNIT is populated conditionally based on the multi-org flag. Consuming code should treat the view as read-only reference data.