Results for “xtr_stock_issues”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

XTR_STOCK_ISSUES is a Treasury (XTR) module configuration table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores Stock Issues setup information. In the ETRM data model, a "stock issue" represents an equity instrument that has been issued by a stock issuer and is subsequently tracked for Treasury purposes such as holdings, valuations, and exposure reporting. The table functions as the master definition repository from which stock issue records are referenced when Treasury transactions, positions, or regulatory reports require a specific equity instrument to be identified.

The ETRM documentation classifies the table's Data Vault profile as standalone, meaning it carries its own descriptive attributes and does not behave as a transaction link or depend on parent hub relationships. In modeling terms, this suggests treating XTR_STOCK_ISSUES as a hub-like reference entity: it has a stable business key (STOCK_ISSUE_CODE) and a set of descriptive attributes that could be modeled as a satellite if a Data Vault layering were applied. The table contains 35 columns and is owned by the XTR schema.

Key Information Stored

The following columns are the most functionally significant for understanding and querying the table:

• STOCK_ISSUE_CODE — The primary key column, defined by the XTR_STOCK_ISSUES_PK constraint. It is also the single unique index candidate (XTR_STOCK_ISSUES_U1) and therefore serves as the business key that identifies each stock issue.
• DESCRIPTION — Human-readable name or description of the stock issue.
• STOCK_ISSUER — The entity that issued the stock; used for issuer-level reporting and exposure aggregation.
• SECURITY_ID — Foreign key referencing EDR_PSIG_SECURITY, linking the stock issue to the central security master record.
• CURRENCY — Denomination currency of the issue.
• TICKER_SYMBOL and RIC_CODE — External market identifiers; the RIC (Reuters Instrument Code) supports market data reconciliation.
• EXCHANGE — The exchange on which the issue is listed.
• ISSUE_DATE — Date the stock was issued, relevant for aging and lifecycle reporting.
• SECTOR and PRODUCT_TYPE — Classification attributes used in analytics and grouping.
• MARKET_DATA_SET and PRICING_MODEL — Define how the instrument is priced within Treasury valuation processes.
• AUTHORIZED — Status flag controlling whether the stock issue may be used in operational processing.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO columns for audit and concurrency.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield storage for client-specific extensions.

Common Use Cases and Queries

Typical use cases include validating that a stock issue is authorized before use in Treasury processing, reporting holdings or exposures by issuer, sector, or currency, and reconciling Treasury security identifiers to the EDR security master.

A common query pattern lists active issues by issuer:

SELECT stock_issue_code, description, stock_issuer, currency,
       ticker_symbol, issue_date
FROM   xtr.xtr_stock_issues
WHERE  authorized = 'Y'
ORDER  BY stock_issuer, stock_issue_code;

Joining to the security master to enrich Treasury records:

SELECT si.stock_issue_code, si.ticker_symbol, si.ric_code,
       si.exchange, s.security_name
FROM   xtr.xtr_stock_issues si,
       edr.edr_psig_security s
WHERE  si.security_id = s.security_id;

Aggregation reports by sector or currency are also common, using GROUP BY on SECTOR, CURRENCY, or PRODUCT_TYPE. Because the table is setup data, most reporting is read-only; DML normally occurs through the Treasury setup UI rather than direct SQL.

Related Objects

• EDR_PSIG_SECURITY — Referenced by XTR_STOCK_ISSUES.SECURITY_ID; provides the authoritative security master definition for each stock issue. This is the only documented foreign key relationship.
• XTR_STOCK_ISSUES_PK — The primary key constraint on STOCK_ISSUE_CODE.
• XTR_STOCK_ISSUES_U1 — The unique index reinforcing STOCK_ISSUE_CODE as the business key.
• XTR Treasury transaction and position tables — Downstream objects that consume STOCK_ISSUE_CODE to identify the equity instrument in holdings, valuations, and exposure calculations.
• Treasury setup and inquiry forms — User interfaces through which stock issues are created, authorized, and maintained.
• EDR product/security APIs — Programs that propagate security master changes affecting the SECURITY_ID reference.

Because the table is standalone with a single documented FK, integration impact is concentrated on the EDR security master and any Treasury objects keyed by STOCK_ISSUE_CODE.