E-FLO: Getting MSS or DB2 Error Like "Arithmetic overflow error for data type smallint ..." on Adding LOCATION_TBL Record into a File Layout
(Doc ID 617667.1)
Last updated on DECEMBER 05, 2016
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.1 and later
Information in this document applies to any platform.
This document was previously published as Customer Connection Solution 200736810
***Last revised on 11-Apr-2013***
Cannot save a File Layout after having created a new FileLayout and dragged the LOCATION_TBL or JOBCODE_TBL record into it. When trying to save, get an error like this
INSERT INTO PSFLDSEGDEFN (FLDDEFNNAME, FLDSEGNAME, FLDSEGID, FLDSEGPARENT, FLDSEGIDSTART, FLDSEGIDLENGTH, FLDMAXSEGLEN, FLDIDSEQNO, FLDOFFSET, FLDTAG, FLDSEQNO, FLDQUALIFIER, FLDDELIMITERTYPE, FLDDELIMITER, RECNAME_FILE, SQLID, SQLTYPE, FLDSEGCOUNT, FLDFIELDCOUNT, DESCR100) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19, :20)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!