Search Results icx_org_address_v




Overview
Explore in AI Chat

Overview

ICX_ORG_ADDRESS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite. It belongs to the ICX product family, Oracle iProcurement, and is described in the ETRM metadata as the "Organizations Address View." The object carries a VALID status in both the 12.1.1 and 12.2.2 environments. Its purpose is to present a consolidated, read-only projection of organization identity and address information, drawing organization attributes together with the ledger context that applies to the organization.

The view is consumed primarily by iProcurement and related procurement or self-service flows that must resolve a shipping, billing, or organizational address without navigating multiple inventory and financials tables. Because the view exposes both SET_OF_BOOKS_ID and SET_OF_BOOKS_NAME, it is frequently reached by users and developers searching for the ledger (set of books) name associated with a given organization. It functions as a convenience layer over the organization master, ensuring that address components are already concatenated and labeled for display and reporting.

Underlying Base Objects

The documented ETRM metadata identifies the referenced base objects as HR_GENERAL (PACKAGE), HR_SECURITY (PACKAGE), and MTL_ORGANIZATIONS (VIEW). The view definition is anchored on MTL_ORGANIZATIONS, which supplies all projected columns including ORGANIZATION_ID, the address elements, the ledger identifiers, and the descriptive attributes. HR_SECURITY and HR_GENERAL are not projected as columns; they participate in the security and resolution logic that governs which organization rows are visible and how organizational context is derived.

Although the apparent FROM clause references a single object, MTL_ORGANIZATIONS is itself a view, so the effective data ultimately originates from the organization definition tables behind it. The inclusion of HR_SECURITY reflects the application of organization-level security, meaning that access to rows can be restricted according to the security profile under which the query executes.

Key Columns

  • ORGANIZATION_ID — Primary identifier of the organization; the join key to inventory, purchasing, and ledger relationships.
  • ORGANIZATION_CODE — Short code used to reference the organization in transactions and setups.
  • ORGANIZATION_NAME — Descriptive name of the organization.
  • ADDRESS1, ADDRESS2, ADDRESS3 — Address line components.
  • CITY, STATE, COUNTRY, ZIP_CODE — Locality, region, country, and postal code elements.
  • CITY_STATE_ZIP — A pre-concatenated display value formed as CITY || ', ' || STATE || ' ' || ZIP_CODE.
  • SET_OF_BOOKS_ID — Identifier of the ledger (set of books) associated with the organization, used for financials joins.
  • SET_OF_BOOKS_NAME — Human-readable name of that ledger; the column most often sought when resolving ledger context from an organization.
  • SYMBOL, ORG_INFO, VALUE — Descriptive and categorization attributes carried from the base organization view.

Common Use Cases and Queries

The principal use case is resolving address and ledger information for one or many organizations within iProcurement or custom reporting. A typical query retrieves the address and ledger name for a specific organization:

SELECT organization_id, organization_name, city_state_zip, set_of_books_name FROM apps.icx_org_address_v WHERE organization_id = :p_org_id;

A second common pattern lists all organizations belonging to a given ledger, which supports financials-driven reporting:

SELECT organization_code, organization_name, set_of_books_name FROM apps.icx_org_address_v WHERE set_of_books_id = :p_sob_id ORDER BY organization_name;

Because HR_SECURITY participates in the view definition, results are subject to the security profile of the executing user, so row counts may vary between sessions. Consumers should treat the view as read-only and avoid using it as a substitute for the organization master when updating data.