My Oracle Support Banner

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 NOVEMBER 23, 2019

Applies to:

PeopleSoft Enterprise HCM 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

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.