Search Results non_contract_amount




Overview
Explore in AI Chat

Overview

APPS.POA_BIS_SAVINGS_RPT_V is a reporting view in the Oracle E-Business Suite Procurement and Oracle Advanced Procurement (Purchasing) module family. The suffix _V and the naming convention indicate it is a product-owned, ready-for-use reporting object intended to expose procurement savings and spend aggregation data to business intelligence consumers, concurrent programs, and downstream reporting tools. Its primary purpose is to present pre-joined, pre-aggregated savings figures — purchased amounts, contract amounts, non-contract amounts, and potential savings — organized by a grouping key and enriched with descriptive dimensions such as buyer, supplier, item, category, and accounting context.

The view is relevant to the Procurement analytics subject area, where organizations measure the effectiveness of strategic sourcing and contract compliance. The NON_CONTRACT_AMOUNT column in particular supports the analysis of spend that occurred outside negotiated agreements, which is a common metric for maverick-spend reduction programs.

Underlying Base Objects

According to the documented view text, APPS.POA_BIS_SAVINGS_RPT_V is defined as a direct column projection over a single base object: the table POA_BIS_SAVINGS_RPT. The view performs no joins, filtering, aggregation, or expression logic of its own; it simply selects every listed column from that table and exposes it under the _V name. No other referenced base objects are documented.

Functionally, the view acts as a stable access layer over the underlying savings reporting table. This is a common EBS pattern: the table holds staged or materialized reporting data, and the view provides a supported read interface so that consumers are insulated from physical storage changes. Because the view is a pure passthrough, its row count, cardinality, and data freshness are entirely governed by the population of POA_BIS_SAVINGS_RPT.

Key Columns

Common Use Cases and Queries

Typical uses include maverick-spend analysis, contract-leverage reporting, savings opportunity identification, and buyer or supplier spend dashboards. The audit columns allow traceability to the concurrent program that populated the report. Sample queries:

  • Return all columns: SELECT * FROM APPS.POA_BIS_SAVINGS_RPT_V;
  • Filter to non-contract spend: SELECT GROUPNO, PURCHASE_AMOUNT, CONTRACT_AMOUNT, NON_CONTRACT_AMOUNT FROM APPS.POA_BIS_SAVINGS_RPT_V WHERE NON_CONTRACT_AMOUNT > 0;
  • Sum by document type: SELECT DOCUMENT_TYPE_CODE, SUM(PURCHASE_AMOUNT) FROM APPS.POA_BIS_SAVINGS_RPT_V GROUP BY DOCUMENT_TYPE_CODE;