Results for “wh_udpate_id”

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

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:

• FINANCIAL_REPORT_ID — the surrogate primary key (HZ_FINANCIAL_REPORTS_PK), the unique identifier for each financial report record.
• PARTY_ID — foreign key to HZ_PARTIES, identifying the party to which the report belongs.
• TYPE_OF_FINANCIAL_REPORT — the classification of the report (for example, balance sheet, income statement, or cash flow statement).
• DOCUMENT_REFERENCE — an external reference or document identifier for the report.
• DATE_REPORT_ISSUED and ISSUED_PERIOD — issuance date and the accounting period covered by the report.
• REPORT_START_DATE and REPORT_END_DATE — the beginning and end of the reporting period.
• REQUIRING_AUTHORITY — the authority or regulator that required the report, where applicable.
• AUDIT_IND, CONSOLIDATED_IND, ESTIMATED_IND, FINAL_IND, FORECAST_IND — indicator columns describing the nature and status of the report.
• QUALIFIED_IND, RESTATED_IND, SIGNED_BY_PRINCIPALS_IND, TRIAL_BALANCE_IND, UNBALANCED_IND — additional audit and assurance indicators.
• CONTENT_SOURCE_TYPE and ACTUAL_CONTENT_SOURCE — describe how the report content was captured.
• STATUS and OBJECT_VERSION_NUMBER — record state and optimistic locking columns.

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.