Results for “fa_rx_attrsets_b”
50+ 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).
- REPORT_ID — identifier of the parent RX report; join key to
FA_RX_REPORTS. - ATTRIBUTE_SET — name/identifier of the attribute set variant within the report.
- PUBLIC_FLAG, SYSTEM_FLAG — control visibility and whether the set is seeded (system) versus user-defined.
- PAGE_WIDTH, PAGE_HEIGHT — physical page geometry used by the report renderer.
- PRINT_SOB_FLAG, PRINT_FUNC_CURR_FLAG — control printing of the set of books and functional currency.
- PRINT_TITLE, PRINT_SUBMISSION_DATE, PRINT_CURRENT_PAGE, PRINT_TOTAL_PAGES, PRINT_PARAMETERS — header/footer content switches.
- PRINT_PAGE_BREAK_COLS, GROUP_DISPLAY_TYPE — grouping and pagination behavior.
- DEFAULT_DATE_FORMAT, DEFAULT_DATE_TIME_FORMAT, DEFAULT_NUMERIC_CHARACTERS — formatting defaults applied to output values.
- ZD_EDITION_NAME — edition-tracking column supporting Edition-Based Redefinition (EBR), part of the unique index.
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_IDreferences it. - FA_RX_ATTRSETS_TL — MLS translation table; joins on
REPORT_IDandATTRIBUTE_SET. - FA_RX_REP_COLUMNS_B — defines the report columns available to the attribute set; joins on
REPORT_IDandATTRIBUTE_SET. - FA_RX_SECURITY — security definitions scoped by
REPORT_IDandATTRIBUTE_SET. - FA_RX_ATTRSETS_B_PK / FA_RX_ATTRSETS_B_U1 — primary and unique indexes underpinning lookups.
-
Stores attribute set information for RX reports (base MLS table)
-
Stores attribute set information for RX reports (base MLS table)
-
TABLE: FA.FA_RX_ATTRSETS_B 12.2.2
-
TABLE: FA.FA_RX_ATTRSETS_B 12.1.1
-
VIEW: FA.FA_RX_ATTRSETS_B# 12.2.2
-
View: FA_RX_ATTRSETS_VL 12.2.2
Stores attribute set information for RX reports (translated MLS view)
APPS.FA_RX_ATTRSETS_VL·↳ FA_RX_ATTRSETS_B·↳ FA_RX_ATTRSETS_TL·Explore OFA module →
-
Stores Attribute Set information for RX reports (translated MLS table)
-
Stores Attribute Set information for RX reports (translated MLS table)
-
View: FA_RX_ATTRSETS_VL 12.1.1
Stores attribute set information for RX reports (translated MLS view)
APPS.FA_RX_ATTRSETS_VL·↳ FA_RX_ATTRSETS_B·↳ FA_RX_ATTRSETS_TL·Explore OFA module →
-
VIEW: FA.FA_RX_ATTRSETS_B# 12.2.2
-
Stores security assignments for Report eXchange Attribute sets
-
VIEW: APPS.FA_RX_ATTRSETS_VL 12.1.1
-
VIEW: APPS.FA_RX_ATTRSETS_VL 12.2.2
-
Stores security assignments for Report eXchange Attribute sets
-
Stores attribute definitions for Report eXchange report attributes (base MLS table)
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
VIEW: APPS.FA_RX_ATTRSETS_VL 12.1.1
-
VIEW: APPS.FA_RX_ATTRSETS_VL 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
Stores attribute definitions for Report eXchange report attributes (base MLS table)
-
eTRM - OFA Tables and Views 12.2.2
-
eTRM - OFA Tables and Views 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
eTRM - OFA Tables and Views 12.1.1
-
eTRM - OFA Tables and Views 12.2.2