Search Results hz_security_issued




Overview
Explore in AI Chat

Overview

HZ_SECURITY_ISSUED is a Receivables (AR) table in Oracle E-Business Suite that stores financial instruments issued by an organization. It records securities such as stocks or bonds along with their identifiers, issuer, trading venue, currency, and active date range. The table sits within the Trading Community Architecture (TCA) model, since it anchors each issued security to a party via PARTY_ID. In EBS 12.1.1 and 12.2.2 the object remains VALID and is owned by the AR schema. The documented physical schema for 12.2.2 lists 22 columns.

From a Data Vault modeling perspective, this table is best classified as a link. The classification is heuristic, derived from the foreign-key structure: HZ_SECURITY_ISSUED references multiple hub-like entities (HZ_PARTIES, HZ_STOCK_MARKETS, and FND_CURRENCIES) and therefore acts as a connecting associative table between them, rather than as a standalone hub or a descriptive satellite. This is a modeling suggestion, not a documented fact.

Key Information Stored

The primary key is the surrogate identifier SECURITY_ISSUED_ID, enforced by the constraint HZ_SECURITY_ISSUED_PK. A unique index, HZ_SECURITY_ISSUED_U1, also exists on SECURITY_ISSUED_ID, confirming it as the single documented business-key candidate. The most significant columns are:

Common Use Cases and Queries

Typical usage includes reviewing all securities issued by a given party, reporting holdings by exchange, and validating currency-denominated instrument totals. A join to the party table resolves the issuer name:

SELECT s.security_issued_id, s.security_issued_name,
       p.party_name, s.stock_ticker_symbol
FROM   hz_security_issued s, hz_parties p
WHERE  s.party_id = p.party_id;

Reporting by exchange and currency joins the market and currency lookups:

SELECT s.security_issued_name, m.market_name,
       s.security_currency_code, s.total_amount_in_a_currency
FROM   hz_security_issued s, hz_stock_markets m
WHERE  s.stock_exchange_id = m.stock_exchange_id;

Related Objects

  • HZ_PARTIES — joined on HZ_SECURITY_ISSUED.PARTY_ID = HZ_PARTIES.PARTY_ID; provides issuer identity.
  • HZ_STOCK_MARKETS — joined on HZ_SECURITY_ISSUED.STOCK_EXCHANGE_ID = HZ_STOCK_MARKETS.STOCK_EXCHANGE_ID; trading venue.
  • FND_CURRENCIES — joined on HZ_SECURITY_ISSUED.SECURITY_CURRENCY_CODE = FND_CURRENCIES.CURRENCY_CODE; denomination lookup.
  • HZ_SECURITY_ISSUED_PK / HZ_SECURITY_ISSUED_U1 — primary key constraint and unique index on SECURITY_ISSUED_ID.