Oracle Fusion FBL: Person Profile Performance Rating Config and Load Causes Error: JBO-27010 - Attribute set with value has invalid precision/scale.

(Doc ID 1917536.1)

Last updated on MARCH 10, 2016

Applies to:

Oracle Fusion Performance Management Cloud Service - Version 11.1.8.0.0 and later
Oracle Fusion Performance Management - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to load Performance Ratings in Person Profile, the following error occurs.

ERROR
-----------------------
oracle.jbo.PrecisionScaleValidationException: JBO-27010: Attribute set with value 3.7 for ItemDecimal1 in ProfileServiceAM.ProfileVO_ProfileItem_ProfileVOToProfileItemVO_ProfileItemVO has invalid precision/scale at

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Put the data files into UCM.
2. Go to Data Exchange.
3. Run the Load Batch Data process and review the logs.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot load data into Fusion for Performance ratings.

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