Search Results industry_reference_id

Overview

HZ_INDUSTRIAL_REFERENCE is a Receivables (AR) module table that stores industrial reference information associated with organizations (parties) in Oracle E-Business Suite 12.1.1 and 12.2.2. Industrial references are typically regulatory, licensing, or certification identifiers issued to a business by an external authority — for example, a trade license number, a regulated industry registration, or a government-issued manufacturing permit. In the Oracle TCA (Trading Community Architecture) model, this table extends the core party record held in HZ_PARTIES with industry-specific identifier attributes used for compliance, credit evaluation, and master data stewardship.

The documented foreign key relationship from HZ_INDUSTRIAL_REFERENCE.PARTY_ID to HZ_PARTIES indicates that each row is subordinate to a parent party record. Based on the heuristic Data Vault classification derived from the FK structure, this table exhibits a satellite-leaning profile: its rows describe descriptive, time-relevant attributes of a party (the parent hub), rather than serving as a pure hub or as a link resolving a many-to-many relationship. This classification should be treated as a modeling suggestion rather than a canonical designation.

Key Information Stored

The table contains 17 documented columns. The most significant are:

• INDUSTRY_REFERENCE_ID — the surrogate primary key, enforced by HZ_INDUSTRIAL_REFERENCE_PK and also carrying a unique index (HZ_INDUSTRIAL_REFERENCE_U1). This is the technical identifier for each reference row.
• PARTY_ID — the foreign key to HZ_PARTIES, linking the reference to its owning organization.
• INDUSTRY_REFERENCE — the actual reference value or identifier text (for example, a license or registration number).
• ISSUED_BY_AUTHORITY — the body or agency that issued the reference.
• NAME_OF_REFERENCE — the descriptive name or title of the reference.
• RECOGNIZED_AS_OF_DATE — the date from which the reference is considered valid or recognized.
• STATUS — the current state of the reference (for example, active or inactive).
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO-column audit attributes.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program / request tracking columns recording the process that last touched the row.
• WH_UPDATE_DATE — the warehouse update date, used for incremental extraction into downstream reporting or data warehouse layers.

The single documented business-key candidate is the unique index on INDUSTRY_REFERENCE_ID; no separate natural-key unique constraint is recorded in the metadata.

Common Use Cases and Queries

Typical scenarios include retrieving all industrial references for a given organization, validating licenses during customer onboarding, and feeding compliance or credit reports.

SELECT r.industry_reference_id,
       r.industry_reference,
       r.issued_by_authority,
       r.recognized_as_of_date,
       r.status
FROM   hz_industrial_reference r
WHERE  r.party_id = :party_id
AND    r.status = 'A';

To join references back to the owning party for reporting:

SELECT p.party_name,
       r.name_of_reference,
       r.industry_reference,
       r.issued_by_authority
FROM   hz_parties p,
       hz_industrial_reference r
WHERE  p.party_id = r.party_id;

Incremental extraction into a warehouse commonly filters on wh_update_date or last_update_date to capture only changed rows.

Related Objects

The following objects are most significant in relation to this table:

• HZ_PARTIES — the parent table; joined via HZ_INDUSTRIAL_REFERENCE.PARTY_ID = HZ_PARTIES.PARTY_ID.
• HZ_PARTY_SITES — site-level party detail, frequently combined when a reference applies to a specific operating location.
• HZ_CUST_ACCOUNTS — the customer account layer that references parties, used to link industrial references to receivables customers.
• HZ_ORGANIZATION_PROFILES — organization-level attributes that complement industrial reference data.
• HZ_PARTY_USG_ASSIGNMENTS — role/usage assignments for parties, useful when filtering organizations by business function.
• HZ_INDUSTRIAL_REFERENCE_PK / HZ_INDUSTRIAL_REFERENCE_U1 — the primary key constraint and unique index that guarantee row integrity.