Search Results hz_financial_reports




Overview
Explore in AI Chat

Overview

HZ_FINANCIAL_REPORTS is a Receivables (AR) module table that stores financial reports associated with parties — customers, prospects, suppliers, or other trading partners registered in the TCA (Trading Community Architecture) registry. Within Oracle E-Business Suite 12.1.1 and 12.2.2, this table is part of the party data model that supports credit analysis, risk assessment, and financial due diligence. Each row represents a single financial report, such as a balance sheet, income statement, or cash flow statement, issued by or on behalf of a party.

From a Data Vault modeling perspective, the heuristic classification of HZ_FINANCIAL_REPORTS is hub-leaning. The table is anchored by a single-column surrogate primary key and carries a foreign key to HZ_PARTIES, with dependent detail tables (financial numbers, extensibility attributes) hanging off it. This suggests treating HZ_FINANCIAL_REPORTS as a hub-like entity whose natural business key is captured by the unique constraints documented in the physical schema.

Key Information Stored

The table contains 38 documented columns. The most significant include:

Two unique indexes define business-key candidates. HZ_FINANCIAL_REPORTS_U1 is a single-column unique index on FINANCIAL_REPORT_ID, which is the surrogate key. HZ_FINANCIAL_REPORTS_U2 is a composite unique index spanning PARTY_ID, TYPE_OF_FINANCIAL_REPORT, DOCUMENT_REFERENCE, DATE_REPORT_ISSUED, ISSUED_PERIOD, REPORT_START_DATE, REPORT_END_DATE, and ACTUAL_CONTENT_SOURCE. This composite constraint represents the true natural or business key of the entity and should be used when deduplicating or integrating source data.

Common Use Cases and Queries

HZ_FINANCIAL_REPORTS is typically queried during credit evaluation and customer risk profiling. A common pattern joins the report header to the party and to its subordinate number lines:

  • Party financial profile: SELECT r.financial_report_id, r.type_of_financial_report, r.date_report_issued, r.report_start_date, r.report_end_date FROM hz_financial_reports r WHERE r.party_id = :party_id ORDER BY r.date_report_issued DESC;
  • Report with financial line items: join HZ_FINANCIAL_NUMBERS on FINANCIAL_REPORT_ID to retrieve the actual figures (revenue, liabilities, equity) belonging to each report.
  • Audited or restated report discovery: filter on AUDIT_IND = 'Y' or RESTATED_IND = 'Y' to identify high-integrity statements for underwriting decisions.
  • Regulatory extracts: group by REQUIRING_AUTHORITY and ISSUED_PERIOD to satisfy reporting obligations.

Because extensibility attributes are stored in the HZ_FIN_REPORTS_EXT_B and HZ_FIN_REPORTS_EXT_TL tables, reporting queries that need descriptive flexfield values must join those tables on FINANCIAL_REPORT_ID.

Related Objects

  • HZ_PARTIES — referenced by HZ_FINANCIAL_REPORTS.PARTY_ID; the parent party record.
  • HZ_FINANCIAL_NUMBERS — child table linked via FINANCIAL_REPORT_ID; stores the numeric values reported.
  • HZ_FIN_REPORTS_EXT_B — child table linked via FINANCIAL_REPORT_ID; stores extensibility (descriptive flexfield) attributes.
  • HZ_FIN_REPORTS_EXT_TL — child table linked via FINANCIAL_REPORT_ID; stores translated extensibility attribute text.
  • HZ_IMP_FINNUMBERS_SG — interface/staging table linked via FINANCIAL_REPORT_ID for bulk import of financial numbers.
  • HZ_IMP_FINREPORTS_SG — interface/staging table linked via FINANCIAL_REPORT_ID for bulk import of financial reports.

These relationships confirm HZ_FINANCIAL_REPORTS as a central header entity in the party financial data model, with dependent detail, extensibility, and import tables referencing its primary key.