My Oracle Support Banner

EAP: Getting ORA-12899: value too large for column Error on Voucher Posting (Doc ID 1906693.1)

Last updated on DECEMBER 13, 2019

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Getting the following error due to field size mismatch while the voucher posting process is being run, however at data base level the fields are having same filed size.

ERROR 1
-- 13.10.00 Process 17878 ABENDED at Step AP_PSTCOMMON.CF_INH2.Step02 (Action SQL) -- RC = 12899
ROLLBACK
/
-- 13.10.00 SQL Error: ORA-12899: value too large for column "SYSADM"."PS_PST_APEA_TMP4"."VOUCHER_ID" (actual: 9, maximum: 8)

ERROR 2
-- 14.52.07 Process 18127 ABENDED at Step AP_WTHDCALC.PRE_PROC.PRE_PC3A (Action SQL) -- RC = 12899
ROLLBACK
/
-- 14.52.07 SQL Error: ORA-12899: value too large for column "SYSADM"."PS_WTHD_CALC3_TAO"."ENTITY_HDR_EFFDT" (actual: 9, maximum: 7)

STEPS
1. Run voucher post

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


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