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 laterInformation 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 |