Oracle Project Portfolio Analysis Tables
Oracle Project Portfolio Analysis module – List of database tables:
- FPA_OBJECTS_TL
- FPA_SCORECARDS_TL
- FPA_VALIDATION_LINES
Oracle Project Portfolio Analysis module – List of database tables:
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 |
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 |