My Oracle Support Banner

EPY: PSHUP_VALID Throwing Error at Step PSHUP_VALID.INSTMP4.Step07 (SQL) After Applying Patch 31044494 (Doc ID 2735735.1)

Last updated on DECEMBER 17, 2020

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)

 

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

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.