Search Results org_organization_definitions2




Overview
Explore in AI Chat

Overview

ORG_ORGANIZATION_DEFINITIONS2 is an APPS-owned, VALID view within the INV (Inventory) product of Oracle E-Business Suite, documented against release 12.1.1 / 12.2.2. Its defining purpose is to expose two populations of organizations in a single result set: organizations that are genuinely configured as inventory organizations, and organizations that "claim" to be inventory organizations by way of organization classification information but that have no corresponding inventory parameters defined. This distinction is significant for data integrity and diagnostic reporting, because a row can be classified with an inventory context without ever having been fully instantiated through the inventory setup flow.

The user query term inventory_enabled_flag maps to the view column INVENTORY_ENABLED_FLAG, which is drawn from HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2. This makes the view particularly relevant to reporting and integration scenarios where the enablement state of an inventory organization must be surfaced independently of the presence of MTL_PARAMETERS rows.

Underlying Base Objects

The view is defined over the following documented referenced base objects:

The join between the accounting information context and GL_LEDGERS relies on a numeric translation test: DECODE(RTRIM(TRANSLATE(HOI2.ORG_INFORMATION1, '0123456789', ' ')), NULL, HOI2.ORG_INFORMATION1, -99999) must equal LGR.LEDGER_ID, and NVL(COMPLETE_FLAG, 'Y') = 'Y'.

Key Columns

  • ORGANIZATION_ID — primary organization identifier.
  • BUSINESS_GROUP_ID — owning business group.
  • USER_DEFINITION_ENABLE_DATE / DISABLE_DATE — the effective date range from the organization unit definition (DATE_FROM / DATE_TO).
  • ORGANIZATION_CODE — the short organization code from MTL_PARAMETERS; NULL for organizations claiming inventory status without parameters.
  • ORGANIZATION_NAME — descriptive organization name.
  • SET_OF_BOOKS_ID — ledger identifier from GL_LEDGERS.
  • CHART_OF_ACCOUNTS_ID — chart of accounts identifier from GL_LEDGERS.
  • INVENTORY_ENABLED_FLAG — the inventory enablement indicator (ORG_INFORMATION2), the column most frequently used to filter or report on inventory-enabled organizations.

Common Use Cases and Queries

Typical uses include identifying organizations with an inventory classification but no inventory parameters, auditing enablement flags, and driving downstream integrations that require both code and name even for partially configured organizations.

List organizations where the inventory classification exists:

  • SELECT organization_id, organization_code, organization_name, inventory_enabled_flag FROM apps.org_organization_definitions2 WHERE inventory_enabled_flag = 'Y';

Detect organizations claiming inventory status without parameters:

  • SELECT organization_id, organization_name, inventory_enabled_flag FROM apps.org_organization_definitions2 WHERE organization_code IS NULL;

Join to inventory parameters for fully configured organizations:

  • SELECT o.organization_id, o.organization_code, o.inventory_enabled_flag FROM apps.org_organization_definitions2 o, apps.mtl_parameters p WHERE o.organization_id = p.organization_id;