HCM 8.9 - 9.1 Upgrade: COMPETENCIES Data Not Loaded to JPM_JP_ITEMS (Doc ID 1335814.1)

Last updated on NOVEMBER 05, 2012

Applies to:

PeopleSoft Enterprise HRMS Human Resources - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Data from 8.9 PS_COMPETENCIES table does NOT get moved over to PS_JPM_JP_ITEMS table (with JPM_CAT_TYPE field value 'COMPETENCY'). Though PS_COMPETENCIES still exists in 9.1, it just has a single row, which was probably manually entered.

EXPECTED BEHAVIOR
-----------------------
Data from 8.9 PS_COMPETENCIES table should get moved over to PS_JPM_JP_ITEMS table (with JPM_CAT_TYPE field value 'COMPETENCY'). Post upgrade to HCM 9.1, PS_JPM_JP_ITEMS has around 12,032 total rows in HCM 9.1. PS_COMPETENCIES (19,333 rows) in HCM 8.9 should have been migrated to PS_JPM_JP_ITEMS record in HCM 9.1.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Perform the upgrade from HCM 8.9 to HCM 9.1
2. Review the data within PS_JPM_JP_ITEMS (with JPM_CAT_TYPE field value 'COMPETENCY'). No rows from PS_COMPETENCIES in HCM 8.9 was migrated.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see the COMPETENCY data in their upgraded HCM 9.1 system.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms