Search Results hz_fin_reports_ext_b




Overview
Explore in AI Chat

Overview

HZ_FIN_REPORTS_EXT_B is an Oracle E-Business Suite table owned by the AR (Receivables) schema that stores extensible attributes for financial reports. It belongs to the Oracle Trading Community Architecture (TCA) family of objects and provides the descriptive-flexfield container attached to rows in HZ_FINANCIAL_REPORTS. Rather than scattering customer-specific or configuration-specific descriptive data across multiple columns in the parent report definition, EBS centralizes that data here in a fixed-width extensible attribute structure.

The table is registered as VALID in both release 12.1.1 and 12.2.2, and its physical definition is documented with 58 columns in the ETRM 12.2.2 schema extract. The surface area is dominated by the three extensible attribute blocks — twenty character attributes, twenty numeric attributes, and ten date attributes — which collectively account for fifty of the fifty-eight columns. The remaining columns carry the primary key, the parent foreign key, the attribute group identifier, and the standard WHO audit columns. Based on the foreign key structure and its position relative to HZ_FINANCIAL_REPORTS, the heuristic Data Vault classification is satellite-leaning: the table does not introduce new business entities of its own but extends an existing entity with descriptive, non-identifying attributes.

Key Information Stored

The following columns represent the structurally significant content of HZ_FIN_REPORTS_EXT_B:

  • EXTENSION_ID — The surrogate primary key, enforced through the HZ_FIN_REPORTS_EXT_B_PK constraint. It is also backed by the unique index HZ_FIN_REPORTS_EXT_B_U1, making it the documented business-key candidate for the row. In practice this is a system-generated identifier rather than a user-meaningful key.
  • FINANCIAL_REPORT_ID — The foreign key column that ties each extensible attribute row back to HZ_FINANCIAL_REPORTS. This is the join path that gives the table its meaning; without it the attribute row is orphaned.
  • ATTR_GROUP_ID — Identifies the attribute group under which the descriptive flexfield context is organized. It governs which of the C_EXT_ATTR, N_EXT_ATTR, and D_EXT_ATTR columns are meaningful for a given row.
  • C_EXT_ATTR1 through C_EXT_ATTR20 — Twenty character-typed extensible attribute slots used to hold free-form text values, codes, or flags configured by the implementing organization.
  • N_EXT_ATTR1 through N_EXT_ATTR20 — Twenty numeric-typed extensible attribute slots used for amounts, counts, thresholds, or other numeric values.
  • D_EXT_ATTR1 through D_EXT_ATTR10 — Ten date-typed extensible attribute slots used for effective dates, review dates, or other temporal values.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — The standard EBS WHO audit columns that record row provenance and last-modification metadata.

Common Use Cases and Queries

The primary use case is retrieving and reporting organization-specific descriptive flexfield values against a financial report definition. A typical query joins the extension table to its parent:

  • Reporting configured attribute values for a specific report: SELECT e.extension_id, e.attr_group_id, e.c_ext_attr1, e.n_ext_attr1, e.d_ext_attr1 FROM hz_fin_reports_ext_b e WHERE e.financial_report_id = :report_id
  • Auditing recently changed extension rows: SELECT * FROM hz_fin_reports_ext_b WHERE last_update_date > SYSDATE - 7
  • Joining to the parent report for a consolidated view: SELECT r.financial_report_id, e.c_ext_attr1 FROM hz_financial_reports r, hz_fin_reports_ext_b e WHERE r.financial_report_id = e.financial_report_id
  • Locating rows by attribute group to understand which flexfield context is in use: SELECT attr_group_id, COUNT(*) FROM hz_fin_reports_ext_b GROUP BY attr_group_id

Because the extensible attribute columns are generic, any reporting effort must first consult the descriptive flexfield segment definitions to interpret which column holds which business value. Direct DML against this table is not supported; attribute values should be maintained through the standard Receivables and TCA configuration and maintenance forms.

Related Objects

The most significant relationship is with the parent entity that this table extends:

  • HZ_FINANCIAL_REPORTS — The parent table referenced by HZ_FIN_REPORTS_EXT_B.FINANCIAL_REPORT_ID. This is the single documented foreign key relationship and defines the satellite-to-hub linkage.
  • HZ_FIN_REPORTS_EXT_B_PK — The primary key constraint on EXTENSION_ID.
  • HZ_FIN_REPORTS_EXT_B_U1 — The unique index on EXTENSION_ID supporting the primary key and serving as the documented business-key candidate.

Beyond the documented FK, related TCA and Receivables objects that commonly participate in the same functional area include the financial report definition views and descriptive flexfield metadata tables. Any integration or extract that reads financial report configuration must traverse this table through FINANCIAL_REPORT_ID to resolve the configured attribute values.