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 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)

KCRT_FG_MASTER_PROJ_REF_INT

 

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

Back to top

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

Back to top

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  

Back to top

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

Back to top

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".

Back to top

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"

Back to top

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

Back to top

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  

Back to top