EAP: Getting ORA-12899: value too large for column Error on Voucher Build

(Doc ID 1954066.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

Issue occured on Oracle 12c database version 12.1.0.1.

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

ERROR
ORA-12899: value too large for column "SYSADM"."PS_EXS_TXCLA_TAO1"."VOUCHER_ID" (actual 9, maximum: 8) FAILED SQL stmt: INSERT INTO PS_EXS_TXCLA_TAO1

Process ABENDED at Step APVEDTPREX.PREX.Step03 (SQL)

STEPS
1. Run voucher build

Cause

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