Share this page
Tables
This section describes the major changes to the data model since 9.50 as compared to their respective previous versions. Some tables have been deleted, some new tables have been introduced, some existing tables have been modified, some tables have been deprecated and are unused, and other tables have been replaced by views.
Table changes in 2023
The following table lists the changes to data tables in PPM 2023 as compared to PPM version 10.0.4.
|
Table |
Impact |
Change Details |
|---|---|---|
| PPM_WEB_HOOKS | Added in 2023 | |
| PPM_INT_AGILE_PORTFOLIO_MAP | Added in 2023 |
Table changes in 10.0.4
The following table lists the changes to data tables in PPM 10.0.4 as compared to PPM version 10.0.3.
|
Table |
Impact |
Change Details |
|---|---|---|
| PPM_INT_AGILE_PORTFOLIO_AUDIT | Added in 10.0.4 |
Table changes in 10.0.3
The following table lists the changes to data tables in PPM 10.0.3 as compared to PPM version 10.0.2.
|
Table |
Impact |
Change Details |
|---|---|---|
| PPM_SAML_METADATA_CONFIG | Added in 10.0.3 | |
| RSC_POSITIONS | Modified in 10.0.3 | Added the column REGION_ID. |
| DSH_PORTLETS | Modified in 10.0.3 | Added the column LAYOUT |
Table changes in 10.0.2
The following table lists the changes to data tables in PPM 10.0.2 as compared to PPM version 10.0.1.
|
Table |
Impact |
Change Details |
|---|---|---|
| KCRT_REQUEST_TYPE_SECURITY | Modified in 10.0.2 | Added the column CAN_SEARCH_CODE. |
| PFM_STRATEGIC_THEMES | Modified in 10.0.2 |
Added the column PORTFOLIO_TYPE_ID. Added the foreign key PORTFOLIO_TYPE_ID. |
| PFM_BUSINESS_GOALS | Modified in 10.0.2 | Added the column PORTFOLIO_TYPE_ID. |
Table changes in 10.0.1
There are no table changes in 10.0.1.
Table changes in 10.0
The following table lists the changes to data tables in PPM 10.0 as compared to PPM version 9.66.
|
Table |
Impact |
Change Details |
|---|---|---|
| PPMIC_WORKPLAN_MAPPING | Modified in 10.0 |
Changed the type of the column CONFIGURATION_DISPLAY_JSON from VARCHAR2 (4000) to CLOB (4000). Changed the type of the column CONFIGURATION_JSON from VARCHAR2 (4000) to CLOB (4000). |
| KNTA_USER_SESSIONS | Modified in 10.0 | Changed the type of the column BROWSER from VARCHAR2(80) to VARCHAR2(256). |
Table changes in 9.66
The following table lists the changes to data tables in PPM 9.66 as compared to PPM version 9.65.
|
Table |
Impact |
Change Details |
|---|---|---|
| PPM_ODATA_LINKS | Added in 9.66 | |
| PPM_API_KEYS | Added in 9.66 | |
| DSH_PORTLET_PREFERENCES | Modified in 9.66 |
Added the column DRILL_TO_PORTLET_ID |
| KNTA_COMMANDS | Modified in 9.66 | Added the column EVENT_CODE |
| PM_PROJECTS | Modified in 9.66 | Added the column PROGRESS |
Table changes in 9.65
The following table lists the changes to data tables in PPM 9.65 as compared to PPM version 9.64.
|
Table |
Impact |
Change Details |
|---|---|---|
| PPM_ODATA_DATA_SOURCES | Added in 9.65 |
|
Table changes in 9.64
There are no table changes in 9.64.
Table changes in 9.63
The following table lists the changes to data tables in PPM 9.63 as compared to PPM version 9.62.
|
Table |
Impact |
Change Details |
|---|---|---|
| PFM_CUSTOM_ICON | Added in 9.63 |
|
| Added in 9.63 | ||
| KNTA_USER_UPLOADED_FILES | Added in 9.63 | |
| PFM_PORTFOLIOS | Modified in 9.63 |
Added the foreign keys PF_SETTINGS_ID and PORTFOLIO_TYPE_ID. Added the columns PORTFOLIO_TYPE_ID and PF_SETTINGS_ID Added the indexes PFM_PORTFOLIOS_N3 and PFM_PORTFOLIOS_N4 |
| KCRT_REQUEST_TYPES | Modified in 9.63 | Added the columns DASHBOARD_ENABLED_FLAG and ENABLED_COPY_REQUEST_FLAG |
| KNTA_PARAM_SET_FIELDS | Modified in 9.63 | Added the column REVERSE_PARAMETER_SET_FIELD_ID |
Table changes in 9.62
The following table lists the changes to data tables in PPM 9.62 as compared to PPM version 9.61.
|
Table |
Impact |
Change Details |
|---|---|---|
| PPM_SYNC_OPERATION_DETAILS | Modified in 9.62 |
Changed the type of the column SERVER from VARCHAR2 (30) to VARCHAR2 (200) |
|
|
Modified in 9.62 |
Changed the type of the column REF_MASTER_PROJECT_NAME from VARCHAR2(80) to VARCHAR2(1200) |
| KNTA_NOTIFICATIONS | Modified in 9.62 | Added the column ENABLE_CHATBOT_APPROVALS |
Table changes in 9.61
The following table lists the changes to data tables in PPM 9.61 as compared to PPM version 9.60.
|
Table |
Impact |
Change Details |
|---|---|---|
| DSH_BUILDER_DEF_PREFS | Added in 9.61 | |
| KNTA_PARAM_SET_FIELDS | Modified in 9.61 | Added the column ADVANCED_DEF_PROPERTY |
| KPFM_CONFIGURATIONS | Modified in 9.61 | Added the column ENABLE_OVERVIEW_FLAG |
| PFM_STRATEGIC_THEMES | Modified in 9.61 | Added the columns STRATEGIC_THEME_TYPE and PARENT_ID |
| WP_WORK_UNITS | Modified in 9.61 | Added the column RESOURCE_FROM_POSITION |
Table changes in 9.60
The following table lists the changes to data tables in PPM 9.60 as compared to PPM version 9.55.
|
Table |
Impact |
Change Details |
|---|---|---|
| PPM_SYNC_OPERATIONS | Added in 9.60 | |
| PPM_SYNC_OPERATION_DETAILS | Added in 9.60 | |
| ITG_UI_VIEW_SETTINGS | Added in 9.60 | |
| PPM_CHAT_ACTIONS | Added in 9.60 | |
| PPM_CHAT_ACTION_CONTENTS | Added in 9.60 | |
| PPM_CHAT_ACTION_ENTITIES | Added in 9.60 | |
| PPM_CHAT_INTENTS_NLS | Added in 9.60 | |
| PPM_CHAT_INTENT_ITEMS | Added in 9.60 | |
| PPM_USAGE_MONITORING_SETTINGS | Added in 9.60 | |
| PPM_USAGE_MONITORING | Added in 9.60 | |
| DSH_DESKTOP_PAGES | Added in 9.60 | |
| PPM_FEATURE_TOGGLES | Modified in 9.60 | Added the column TAGS |
| DSH_HTML_PLUS_PORTLET_DEFS | Modified in 9.60 | Added the column EXTRA_DATASOURCES |
| DSH_LANDING_PAGES | Modified in 9.60 |
Removed the column CUSTOMER_ID Added the columns RULE_SCOPE, PRIORITY, and RULE_CRITERIA. |
| KNTA_USER_PROFILES | Modified in 9.60 | Added the column PREVENT_USAGE_MONITORING |
| TM_PENDING_APPROVAL | Modified in 9.60 | Added the index TM_PENDING_APPROVAL_N2 |
Table changes in 9.55
The following table lists the changes to data tables in PPM 9.55 as compared to PPM version 9.54.
|
Table |
Impact |
Change Details |
|---|---|---|
| KWFL_WORKFLOW_STEPS | Modified in 9.55 | Added the column USE_IN_MOBILE_FLAG |
| KWFL_WORKFLOWS | Modified in 9.55 | Added the column USE_IN_MOBILE_FLAG |
| KDSH_DATA_SOURCES | Modified in 9.54 | Changed the type of the column USE_REPORTING_DB from CHAR to VARCHAR2(1) |
| DSH_HTML_PLUS_PORTLET_DEFS | Added in 9.55 | |
| PPM_SERVICE_MESSAGE_RECORDS | Added in 9.55 | |
| DSH_MOBILITY_PAGES | Added in 9.55 | |
| DSH_CUSTOMIZED_CHART_DEFS | Deleted in 9.55 |
Table changes in 9.54
The following table lists the changes to data tables in PPM 9.54 as compared to PPM version 9.53.
|
Table |
Impact |
Change Details |
|---|---|---|
| PPM_HOTFIX_LIST | Added in 9.54 | |
| HOTFIX_ACTION_AUDIT | Added in 9.54 | |
| PPM_HOTFIX_FILE_LIST | Added in 9.54 | |
| PPM_FEATURE_TOGGLES | Modified in 9.54 | The column "VALUE" is replaced with the column "DEFAULT_VALUE". |
| PPM_FEATURE_TOGGLE_VALUES | Added in 9.54 | |
| KDSH_DATA_SOURCES | Modified in 9.54 | Added the column USE_REPORTING_DB |
Table changes in 9.53
The following table lists the changes to data tables in PPM 9.53 as compared to PPM version 9.52.
|
Table |
Impact |
Change Details |
|---|---|---|
| PPM_FEATURE_TOGGLES | Added in 9.53 | |
| PPM_FT_STATUS_HISTORY | Added in 9.53 | |
| PPM_FT_VALUE_AUDIT | Added in 9.53 | |
| RSC_SP_PERIOD_COST | Added in 9.53 | |
| TEAM_TEAMS | Modified in 9.53 | Added the columns "TEAM_TYPE" and "TEAM_ROLE". |
| FM_COST_RATE_RULE_UPDATES | Modified in 9.53 | Added the column "TEAM_ID". |
Table changes in 9.52
The following table lists the changes to data tables in PPM 9.52 as compared to PPM version 9.51.
|
Table |
Impact |
Change Details |
|---|---|---|
| TEAM_TEAMS | Added in 9.52 | |
| RSC_TEAM_ASSIGNMENTS | Added in 9.52 | |
| TEAM_FAVORITES_USERS | Added in 9.52 | |
| WP_TASKS | Modified in 9.52 | Added the column "External_uid" |
Table changes in 9.51
The following table lists the changes to data tables in PPM 9.51 as compared to PPM version 9.50.
|
Table |
Impact |
Change Details |
|---|---|---|
| DSH_CUSTOMIZED_CHART_DEFS | Added in 9.51 | |
| KCRT_FG_PFM_PROPOSAL | Modified in 9.51 | Added the columns KCRT_FG_PFM_PROPOSAL_N1 and KCRT_FG_PFM_PROPOSAL_U3 |
| KNTA_USERS | Modified in 9.51 | Added the index KNTA_USERS_U4 |
| PFM_KPI_IMPACTS | Modified in 9.51 | Added the columns KI_ASSUMPTIONS and KI_STATUS |
| PM_PROJECTS | Modified in 9.51 | Added the index PPM_PROJ_SEARCH_IDX |
Table changes in 9.50
The following table lists the changes to data tables in PPM 9.50 as compared to PPM version 9.42.
|
Table |
Impact |
Change Details |
|---|---|---|
| PFM_KPI_IMPACTS | Added in 9.50 | |
| PFM_STRATEGIC_THEMES | Added in 9.50 | |
| PFM_STRAT_THEMES_INITIATIVES | Added in 9.50 | |
| PPM_INT_AGILE_ENTITY_MAP | Added in 9.50 | |
| PPM_INT_AGILE_CONTROL | Added in 9.50 | |
| KCRT_FG_AGILE_INFO | Added in 9.50 | |
| PFM_PORTFOLIO_MILESTONE | Added in 9.50 | |
| PFM_MILESTONE_OWNERS | Added in 9.50 | |
| PVO_SCENARIO_TEMPLATES | Added in 9.50 | |
| PVO_SCENARIOS | Added in 9.50 | |
| PVO_SCENARIO_DETAILS | Added in 9.50 | |
| PVO_USERS | Added in 9.50 | |
| PVO_SETTINGS_ATTRIBUTES | Added in 9.50 | |
| PFM_PORTFOLIOS | Modified in 9.50 | Added the column STRATEGIC_THEME_TYPE |
| PFM_KPIS | Modified in 9.50 | Added the column BG_ID |
| PPM_INT_EVENTS | Modified in 9.50 | Added the column MAPPING_KEY |
| PPM_INT_CONFIGURATIONS | Modified in 9.50 | Added the column FIELDS_MAPPING_CONFIGURATION |
| PFM_SCENARIOS | Deleted in 9.50 | |
| PFM_SCENARIO_BUDGETS | Deleted in 9.50 | |
| PFM_SCENARIOS_CONTENTS | Deleted in 9.50 | |
| PFM_SCENARIO_RESOURCE_POOLS | Deleted in 9.50 |
