Search Results org_access_view




Overview
Explore in AI Chat

Overview

ORG_ACCESS_VIEW is an APPS-owned database view in the Oracle EBS Inventory (INV) product. Its documented purpose is to resolve all organizations available for each responsibility, providing a consolidated list of inventory organizations a given responsibility is authorized to access. Rather than requiring report developers and integration builders to reconstruct organization security logic manually, the view encapsulates the intersection of organization definitions, inventory parameters, accounting information, and responsibility-level access control into a single queryable object.

The view is central to the Oracle EBS multi-organization security model, which uses the ORG_ACCESS table to grant or deny specific responsibilities access to specific inventory organizations. The user search term "resp_application_id" corresponds directly to the RESP_APPLICATION_ID column of this view, an alias for FND_RESPONSIBILITY.APPLICATION_ID. This column, together with RESPONSIBILITY_ID, forms the composite key used to join organization access records to responsibilities, and is therefore one of the most frequently referenced columns when building custom organization-security queries, reports, and interfaces.

Underlying Base Objects

The view selects from HR_ALL_ORGANIZATION_UNITS (aliased HOU) and its translation table HR_ALL_ORGANIZATION_UNITS_TL (HOUT), joined on ORGANIZATION_ID with the language restricted to USERENV('LANG'). HR_ORGANIZATION_INFORMATION is referenced twice: HOI1 filters the 'CLASS' context to identify inventory organizations (ORG_INFORMATION1 = 'INV' and ORG_INFORMATION2 = 'Y'), while HOI2 supplies the 'ACCOUNTING INFORMATION' context and maps the organization to a set of books. MTL_PARAMETERS (MP) provides the organization code, and GL_SETS_OF_BOOKS (a view, GSOB) supplies SET_OF_BOOKS_ID and CHART_OF_ACCOUNTS_ID. FND_RESPONSIBILITY (R) contributes the responsibility and application identifiers.

Security filtering is applied through the HR_SECURITY package and the HR_GENERAL package, the latter handling business group profile options including cross-business-group behavior. The critical access control predicate joins to ORG_ACCESS: an organization is returned either when an explicit, non-expired ORG_ACCESS row exists for the given RESP_APPLICATION_ID and RESPONSIBILITY_ID, or when no ORG_ACCESS row exists at all for that organization. All nine referenced base objects are documented in the ETRM metadata, and the view excludes organizations whose DATE_TO has passed.

Key Columns

  • ORGANIZATION_ID — Primary identifier of the inventory organization.
  • RESPONSIBILITY_ID — The responsibility granted (or inheriting) access to the organization.
  • RESP_APPLICATION_ID — Application owning the responsibility; combined with RESPONSIBILITY_ID it uniquely identifies the responsibility context.
  • ORGANIZATION_CODE — Inventory organization code from MTL_PARAMETERS.
  • ORGANIZATION_NAME — Translated organization name from HR_ALL_ORGANIZATION_UNITS_TL.
  • BUSINESS_GROUP_ID — Business group of the organization.
  • SET_OF_BOOKS_ID and CHART_OF_ACCOUNTS_ID — Accounting context from GL_SETS_OF_BOOKS.
  • INVENTORY_ENABLED_FLAG — Derived from ORG_INFORMATION2 of the INV class context; 'Y' for inventory-enabled organizations.

Common Use Cases and Queries

The view is typically used to enumerate valid organizations for LOVs, concurrent program parameter lists, custom reports, and interface validation. A common query returns all organizations accessible to a specific responsibility:

  • SELECT organization_id, organization_code, organization_name FROM apps.org_access_view WHERE responsibility_id = :resp_id AND resp_application_id = :resp_appl_id;
  • SELECT DISTINCT organization_id FROM apps.org_access_view WHERE resp_application_id = 401; — useful when validating organization-level data loads.
  • Joining ORG_ACCESS_VIEW to inventory transaction tables restricts reporting to authorized organizations, aligning custom extracts with EBS security.

Because the view evaluates ORG_ACCESS and HR_SECURITY at runtime, results reflect current access grants and organization end-dating, making it suitable for both interactive reporting and scheduled integrations.