Search Results eval_comments




Overview
Explore in AI Chat

Overview

The view POA_EDW_CSTM_MSR_F_IV belongs to the POA – Purchasing Intelligence product family, a component of the Oracle E-Business Suite that historically supported procurement analytics and supplier performance evaluation. This object is documented as obsolete within Oracle EBS 12.1.1 and 12.2.2, meaning it is retained for backward compatibility metadata purposes only and is not implemented in the database in current installations. The _IV suffix convention identifies it as an "interface view," typically used as the staging layer through which ETL processes (notably the Enterprise Data Warehouse / EDW extraction routines) consume transactional measure data before loading it into a materialized star-schema table.

The view exposes a flat, denormalized projection of custom supplier measurement records. Its column naming convention, dominated by _FK_KEY surrogate keys and a fixed set of USER_ATTRIBUTE, USER_MEASURE, and USER_FK slots, confirms it is designed for dimensional modeling rather than online transactional querying. The INSTANCE_FK_KEY referenced in the search is the foreign key linking each measure row to a specific evaluation instance, allowing the warehouse to correlate scores with a discrete assessment event.

Underlying Base Objects

According to the documented view text, the view is defined over a single base object: the table (or staging object) POA_EDW_CSTM_MSR_F. The projection is effectively a column rename and enrichment, mapping the base table's physical columns to EDW-friendly aliases and injecting a literal ' ' (single space) as OPERATION_CODE. No joins are present in the definition, and no additional referenced base objects are documented, which indicates that key resolution and dimension lookups are performed downstream by the ETL program rather than within the view itself.

Because Oracle documents this object as obsolete and not implemented in this database, DBAs on 12.1.1 or 12.2.2 should not expect to find it in a standard deployment. It survives in the ETRM (E-Business Suite Technical Reference Manual) only as a historical artifact of the Purchasing Intelligence data model. Organizations that upgraded from earlier releases may still carry a stub or synonym, but functional dependencies have generally been retired in favor of Oracle Procurement & Spendi