SQL Error "ORA-01438: value larger than specified precision allowed for this column" When Saving Tasks After Modifying Due Dates (Doc ID 1636523.1)

Last updated on SEPTEMBER 29, 2015

Applies to:

Oracle Communications MetaSolv Solution - Version 6.0.15 and later
Information in this document applies to any platform.

Symptoms

1. Open the order PON: XYZ
2. Add a child task
3. When saving the task, application prompts user to change the due date for a task which falls on a non-working day
4. Change the date for all the tasks that the application mentions. (There are around 25+ tasks where the date has to be changed.)
5. After changing all tasks, click on save tasks again
6. Application throws following SQL error:

 

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