EPY: PSHUP_VALID Throwing Error at Step PSHUP_VALID.INSTMP4.Step07 (SQL) After Applying Patch 31044494
(Doc ID 2735735.1)
Last updated on MAY 19, 2023
Applies to:
PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
PSHUP_VALID throwing an error at Step PSHUP_VALID.INSTMP4.Step07 (SQL) while testing 20-D and 20-E. The error can look different depending on your database:
File: e:\pt857p09b_1908140501-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Error converting data type varchar to numeric. (SQLSTATE 42000) 8114
Failed SQL stmt: INSERT INTO PS_PSHUP_TXN_TMP SELECT 657694 ,A.PU_SOURCE ,A.CREATION_DT ,A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE ,A.EARNS_BEGIN_DT ,A.EARNS_END_DT ,A.EMPLID ,A.EMPL_RCD ,A.SEQNO , A.PU_TXN_TYPE ,A.PU_TXN_STATUS ,A.ERNCD ,A.PLAN_TYPE ,A.DEDCD ,E.EMPL_STATUS ,D.ACTIVE_EMPL ,B.PSHUP_PROG_ID ,B.EFFDT , ' ' FROM PS_PSHUP_TXN A , PS_PY_CMP_PG_TMP B , PS_PSHUP_WRKEE_LST D , PS_JOB E WHERE B.PROCESS_INSTANCE = 657694 AND A.COMPANY=B.COMPANY AND A.PAYGROUP=B.PAYGROUP AND D.PROCESS_INSTANCE = 657694 AND A.EMPLID=D.EMPLID AND A.EMPL_RCD=D.EMPL_RCD AND A.COMPANY = D.COMPANY AND A.PAYGROUP = D.PAYGROUP AND A.PU_TXN_STATUS NOT IN ('I','M','E') AND E.EMPLID=A.EMPLID AND E.EMPL_RCD=A.EMPL_RCD AND E.EFFDT = ( SELECT MAX(J1.EFFDT) FROM PS_JOB J1 WHERE J1.EMPLID = E.EMPLID AND J1.EMPL_RCD = E.EMPL_RCD AND J1.EFFDT <= B.PAY_END_DT) AND E.EFFSEQ = ( SELECT MAX(J2.EFFSEQ) FROM PS_JOB J2 WHERE J2.EMPLID = E.EMPLID AND J2.EMPL_RCD = E.EMPL_RCD AND J2.EFFDT = E.EFFDT) AND A.PU_SOURCE='OT'
Process 657694 ABENDED at Step PSHUP_VALID.INSTMP4.Step07 (SQL) -- RC = 8601 (108,524)
Failed SQL stmt: INSERT INTO PS_PSHUP_TXN_TMP SELECT 657694 ,A.PU_SOURCE ,A.CREATION_DT ,A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE ,A.EARNS_BEGIN_DT ,A.EARNS_END_DT ,A.EMPLID ,A.EMPL_RCD ,A.SEQNO , A.PU_TXN_TYPE ,A.PU_TXN_STATUS ,A.ERNCD ,A.PLAN_TYPE ,A.DEDCD ,E.EMPL_STATUS ,D.ACTIVE_EMPL ,B.PSHUP_PROG_ID ,B.EFFDT , ' ' FROM PS_PSHUP_TXN A , PS_PY_CMP_PG_TMP B , PS_PSHUP_WRKEE_LST D , PS_JOB E WHERE B.PROCESS_INSTANCE = 657694 AND A.COMPANY=B.COMPANY AND A.PAYGROUP=B.PAYGROUP AND D.PROCESS_INSTANCE = 657694 AND A.EMPLID=D.EMPLID AND A.EMPL_RCD=D.EMPL_RCD AND A.COMPANY = D.COMPANY AND A.PAYGROUP = D.PAYGROUP AND A.PU_TXN_STATUS NOT IN ('I','M','E') AND E.EMPLID=A.EMPLID AND E.EMPL_RCD=A.EMPL_RCD AND E.EFFDT = ( SELECT MAX(J1.EFFDT) FROM PS_JOB J1 WHERE J1.EMPLID = E.EMPLID AND J1.EMPL_RCD = E.EMPL_RCD AND J1.EFFDT <= B.PAY_END_DT) AND E.EFFSEQ = ( SELECT MAX(J2.EFFSEQ) FROM PS_JOB J2 WHERE J2.EMPLID = E.EMPLID AND J2.EMPL_RCD = E.EMPL_RCD AND J2.EFFDT = E.EFFDT) AND A.PU_SOURCE='OT'
Process 657694 ABENDED at Step PSHUP_VALID.INSTMP4.Step07 (SQL) -- RC = 8601 (108,524)
-- Row(s) affected: 0
-- 15:35:24.819 Process 298978 ABENDED at Step PSHUP_VALID.INSTMP4.Step07 (Action SQL) -- RC = 12899
ROLLBACK
/
-- 15:35:24.827 SQL Error: ORA-12899: value too large for column "SYSADM"."PS_PSHUP_TXN_TMP"."PU_SOURCE" (actual: 6, maximum: 2)
-- 15:35:24.819 Process 298978 ABENDED at Step PSHUP_VALID.INSTMP4.Step07 (Action SQL) -- RC = 12899
ROLLBACK
/
-- 15:35:24.827 SQL Error: ORA-12899: value too large for column "SYSADM"."PS_PSHUP_TXN_TMP"."PU_SOURCE" (actual: 6, maximum: 2)
Changes
Issue seen after applying changes from Patch 31044494.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |