Search Results for_viewby_flag

Overview

The table FII.FII_COM_PMV_AGRT_NODES is an Oracle E-Business Suite table owned by the FII (Financial Intelligence) schema. It is deployed in the APPS_TS_TX_DATA tablespace with a status of VALID and is registered as FND Design Data under the identifier FII.FII_COM_PMV_AGRT_NODES. The object belongs to the Oracle Enterprise Performance Foundation / Financial Intelligence family of components, which support profitability management, aggregation modeling, and view-by reporting constructs across Oracle EBS 12.1.1 and 12.2.2.

Functionally, the table stores the aggregation and view-by availability state for hierarchical nodes within the FII common profitability management model. Per the object documentation, "This table stores the information whether the node is aggregated and available for viewby." Each row therefore represents a node state keyed on a company flex value identifier.

In Data Vault modeling terms, the mined relationship metadata classifies this table as standalone, with a single foreign-key dependency to PN_COMPANIES_ALL via COMPANY_ID. As a modeling suggestion, this object can be interpreted as a satellite-style descriptive table attached to the company hub represented by PN_COMPANIES_ALL: it carries non-key descriptive flags (FOR_VIEWBY_FLAG, AGGREGATED_FLAG) plus standard audit columns, rather than acting as a hub or a link between multiple business entities. This interpretation should be validated against the actual model intent, since the mined classification is heuristic.

Key Information Stored

The table consists of eight documented columns. The most significant are:

• COMPANY_ID (NUMBER(15)) — The flex value identifier for the company. It is the primary business identifier for the row and the column that participates in the foreign-key relationship to PN_COMPANIES_ALL. Documented as the flex value identifier, it is the natural key candidate for node lookup.
• FOR_VIEWBY_FLAG (VARCHAR2) — The flag that indicates whether the node is available for view-by reporting. This is the column referenced by the user's search term and is the principal control attribute of the table.
• AGGREGATED_FLAG (VARCHAR2) — The flag indicating whether the node has been aggregated. Together with FOR_VIEWBY_FLAG it defines the aggregation and availability state of each node.
• LAST_UPDATE_DATE (DATE), LAST_UPDATED_BY (NUMBER(15)), CREATION_DATE (DATE), CREATED_BY (NUMBER(15)), and LAST_UPDATE_LOGIN (NUMBER(15)) — The standard WHO audit columns present in nearly all EBS transactional tables, capturing creation and last-modification context for each row.

No surrogate primary key column beyond COMPANY_ID is documented in the provided metadata, and no unique index is listed. COMPANY_ID should therefore be treated as the business-key candidate that uniquely identifies a node row, subject to confirmation against the physical data dictionary.

Common Use Cases and Queries

The primary use case is determining which nodes are eligible for view-by presentation and which have been aggregated, typically for profitability and Financial Intelligence reporting processes. A straightforward retrieval uses the documented query text:

• SELECT COMPANY_ID, FOR_VIEWBY_FLAG, AGGREGATED_FLAG, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN FROM FII.FII_COM_PMV_AGRT_NODES;
• Filtering nodes available for view-by: SELECT COMPANY_ID FROM FII.FII_COM_PMV_AGRT_NODES WHERE FOR_VIEWBY_FLAG = 'Y';
• Identifying remaining unaggregated nodes: SELECT COMPANY_ID FROM FII.FII_COM_PMV_AGRT_NODES WHERE AGGREGATED_FLAG = 'N';
• Join to the company master for descriptive reporting: SELECT t.COMPANY_ID, t.FOR_VIEWBY_FLAG, c.COMPANY_NAME FROM FII.FII_COM_PMV_AGRT_NODES t, PN_COMPANIES_ALL c WHERE t.COMPANY_ID = c.COMPANY_ID;

These patterns support reconciliation reports, audit of aggregation completeness, and troubleshooting of view-by hierarchies that fail to return expected nodes.

Related Objects

• PN_COMPANIES_ALL — Referenced through the documented foreign key FII_COM_PMV_AGRT_NODES.COMPANY_ID → PN_COMPANIES_ALL; supplies company descriptive attributes.
• APPS.FII_COM_PMV_AGRT_NODES — The APPS synonym or wrapper view that exposes the table to the application layer.
• FII schema aggregation and view-by objects — Sibling tables and packages in the FII community profitability management model that consume the flags stored here.
• FND Design Data registration — The FII.FII_COM_PMV_AGRT_NODES design data entry that governs table definition and patching.

The metadata indicates the table does not reference any database object beyond the single foreign key above, and it is referenced only through the APPS synonym.