Search Results org_organization_definitions

Overview

ORG_ORGANIZATION_DEFINITIONS is a public APPS-owned database view in Oracle E-Business Suite that presents the master list of Inventory organizations. It is a central reference object for the INV (Inventory) module and is widely consumed by reports, concurrent programs, integrations, and custom SQL that need to resolve organization identifiers to human-readable names and codes. Rather than storing data itself, the view consolidates organization attributes scattered across the Oracle HR and Inventory schemas into a single, denormalized row per inventory organization.

The view is documented as VALID in ETRM and behaves consistently across EBS 12.1.1 and 12.2.2. Because the underlying foundation is built on HR organization units, the same view simultaneously exposes Inventory flags (for INV processing) and accounting attributes such as ledger and legal entity, which would otherwise require multiple joins across modules. This makes it one of the most commonly referenced views in EBS technical work, particularly in multi-org and subledger accounting contexts.

Underlying Base Objects

The view is constructed from several base objects across the APPS schema. The documented referenced objects are GL_LEDGERS (synonym), HR_GENERAL (package), HR_ORGANIZATION_INFORMATION (synonym), HR_ORGANIZATION_UNITS (view), HR_SECURITY (package), and MTL_PARAMETERS (synonym).

• HR_ORGANIZATION_UNITS — supplies the organization_id, business_group_id, name, and effective date ranges (date_from, date_to).
• HR_ORGANIZATION_INFORMATION — joined twice (aliases HOI1 and HOI2) to filter on the 'CLASS' context (identifying inventory orgs) and to read the 'ACCOUNTING INFORMATION' context for ledger and legal entity values.
• MTL_PARAMETERS — source of the organization_code and a join key on organization_id.
• GL_LEDGERS — provides the ledger_id (mapped to SET_OF_BOOKS_ID), chart_of_accounts_id, and is filtered to complete, valid ledgers (object_type_code = 'L').
• HR_GENERAL and HR_SECURITY — referenced packages that support organization access and security behavior rather than direct column sourcing.

The joins enforce the critical rule that only organizations whose CLASS context shows inventory enabled ('INV' / 'Y') are returned.

Key Columns

• ORGANIZATION_ID — unique inventory organization identifier; the primary join key throughout EBS.
• BUSINESS_GROUP_ID — the HR business group owning the organization.
• ORGANIZATION_CODE — short code from MTL_PARAMETERS, commonly used in transaction and interface data.
• ORGANIZATION_NAME — descriptive name from HR_ORGANIZATION_UNITS.
• SET_OF_BOOKS_ID — the ledger/GL identifier resolved from GL_LEDGERS.
• CHART_OF_ACCOUNTS_ID — chart of accounts associated with that ledger.
• INVENTORY_ENABLED_FLAG — derived from the 'CLASS' context, indicating inventory is enabled.
• OPERATING_UNIT and LEGAL_ENTITY — numeric identifiers pulled from the accounting information context.
• USER_DEFINITION_ENABLE_DATE and DISABLE_DATE — effective date boundaries for the organization.

Common Use Cases and Queries

Typical uses include reporting inventory organization listings, validating organization codes during data loads, and resolving ledgers for subledger accounting. A frequent requirement is mapping an organization_id to its code and name:

SELECT organization_id, organization_code, organization_name FROM org_organization_definitions WHERE organization_id = :p_org_id;

Another common pattern joins the view to transaction tables to enrich inventory data:

SELECT ood.organization_code, mtl.transaction_quantity FROM org_organization_definitions ood, mtl_material_transactions mtl WHERE ood.organization_id = mtl.organization_id;

Because HR security is involved, output may be restricted by the operating user's organization access, which is an important consideration when building reports or interfaces.