You are browsing the archive for Oracle Project Portfolio Analysis.

Oracle Project Portfolio Analysis Tables

Oracle Project Portfolio Analysis module – List of database tables:

  • FPA_OBJECTS_TL
  • FPA_SCORECARDS_TL
  • FPA_VALIDATION_LINES

Views in Project Portfolio Analysis Module

List of Views in Oracle Project Portfolio Analysis Module

FPA_AW_CALENDARS_V
FPA_AW_INV_CRITERIA_INFO_V
FPA_AW_INV_CRITERIA_V
FPA_AW_PC_DISC_FUNDS_V
FPA_AW_PC_FINANCIAL_TARGETS_V
FPA_AW_PC_INFO_V
FPA_AW_PC_INV_CRIT_SETUP_V
FPA_AW_PC_INV_CRITERIA_V
FPA_AW_PC_INV_MATRICES_V
FPA_AW_PC_PROJECTS_V
FPA_AW_PC_SCORE_INFO_V
FPA_AW_PCLASS_FIN_METRICS_V
FPA_AW_PCLASS_FUNDS_V
FPA_AW_PCLASS_INV_MIX_V
FPA_AW_PCLASS_STR_SCORES_V
FPA_AW_PCS_V
FPA_AW_PERIOD_ATTS_V
FPA_AW_PORTF_HEADERS_V
FPA_AW_PORTFS_V
FPA_AW_PROJ_CASHFLOWS_V
FPA_AW_PROJ_FIN_METRICS_V
FPA_AW_PROJ_INFO_V
FPA_AW_PROJ_INV_CRITERIA_V
FPA_AW_PROJ_INV_RANK_MAPS_V
FPA_AW_PROJ_NPVS_V
FPA_AW_PROJ_STR_SCORES_V
FPA_AW_PROJECT_SETS_V
FPA_AW_PROJS_V
FPA_AW_QUARTER_ATTS_V
FPA_AW_SCE_CASHFLOWS_V
FPA_AW_SCE_CONTEXT_V
FPA_AW_SCE_EXCS_V
FPA_AW_SCE_FIN_METRICS_V
FPA_AW_SCE_FUNDS_V
FPA_AW_SCE_INFO_V
FPA_AW_SCE_NPVS_V
FPA_AW_SCE_STR_SCORES_V
FPA_AW_SCE_SUM_CATS_V
FPA_AW_SCE_SUM_PROJS_V
FPA_AW_SCE_SUM_SCES_V
FPA_AW_SCES_V
FPA_AW_YEAR_ATTS_V
FPA_BUDGET_FORECAST_INFO_V
FPA_INV_CRITERIA_VL
FPA_LOOKUPS_V
FPA_PCS_VL
FPA_PORTFS_VL
FPA_SCES_VL

Project Portfolio Analysis Profile Options

Oracle Project Portfolio Analysis Profile Options

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
PJP_CRITERIA_RISK_CATEGORY PJP: Nominate Risk from Investment Criteria
PJP_FINANCIAL_PLAN_TYPE_BENEFIT PJP: Financial Plan Type for Project Benefit
PJP_DISCOUNT_RATE PJP: Default Discount Rate
PJP_PRODUCT_LICENSED PJP: Licensed to use Project Portfolio Analysis
PJP_PORTFOLIO_CLASS_CATEGORY PJP: Portfolio Selection Class Category
PJP_ORGANIZATION_HIERARCHY PJP: Portfolio Organization Hierarchy
PJP_FINANCIAL_PLAN_TYPE_COST PJP: Financial Plan Type for Project Cost