Results for “default_date_time_format”

24 results




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

Overview

FA_RX_ATTRSETS_B is a base table in the FA (Oracle Assets / OFA) schema that stores attribute set definitions used by the RX reporting engine. Each row defines a group of report-output attributes — page layout, header/footer content, date and numeric formats, and display options — that controls how an Oracle Assets RX report is rendered. In Oracle EBS 12.1.1 and 12.2.2, this table is a foundational metadata repository: the RX reporting framework reads it at runtime to determine which columns and formatting rules apply to a given report. It is the MLS base (non-translatable) counterpart to FA_RX_ATTRSETS_TL, which holds the language-specific descriptive text.

The physical schema documented in ETRM 12.2.2 lists 24 columns under owner FA. Applying a Data Vault modeling heuristic to the documented key structure, this object is hub-leaning: its composite primary key (REPORT_ID, ATTRIBUTE_SET) identifies a stable business key, while the descriptive layout and formatting columns behave satellite-like. Treating it as a hub with an associated satellite is a reasonable modeling suggestion, not a statement of EBS internal design.

Key Information Stored

The table is keyed by FA_RX_ATTRSETS_B_PK on the composite of REPORT_ID and ATTRIBUTE_SET. REPORT_ID identifies the owning RX report and is a foreign key to FA_RX_REPORTS; ATTRIBUTE_SET distinguishes multiple attribute-set variants defined for that report. Together they form the business-key candidate, reinforced by the unique index FA_RX_ATTRSETS_B_U1 on (REPORT_ID, ATTRIBUTE_SET, ZD_EDITION_NAME).

Common Use Cases and Queries

Typical uses include reviewing or comparing RX report layout definitions, troubleshooting formatting issues in an assets report, and auditing which attribute sets are public versus seeded. A basic lookup by report is straightforward:

SELECT attribute_set, public_flag, system_flag, page_width, page_height
FROM fa.fa_rx_attrsets_b
WHERE report_id = :p_report_id;

To resolve the translatable description alongside the base row, join to the TL table on both key columns:

SELECT b.attribute_set, t.description, b.system_flag
FROM fa.fa_rx_attrsets_b b, fa.fa_rx_attrsets_tl t
WHERE b.report_id = t.report_id AND b.attribute_set = t.attribute_set
AND t.language = USERENV('LANG');

Careful filtering on SYSTEM_FLAG and PUBLIC_FLAG is useful when enumerating only user-created or only seeded sets. Note that in EBR-enabled 12.2.2 environments, consider ZD_EDITION_NAME when comparing definitions across editions.

Related Objects

  • FA_RX_REPORTS — parent table; FA_RX_ATTRSETS_B.REPORT_ID references it.
  • FA_RX_ATTRSETS_TL — MLS translation table; joins on REPORT_ID and ATTRIBUTE_SET.
  • FA_RX_REP_COLUMNS_B — defines the report columns available to the attribute set; joins on REPORT_ID and ATTRIBUTE_SET.
  • FA_RX_SECURITY — security definitions scoped by REPORT_ID and ATTRIBUTE_SET.
  • FA_RX_ATTRSETS_B_PK / FA_RX_ATTRSETS_B_U1 — primary and unique indexes underpinning lookups.