Upgrade Data conversion errors from HR9.0 to HR9.1 FP1 Dec2010 app only upgrade.
edited Apr 20, 2012 11:12AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered
We are getting following 3 data conversion errors . Applied Upgrade bundles up 12.
1)We are getting following error in the data converstion. PS_HCM_EO_TXN table does not have HR_PTCS_SERVICEID column.I checked in demo 9.1 these column is not there
UPG_SC90.HCSCM30.Step01 (SQL)
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1617 Error Position: 59 Return: 904 - ORA-00904: "HR_PTCS_SERVICEID":
invalid identifier
Failed SQL stmt:INSERT INTO PS_HCM_EO_TXN (TRANSACTION_NAME , EOAWPRCS_ID ,HR_PTCS_SERVICEID , DELEGATION_INIT , DELEGATION_APPR) SELECT
TRANSACTION_NAME , E
OAWPRCS_ID ,' ' , DELEGATION_INIT , DELEGATION_APPR FROM PS_EO_TRANSACTIONS
0