PY_PULL_COST Process Abends with Error "ORA-12899: value too large for column "SYSADM"."PS_WRK_PROJ_TAO1"."USER_FIELD_5" (actual: 21, maximum: 20)"
(Doc ID 3057246.1)
Last updated on NOVEMBER 04, 2024
Applies to:
PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When attempting to run PY_PULL_COST process, the following error occurs:
ORA-12899: value too large for column "SYSADM"."PS_WRK_PROJ_TAO1"."USER_FIELD_5" (actual: 21, maximum: 20)
Process 6070710 ABENDED at Step TL_PUB_TM1.DILUTION.Step010 (SQL) -- RC = 12899
Process 6070710 ABENDED at Step TL_PUB_TM1.PUBLISH.Step020 (SQL) -- RC = 12899
Process 6070710 ABENDED at Step TL_PUB_TM1.PUBLISH.Step040 (SQL) -- RC = 12899
Steps to replicate the issue:
1. Navigate to Payroll Distribution > Additional Integration > Extract Time and Labor Cost.
2. Run PY_PULL_COST process.
3. It abends with above error.
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 |