Search Results hz_security_issued_n1

Overview

The AR.HZ_SECURITY_ISSUED table is a TCA (Trading Community Architecture) registry object that stores information about financial instruments — such as stocks and bonds — issued by an organization (party). It captures the securities a party has brought to market, the exchange on which those securities trade, the applicable currency, and the associated monetary amounts. The table resides in the APPS_TS_TX_DATA tablespace at PCTFREE 10 and is owned by the AR schema, with FND design data registered as AR.HZ_SECURITY_ISSUED. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2.

Within a Data Vault modeling interpretation, this table is best classified heuristically as a link entity: it resolves the many-to-many relationship between a party (PARTY_ID → HZ_PARTIES) and a stock exchange (STOCK_EXCHANGE_ID → HZ_STOCK_MARKETS), while also carrying descriptive attributes about the specific issuance. The surrogate primary key SECURITY_ISSUED_ID provides the stable identity for each issuance record across the EBS data model.

Key Information Stored

The table contains 22 documented columns in the 12.2.2 physical schema. The most significant are:

• SECURITY_ISSUED_ID (NUMBER, 10) — Surrogate primary key and unique identifier of the security issued. Enforced by the unique index HZ_SECURITY_ISSUED_U1 (APPS_TS_TX_IDX), which is the documented business-key candidate for this table (see also HZ_SECURITY_ISSUED_PK).
• PARTY_ID (NUMBER, 15, mandatory) — Foreign key to HZ_PARTIES identifying the issuing organization. Indexed by non-unique HZ_SECURITY_ISSUED_N1.
• STOCK_EXCHANGE_ID (NUMBER, 15) — Foreign key to HZ_STOCK_MARKETS indicating the exchange on which the security is offered. Indexed by non-unique HZ_SECURITY_ISSUED_N2.
• SECURITY_CURRENCY_CODE (VARCHAR2, 15) — Currency of issuance; foreign key to FND_CURRENCIES.
• SECURITY_ISSUED_NAME (VARCHAR2, 240) — Descriptive name assigned to the issuance.
• SECURITY_ISSUED_CLASS (VARCHAR2, 30) — Classification such as public stock, common stock, preferred stock, gilt-edged bonds, or debentures.
• STOCK_TICKER_SYMBOL (VARCHAR2, 60) — Ticker assigned by the trading market.
• ESTIMATED_TOTAL_AMOUNT (NUMBER) — Total value of the issuance in whole numbers.
• TOTAL_AMOUNT_IN_A_CURRENCY (VARCHAR2, 240) — Estimated total amount expressed in currency.
• BEGIN_DATE / END_DATE — Effective dating of the issuance record.
• STATUS — Record state indicator.
• Standard WHO columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.
• Concurrent program context: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, plus WH_UPDATE_DATE for warehouse tracking.

Common Use Cases and Queries

Typical uses include party profile maintenance in the Customers/Suppliers forms, trade repository reporting, and securities analytics. Common query patterns:

• List all securities issued by a party:
  SELECT security_issued_id, security_issued_name, security_issued_class FROM hz_security_issued WHERE party_id = :p_party_id;
• Join to HZ_PARTIES to retrieve the issuer name:
  SELECT s.security_issued_name, p.party_name FROM hz_security_issued s, hz_parties p WHERE s.party_id = p.party_id;
• Analyze securities per exchange:
  SELECT stock_exchange_id, COUNT(*) FROM hz_security_issued GROUP BY stock_exchange_id;
• Reporting by currency class using FND_CURRENCIES for descriptive lookup.

Related Objects

• HZ_PARTIES — joined via HZ_SECURITY_ISSUED.PARTY_ID = HZ_PARTIES.PARTY_ID.
• HZ_STOCK_MARKETS — joined via HZ_SECURITY_ISSUED.STOCK_EXCHANGE_ID = HZ_STOCK_MARKETS.STOCK_EXCHANGE_ID.
• FND_CURRENCIES — joined via HZ_SECURITY_ISSUED.SECURITY_CURRENCY_CODE = FND_CURRENCIES.CURRENCY_CODE.
• TCA party APIs (HZ_PARTY_V2PUB, HZ_PARTY_SITE_V2PUB) and the Customers/Suppliers UI that maintain party-issued securities.
• Related HZ_* registry tables (e.g., HZ_STOCK_MARKETS) that share the AR schema and APPS_TS_TX_DATA storage.