EPY 9.2 USA PAYROLL INSIGHTS – Update Pay Frequency For Index HC_HPY_MGMT_CHK_US
(Doc ID 2989887.1)
Last updated on FEBRUARY 05, 2024
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
HC_HPY_MGMT_CHK_US definition runs to error 'value too large for column "SPSOFT"."PS_PY_KB_US_CHK"."PY_PAY_FREQ"'
ERROR
-----------------------
PeopleTools 8.59.07 - Application Engine Copyright (c) 1988-2023 Oracle and/or its affiliates. All Rights Reserved Starting program PTSF_GENFEED (35,36)
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1811 Error Position: 50 Return: 12899 - ORA-12899: value too large for column "SPSOFT"."PS_PY_KB_US_CHK"."PY_PAY_FREQ" (actual: 4, maximum: 1) Failed SQL stmt: UPDATE PS_PY_KB_US_CHK SET PY_PAY_FREQ = ( SELECT B.PAY_FREQUENCY FROM PS_PAYGROUP_TBL B WHERE B.COMPANY = PS_PY_KB_US_CHK.COMPANY AND B.PAYGROUP = PS_PY_KB_US_CHK.PAYGROUP AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_PAYGROUP_TBL B2 WHERE B2.COMPANY = B.COMPANY AND B2.PAYGROUP = B.PAYGROUP AND B2.EFFDT <= TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD'))) WHERE EXISTS ( SELECT 'X' FROM PS_PAYGROUP_TBL B WHERE B.COMPANY = PS_PY_KB_US_CHK.COMPANY AND B.PAYGROUP = PS_PY_KB_US_CHK.PAYGROUP AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_PAYGROUP_TBL B2 WHERE B2.COMPANY = B.COMPANY AND B2.PAYGROUP = B.PAYGROUP AND B2.EFFDT <= TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD'))) Process 3103788 ABENDED at Step PY_KB_US_CHK.UPDATE.Step08 (SQL) -- RC = 12899 (108,524) Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
Steps to replicate:
1.Run search index
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 |
| Cause |
| Solution |
| References |