Search Results parent_financial_item_id




Overview
Explore in AI Chat

Overview

APPS.RCI_FINANCIAL_LINE_V is a reporting view in Oracle E-Business Suite that exposes the financial statement line (financial item) definitions used by the Enterprise Tax, Regulatory and Compliance Management (ETRM) module and its financial reporting infrastructure. The view serves as a denormalized, consumer-friendly projection of the metadata that ties together a financial statement identifier, its constituent financial statement items, and the report axis definitions that drive their display.

Its principal role is to provide a lookup-style list of valid financial line values for a given financial statement, presenting each line as an id/value pair together with the owning FINANCIAL_STATEMENT_ID. This makes it suitable for value-set style list-of-values population, report parameter selection, and integration payloads where a downstream process must reference the current, active set of financial line items belonging to a specific statement.

Underlying Base Objects

As documented in the ETRM metadata, the view is defined over two logical sources joined in a single SELECT:

The join condition is AFSI.FINANCIAL_ITEM_ID = AFIV.FINANCIAL_ITEM_ID. A correlated subquery restricts the result to the highest STATEMENT_GROUP_ID available for each FINANCIAL_STATEMENT_ID, meaning the view always returns the most recent statement group version of the statement rather than historical group revisions. No additional base objects are documented in the ETRM metadata.

Key Columns

  • ID (AFIV.FINANCIAL_ITEM_ID) — the surrogate identifier of the financial line item. In the derived table this is sourced from the report axis SEQUENCE column, which acts as the item identifier for the report axis.
  • VALUE (AFIV.NAME) — the display name of the financial line item, sourced from RG_REPORT_AXES_V. This is the human-readable label typically presented to users.
  • FINANCIAL_STATEMENT_ID (AFSI.FINANCIAL_STATEMENT_ID) — the identifier of the parent financial statement to which the line item belongs. This is the column most relevant to the searched term and functions as the primary filtering key for the view.

The derived table additionally exposes DESCRIPTION, DISPLAY_FLAG, and a null-valued PARENT_FINANCIAL_ITEM_ID, though only FINANCIAL_ITEM_ID and NAME are projected into the outer view's public column list.

Common Use Cases and Queries

The view is most often queried to retrieve the valid line items for a known financial statement, for example when building a selection list or validating an inbound reference.

SELECT id, value, financial_statement_id
FROM   apps.rci_financial_line_v
WHERE  financial_statement_id = :p_statement_id
ORDER  BY id;

Because the view already filters to DISPLAY_FLAG='Y' and the maximum statement group, it can be used without additional filtering to enumerate active, displayable lines:

SELECT value
FROM   apps.rci_financial_line_v
WHERE  financial_statement_id = :p_statement_id;

Integration scenarios typically join the view back to statement header information or to AMW_FIN_STMNT_ITEMS_B to resolve a line identifier to its descriptive name during data extraction and reconciliation.

SELECT l.financial_statement_id, l.id, l.value
FROM   apps.rci_financial_line_v l
WHERE  EXISTS (SELECT 1
               FROM   amw_fin_stmnt_items_b b
               WHERE  b.financial_item_id = l.id);

Query performance is influenced by the correlated subquery against AMW_FIN_STMNT_ITEMS_B and by the underlying report axis views; filtering on FINANCIAL_STATEMENT_ID is recommended when the calling process already knows the target statement.