EAP: Getting ORA-12899: value too large for column Error on Voucher Posting
Last updated on MARCH 09, 2017
Applies to:PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.
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.
-- 13.10.00 Process 17878 ABENDED at Step AP_PSTCOMMON.CF_INH2.Step02 (Action SQL) -- RC = 12899
-- 13.10.00 SQL Error: ORA-12899: value too large for column "SYSADM"."PS_PST_APEA_TMP4"."VOUCHER_ID" (actual: 9, maximum: 8)
-- 14.52.07 Process 18127 ABENDED at Step AP_WTHDCALC.PRE_PROC.PRE_PC3A (Action SQL) -- RC = 12899
-- 14.52.07 SQL Error: ORA-12899: value too large for column "SYSADM"."PS_WTHD_CALC3_TAO"."ENTITY_HDR_EFFDT" (actual: 9, maximum: 7)
1. Run voucher post
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms