ETL9.2 Time Admin failed with ORA-01438: value larger than specified precision allowed for this column,The SEQ Nbr length is exceeding the length after upgrade (Doc ID 1680323.1)

Last updated on SEPTEMBER 15, 2017

Applies to:

PeopleSoft Enterprise HRMS Time and Labor - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ISSUE STATEMENT
--------------------------
Time Admin failed with following error -- 18.08.49 SQL Error: ORA-01438: value larger than specified precision allowed for this column
Basically the SEQ no length is exceeding the length. after upgrade

ENVIRONMENT
-----------------------
PeopleSoft HCM 9.2
PUM 5

REPLICATION STEP
------------------------------
1) Upgrade system from 9.1 to 9.2
2) Run Time Admin
3) time Admin failed with error:
-- 18.08.49 SQL Error: ORA-01438: value larger than specified precision allowed for this column
Basically the SEQ no length is exceeding the length.

ERROR
-----------
-- 18.08.49 SQL Error: ORA-01438: value larger than specified precision allowed for this column
Basically the SEQ no length is exceeding the length.

BUSINESS IMPACT
--------------------------
Unable to run Time Admin

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