Search Results amw_financial_items_v




Overview
Explore in AI Chat

Overview

AMW_FINANCIAL_ITEMS_V is a reporting view owned by the APPS schema within the AMW — Internal Controls Manager product in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents row-level definitions from the Oracle Financial Statement Generator (FSG), exposing them in a normalized form that Internal Controls Manager and related reporting components can consume consistently. The view is documented as VALID and is a purpose-built abstraction: rather than querying the underlying FSG views directly, callers select from AMW_FINANCIAL_ITEMS_V to obtain a flat, renamed set of financial item records.

The view's principal role is to translate FSG axis metadata into the naming conventions expected by AMW. It filters the FSG axis data to row-type definitions only and discards rows that are flagged as non-displayed, producing a clean list of report row definitions suitable for reconciliation, controls testing, and downstream reporting integrations.

Underlying Base Objects

The view is defined over two FSG reporting views, joined on the axis set identifier:

  • RG_REPORT_AXES_V — aliased as AXE; supplies the individual axis (row and column) definitions.
  • RG_REPORT_AXIS_SETS_V — aliased as AXI; supplies the axis set header that classifies the set by type.

The join condition is AXE.AXIS_SET_ID = AXI.AXIS_SET_ID. Two predicates constrain the result set: AXI.AXIS_SET_TYPE = 'R', restricting output to row axis sets (that is, financial items rather than column definitions), and AXE.DISPLAY_FLAG = 'Y', excluding hidden or suppressed items. No base tables are documented beyond these two views; they themselves sit on top of the FSG schema structures that store axis set and axis definitions. Because the view is a pure projection over FSG views, it inherits FSG's security and access characteristics, and the querying user must already have access to the FSG reporting objects.

Key Columns

  • FINANCIAL_STATEMENT_ID — Mapped from AXE.AXIS_SET_ID. Identifies the parent axis set (the FSG financial statement/report layout) that the item belongs to. It is the grouping key for all items within one statement definition.
  • FINANCIAL_ITEM_ID — Mapped from AXE.SEQUENCE. Identifies the individual row definition within the statement. Note that this is the FSG sequence value, not an independent surrogate key.
  • NAME — The item's short name as defined on the FSG axis.
  • DESCRIPTION — The descriptive text for the financial item.
  • DISPLAY_FLAG — Flag denoting whether the item is displayed. As a result of the view's filter, this column always returns 'Y' for rows returned by the view.
  • PARENT_FINANCIAL_ITEM_ID — Hard-coded as NULL in the view text, providing a placeholder for hierarchical parent-child relationships in the normalized output shape. No hierarchy information is actually populated, but the column preserves interface compatibility for consumers expecting a parent reference.

Common Use Cases and Queries

Typical uses include listing the row definitions belonging to a specific FSG statement, auditing which items are available for controls mapping, and joining the view to AMW control or risk tables on the statement and item identifiers. A basic retrieval for a given statement is:

SELECT financial_statement_id, financial_item_id, name, description
FROM apps.amw_financial_items_v
WHERE financial_statement_id = :axis_set_id
ORDER BY financial_item_id;

To inventory all available financial items across statements:

SELECT financial_statement_id, COUNT(*) item_count
FROM apps.amw_financial_items_v
GROUP BY financial_statement_id
ORDER BY financial_statement_id;

Because DISPLAY_FLAG is always 'Y' and PARENT_FINANCIAL_ITEM_ID is always NULL, queries should not rely on those columns for filtering or hierarchy traversal; hierarchy relationships must be obtained from the underlying FSG views or related FSG structures if required. The rg_report_axis_sets_v search term frequently associated with this object reflects its dependency on RG_REPORT_AXIS_SETS_V, which is the authoritative source for axis set type classification used in the view's filter predicate.