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 24.3

The following table lists the changes to data tables in PPM 24.3 as compared to PPM version 24.2.

Table

Impact

Change Details

KNTA_LICENSE_DATASOURCE

Modified in 24.3 Added the column SOURCE
KNTA_USERS Modified in 24.3 Added the column LANGUAGE
RSC_POSITIONS Modified in 24.3 Added the column SHARED_RESOURCE_FLAG

Table changes in 24.2

The following table lists the changes to data tables in PPM 24.2 as compared to PPM version 24.1.

Table

Impact

Change Details
PPM_LANDING_FAVORITE_VIEW Added in 24.2  
PPM_USER_RECENT_ACTIONS Added in 24.2  
ITG_NOTES Modified in 24.2 Added the column NOTE_HTML

KNTA_NOTE_ENTRIES

Modified in 24.2 Added the column NOTE_HTML
KCRT_REQUEST_TYPES Modified in 24.2 Added the column TABS_ENABLED_FLAG

Table changes in 24.1

The following table lists the changes to data tables in PPM 24.1 as compared to PPM version 23.4.

Table

Impact

Change Details
PPM_TAGS Added in 24.1  
PPM_API_KEYS Modified in 24.1 Added the column ENABLE_BEARER_TOKEN
DSH_DESKTOP_PAGES Modified in 24.1 Added the column PAGE_RELATIVE_URL
DSH_LANDING_PAGES Modified in 24.1

Added the column PAGE_RELATIVE_URL

Back to top

Table changes in 23.4

The following table lists the changes to data tables in PPM 23.4 as compared to PPM version 23.3.

Table

Impact

Change Details
KCRT_REQUEST_TYPE_TABS Added in 23.4  
KNTA_USERS_AVATAR Added in 23.4  
WIA_SCENARIO_SNAPSHOTS Added in 23.4  
KNTA_REFERENCES Modified in 23.4

Changed the data type of the column PARAMETER1-20 from VARCHAR2(200) to VARCHAR2(500)

Changed the data type of the column VISIBLE_PARAMETER1-20 from VARCHAR2(200) to VARCHAR2(500)

Back to top

Table changes in 23.3

The following table lists the changes to data tables in PPM 23.3 as compared to PPM version 2023.

Table

Impact

Change Details
WIA_TEMPLATES Added in 23.3  
WIA_TEMPLATE_APPLIED Added in 23.3  
WIA_SCENARIOS Added in 23.3  
KNTA_NOTIF_TXN_BOT_SCHEDULE Added in 23.3  
KRSC_STAFF_PROF_PERIOD_SUM Modified in 23.3 Added the column PLAN_TOTAL_HOUR
PFM_BUSINESS_GOALS Modified in 23.3 Added the column PARENT_ID
KNTA_NOTIF_TXN_RECIPIENTS Modified in 23.3 Added the columns SENT_FLAG, STATUS, and INFO
PGM_PROGRAM_TYPES Modified in 23.3 Added the columns PROGRAM_TYPE_EDIT_ACCESS_ID and PROGRAM_TYPE_USAGE_ID

Back to top

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  

Back to top

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  

Back to top

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

Back to top

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.

Back to top

Table changes in 10.0.1

There are no table changes in 10.0.1.

Back to top

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

Back to top

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

Back to top

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

 

Back to top

Table changes in 9.64

There are no table changes in 9.64.

Back to top

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

 

PFM_PORTFOLIO_TYPES

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

Back to top

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

Back to top

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