Error While Update Service Request DFF In Dispatch Center Form - ORA-01438: Value larger than specified precision allowed for this column in package CS_ServiceRequest_PVT Procedure Update_ServiceRequest (Doc ID 2130922.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Field Service - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Error While Update Service Request DFF in Dispatch Center Form

ERROR
ORA-01438: Value larger than specified precision allowed for this column in package CS_ServiceRequest_PVT Procedure Update_ServiceRequest

STEPS
1) Login to Oracle Apps
R) System Administrator -> DFF -> Segments -> Application: Service
Title: Additional Information for Agents
Global -> Segments
CCC - 3 Characters
Save. Compile.

R) Field Service Manager -> Dispatch Center -> Query for a Task and in the Service Request tab, Enter the DFF value and try to save the details. The above mentioned error is displayed.

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