PS_WKF_CNT_TYP_ESP does not get populated during upgrade (Doc ID 2170577.1)

Last updated on AUGUST 09, 2016

Applies to:

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

Symptoms

Upgrade error:

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1703 Error Position: 1694 Return: 904 - ORA-00904: "CNT_PT_PCT_ESP": invalid identifier Failed SQL stmt: INSERT INTO PS_WKF_CNT_TYP_ESP (EMPLID ,CONTRACT_NUM ,EFFDT ,EFFSEQ ,CNT_ACTION_ESP ,CONTRACT_TYPE ,CNT_TEMPLATE_ID ,SETID ,CNT_TEMPLT_ID_ESP ,CNT_BGN_DT_ESP ,CNT_ORIG_BGNDT_ESP ,CNT_ END_DT_ESP ,CNT_DURATION_ESP ,CNT_DURTN_UNIT_ESP ,CNT_T_DURATION_ESP ,EXT_BGN_DT_ESP ,EXT_END_DT_ESP ,EXT_DURATION_ESP ,EXT_T_DURATION_ESP ,EXT_DURTN_UNIT_ESP ,EXT_NUMBER_ESP ,CONTRACT_ID_ESP ,BC_MANA GEMNT_ESP ,BC_SIGN_TYPE_ESP ,CNT_INEM_DT_ESP ,CTTA_CONTRACT_ESP ,CTTA_EXTENSION_ESP ,CTTA_BASICCOPY_ ESP ,CTTA_TRANSFORM_ESP ,CTTA_GROUP_ESP ,CTTA_CALLING_ESP ,XML_NODE_ID ,SERV_PRDTN_RSN_ESP ,BONIF_RS N_ESP ,BONIF_GROUP_ESP ,PRODCTN_RSN_ESP ,CNT_PROMOTION_ESP ,SUBSTN_RSN_ESP ,SUBSTN_EMPLID_ESP ,SUBST
 


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