Results for “total_cost”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The FPA_AW_PROJ_CASHFLOWS_V view is a reporting and integration object in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, owned by the APPS schema in the FPA - Project Portfolio Analysis module. It exposes project-level cash flow and benefit metrics that have been materialized into an Oracle OLAP analytic workspace, providing a relational, query-accessible projection of multidimensional planning data.
Rather than reading transactional tables directly, the view relies on the OLAP_TABLE operator to pivot an analytic workspace cube—identified dynamically through FPA_UTILITIES_PVT.AW_SPACE_NAME—into a conventional row-and-column result set. This design allows users running portfolio analysis (ranking scenarios, comparing funding requirements, and evaluating recommended versus current funding decisions) to consume analytical results through standard SQL, without needing direct OLAP API access. It is typically surfaced in FPA dashboards, portfolio review reports, and any custom extraction that must reconcile project scenario results into relational form.
Underlying Base Objects
The documented referenced base objects are:
- FPA_UTILITIES_PVT (PACKAGE) — Provides the
AW_SPACE_NAMEconstant used to resolve the name of the analytic workspace at runtime, ensuring the view targets the correct populated cube. - OLAP_TABLE (SYNONYM) — The synonym over the OLAP PL/SQL table function that maps workspace dimensions, attributes, and measures into columns.
- FPA_PROJ_METRICS_TBL — The OLAP_TABLE out-type (object type) referenced in the query text, shaping the returned rows.
The view defines dimensions SCENARIO (from SCENARIO_D) and PROJECT (from PROJECT_D), attributes CURRENT_FUNDING_STATUS, RECOMMENDED_FUNDING_STATUS, and CLASS_CODE, and measures FUNDS_REQUIRED, TOTAL_BENEFIT, SUNK_COST, TOTAL_COST, USER_RANK, and SCENARIO_PROJECT_VALID. All measures and attributes are resolved from workspace relations (for example SCENARIO_PROJECT_COST_M, SCENARIO_PROJECT_BENEFIT_M, PROJECT_SUNK_COST_M).
Key Columns
- PROJECT — Project identifier within the portfolio scenario being analyzed.
- CLASS_CODE — Classification code for grouping or categorizing projects.
- SCENARIO — The named portfolio planning scenario the metrics belong to.
- FUNDS_REQUIRED — Cost measure representing capital needed for the project in the scenario.
- TOTAL_BENEFIT — Projected benefit measure used in ranking and funding decisions.
- SUNK_COST — Cost already committed or expended, independent of scenario.
- TOTAL_COST — Aggregate scenario project cost measure.
- USER_RANK — User-defined priority/rank measure within the scenario.
- CURRENT_FUNDING_STATUS — Attribute indicating the funding status the project currently holds.
- RECOMMENDED_FUNDING_STATUS — Attribute indicating the status recommended by analysis.
- SCENARIO_PROJECT_VALID — Validity flag; the view filters on
SCENARIO_PROJECT_VALID = 1.
Common Use Cases and Queries
Typical scenarios include validating funding recommendations against current status, ranking projects by benefit or user rank, and extracting scenario totals for downstream reporting. A simple retrieval is:
SELECT scenario, project, class_code, user_rank, funds_required FR FROM fpa_aw_proj_cashflows_v ORDER BY scenario, user_rank;SELECT scenario, project, current_funding_status, recommended_funding_status FROM fpa_aw_proj_cashflows_v WHERE recommended_funding_status <> current_funding_status;SELECT project, SUM(funds_required), SUM(total_benefit) FROM fpa_aw_proj_cashflows_v GROUP BY project;
Because the OLAP_TABLE function depends on the analytic workspace being populated for the current session context, the view should be queried only after the FPA portfolio analysis process has refreshed the workspace.
-
APPS.FPA_AW_PROJ_CASHFLOWS_V·↳ FPA_PROJ_METRICS_TBL·↳ FPA_UTILITIES_PVT·↳ OLAP_TABLE·Explore FPA module →
-
APPS.FPA_AW_PROJ_CASHFLOWS_V·↳ FPA_UTILITIES_PVT·↳ OLAP_TABLE·Explore FPA module →
-
Euro as a Functional Currency Archive
-
View: IGW_BUDGET_PERIODS_V 12.1.1
10SC Only
APPS.IGW_BUDGET_PERIODS_V·↳ IGW_BUDGET_PERIODS·Explore IGW module →
-
APPS.FPA_AW_PROJ_FIN_METRICS_V·↳ FPA_PROJ_METRICS_TBL·↳ FPA_UTILITIES_PVT·↳ OLAP_TABLE·Explore FPA module →
-
View: FPA_AW_SCE_CASHFLOWS_V 12.2.2
APPS.FPA_AW_SCE_CASHFLOWS_V·↳ FPA_UTILITIES_PVT·↳ OLAP_TABLE·Explore FPA module →
-
APPS.IGWBV_GRNT_PRPSL_PERS_OTHR_SUP·↳ IGW_PROPOSALS_ALL·↳ IGW_PROP_PERSON_SUPPORT·Explore IGW module →
-
Euro as a Functional Currency Archive
-
View: CST_ACTIVITY_COSTS_V 12.1.1
Activity cost by cost type : SINGLE-ORG view
APPS.CST_ACTIVITY_COSTS_V·↳ CST_ACTIVITIES·↳ CST_ACTIVITY_COSTS·↳ CST_COST_TYPES·Explore BOM module →
-
View: FPA_AW_SCE_CASHFLOWS_V 12.1.1
APPS.FPA_AW_SCE_CASHFLOWS_V·↳ FPA_SCE_METRICS_TBL·↳ FPA_UTILITIES_PVT·↳ OLAP_TABLE·Explore FPA module →
-
APPS.IGWBV_GRNT_PRPSL_BUDGT_PERIOD·↳ IGW_BUDGET_PERIODS·↳ IGW_PROPOSALS_ALL·Explore IGW module →
-
Cost associated with the activity
-
Table: BIM_I_CPB_METR_MV 12.1.1
-
View: WSH_ITM_SHIPMENT_V 12.1.1
APPS.WSH_ITM_SHIPMENT_V·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL_TL·↳ HR_SECURITY·Explore WSH module →
-
- Retrofitted
APPS.CSTBV_MFG_ACTIVITY_COSTS·↳ CST_ACTIVITIES·↳ CST_ACTIVITY_COSTS·↳ CST_COST_TYPES·Explore BOM module →
-
View: IGW_BUDGET_COSTS_V 12.1.1
View displays direct cost and total cost of the budget
APPS.IGW_BUDGET_COSTS_V·↳ IGW_BUDGETS·↳ IGW_BUDGET_PERIODS·↳ IGW_PROPOSALS_ALL·Explore IGW module →
-
APPS.IGWBV_GRANT_PRPSL_BDGT_VERSION·↳ IGW_BUDGETS·↳ IGW_PROPOSALS_ALL·Explore IGW module →
-
- Retrofitted
APPS.CSTFV_MFG_ACTIVITY_COSTS·↳ CST_ACTIVITIES·↳ CST_ACTIVITY_COSTS·↳ CST_COST_TYPES·Explore BOM module →
-
View: IGW_PROPOSALS_V 12.1.1
10SC Only
APPS.IGW_PROPOSALS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_PROFILE·Explore IGW module →
-
View: PA_ONLINE_EXP_V 12.2.2
10SC Only
APPS.PA_ONLINE_EXP_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_PERSON_NAME·Explore PA module →
-
- Retrofitted
APPS.CSTBV_MFG_ACTIVITY_COSTS·↳ CST_ACTIVITIES·↳ CST_ACTIVITY_COSTS·↳ CST_COST_TYPES·Explore BOM module →
-
- Retrofitted
APPS.CSTFV_MFG_ACTIVITY_COSTS·↳ CST_ACTIVITIES·↳ CST_ACTIVITY_COSTS·↳ CST_COST_TYPES·Explore BOM module →
-
Information on budget periods for a budget version
-
View of projects costs including manufacturing costs
APPS.PA_PROJ_COST_SUBLEDGER_V·↳ GL_CODE_COMBINATIONS·↳ GL_LEDGERS·↳ PA_COST_DISTRIBUTION_LINES_ALL·Explore PA module →
-
Acquistion cost details for a purchase order or a stock receipt.
-
View: IGW_PROP_V 12.1.1
APPS.IGW_PROP_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore IGW module →
-
Table: BIM_I_MKT_CPB_MV 12.1.1
-
APPS.IGWFV_GRNT_PRPSL_PERS_OTHR_SUP·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ IGW_PROPOSALS_ALL·Explore IGW module →
-
APPS.IGWFV_GRNT_PRPSL_BUDGT_PERIOD·↳ IGW_BUDGET_PERIODS·↳ IGW_PROPOSALS_ALL·Explore IGW module →
-
APPS.FPA_AW_PROJ_FIN_METRICS_V·↳ FPA_UTILITIES_PVT·↳ OLAP_TABLE·Explore FPA module →
-
View of projects costs including manufacturing costs
APPS.PA_PROJ_COST_SUBLEDGER_V·↳ GL_CODE_COMBINATIONS·↳ GL_LEDGERS·↳ PA_COST_DISTRIBUTION_LINES_ALL·Explore PA module →
-
Acquistion cost details for a purchase order or a stock receipt.
-
APPS.IGWFV_GRANT_PRPSL_BDGT_VERSION·↳ IGW_BUDGETS·↳ IGW_PROPOSALS_ALL·↳ IGW_RATE_CLASSES·Explore IGW module →
-
View: WSH_ITM_SHIPMENT_V 12.2.2
APPS.WSH_ITM_SHIPMENT_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL_TL·Explore WSH module →
-
View: IGW_BUDGETS_V 12.1.1
10SC Only
APPS.IGW_BUDGETS_V·↳ FND_GLOBAL·↳ IGW_BUDGETS·↳ IGW_LOOKUPS_V·Explore IGW module →
-
Cost associated with the activity
-
View: CST_ACTIVITY_COSTS_V 12.2.2
Activity cost by cost type : SINGLE-ORG view
APPS.CST_ACTIVITY_COSTS_V·↳ CST_ACTIVITIES·↳ CST_ACTIVITY_COSTS·↳ CST_COST_TYPES·Explore BOM module →
-
View displays details of other sources of support that are pending or available for personnel on the proposal
APPS.IGW_PRPO_OTHER_SUPPORT_V·↳ FND_GLOBAL·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore IGW module →
-
Information about budget versions
-
View: PA_ONLINE_EXP_V 12.1.1
10SC Only
APPS.PA_ONLINE_EXP_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_PERSON_NAME·Explore PA module →
-
Project summary information for Web Inquiry.
APPS.PJM_PROJECT_PROJ_SUMMARY_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PA_BUDGET_TYPES·↳ PA_PROJECTS_ALL·Explore PJM module →
-
MSC_BIS_INV_DETAIL contains Inventory balance details collected from source applications.