Search Results hz_security_issued_pk

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:

• SECURITY_ISSUED_ID — surrogate primary key uniquely identifying each issued security.
• PARTY_ID — foreign key to HZ_PARTIES, identifying the issuing or associated party.
• STOCK_EXCHANGE_ID — foreign key to HZ_STOCK_MARKETS, the exchange where the security is traded.
• SECURITY_CURRENCY_CODE — foreign key to FND_CURRENCIES, defining the denomination currency.
• SECURITY_ISSUED_NAME — descriptive name of the issued security.
• SECURITY_ISSUED_CLASS — classification of the instrument (for example, equity or debt type).
• STOCK_TICKER_SYMBOL — market ticker symbol for the security.
• ESTIMATED_TOTAL_AMOUNT and TOTAL_AMOUNT_IN_A_CURRENCY — monetary measures of the issued amount.
• BEGIN_DATE and END_DATE — validity window for the issued security.
• STATUS — lifecycle or active status indicator.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard audit columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program context columns.

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.