Search Results ax_secondary_inventory




Overview
Explore in AI Chat

Overview

AX_SECONDARY_INVENTORY is a table owned by the AX schema, which belongs to the Global Accounting Engine product in Oracle E-Business Suite 12.1.1 and 12.2.2. The table stores numeric identifiers and descriptive names for Inventory sub-organizations, providing the Global Accounting Engine with a controlled reference of secondary inventory designations. Its documented state is VALID, and the physical schema exposes eight columns with a single primary key constraint, AX_SECONDARY_INVENTORY_PK, defined on SECONDARY_INVENTORY_ID.

From a Data Vault modeling perspective, the mined relationship classification for this object is standalone. This heuristic suggests the table functions primarily as a reference or dimension-style hub of secondary inventory identifiers, with no documented foreign-key links to parent or child objects within the extracted schema. Analysts designing a dimensional or Data Vault representation should therefore treat AX_SECONDARY_INVENTORY as a candidate reference hub, carrying an independent business identifier (SECONDARY_INVENTORY_NAME) alongside its surrogate key rather than as a link or satellite.

Key Information Stored

The most significant columns documented in the ETRM metadata are the following:

  • SECONDARY_INVENTORY_ID — the surrogate primary key (AX_SECONDARY_INVENTORY_PK) and also the sole unique-index column (AX_SECONDARY_INVENTORY_U1). It uniquely identifies each secondary inventory record.
  • SECONDARY_INVENTORY_NAME — the descriptive business-key candidate; the human-readable name of the sub-organization.
  • ORGANIZATION_ID — associates the secondary inventory with a specific inventory organization, providing the multi-org context.
  • LAST_UPDATE_DATE — the date and time of the most recent modification to the row.
  • LAST_UPDATED_BY — the application user who performed the most recent change.
  • LAST_UPDATE_LOGIN — the login session identifier associated with that change.
  • CREATION_DATE — the date on which the record was first created.
  • CREATED_BY — the application user who created the record.

The WHO columns (LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE) follow the standard Oracle EBS audit convention and should be relied upon for change tracking, reconciliation, and data lineage reporting.

Common Use Cases and Queries

Typical scenarios include validating secondary inventory values referenced in Global Accounting Engine postings, building lookups for sub-organization reporting, and reconciling inventory sub-organizations against the core inventory organization setup. A representative query retrieving the identifying attributes for an organization is:

SELECT secondary_inventory_id,
       secondary_inventory_name,
       organization_id
FROM   ax.ax_secondary_inventory
WHERE  organization_id = :p_organization_id
ORDER  BY secondary_inventory_name;

Point lookups by surrogate key use the primary key access path:

SELECT *
FROM   ax.ax_secondary_inventory
WHERE  secondary_inventory_id = :p_secondary_inventory_id;

Data-audit reports leverage the WHO columns, for example to trace records created or amended after a given cutoff:

SELECT secondary_inventory_id,
       secondary_inventory_name,
       created_by,
       creation_date,
       last_updated_by,
       last_update_date
FROM   ax.ax_secondary_inventory
WHERE  last_update_date >= :p_from_date;

Related Objects

The documented relationship data classifies AX_SECONDARY_INVENTORY as standalone, with no explicit foreign-key relationships mined from the schema. Consequently, the most significant related objects are those that share the ORGANIZATION_ID context or consume the SECONDARY_INVENTORY_ID semantics rather than formally declared dependents. Practitioners should verify integration points at implementation time. Candidate related objects include:

  • ORG_ORGANIZATION_DEFINITIONS — join on ORGANIZATION_ID to resolve organization names and codes.
  • MTL_SECONDARY_INVENTORIES — the core Inventory secondary-inventory setup, joinable by secondary inventory identifier or organization and name.
  • MTL_PARAMETERS — inventory organization parameters, joined by ORGANIZATION_ID.
  • AX_ORGANIZATIONS — the Global Accounting Engine organization reference, keyed by ORGANIZATION_ID.
  • GL_CODE_COMBINATIONS — indirectly referenced where secondary inventory values participate in accounting distributions.

Because the schema exposes a single unique index and no documented FKs, the table’s role is largely referential: it supplies authoritative secondary inventory identifiers and names that other Global Accounting Engine and Inventory processes consume by value.