Fusion Performance Management: Unable To Load Position Data Using FBL (Doc ID 1947456.1)

Last updated on AUGUST 18, 2017

Applies to:

Oracle Fusion Performance Management Cloud Service - Version 11.1.7.0.0 to 11.1.11.1.0 [Release 1.0]
Oracle Fusion Performance Management - Version 11.1.7.0.0 to 11.1.11.1.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

On : 11.1.7.0.0 version, File Based Loader

When attempting to load the Position Data to the Fusion, the following error occurs.

ERROR
-----------------------
1.Unexpected exception caught: oracle.jbo.JboException, msg=JBO-27127: The effective date operation for Entity ValidGradeEO will introduce gaps or overlaps. key=oracle.jbo.Key [values]

2.The grade ID <id> already exists for this position.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Load Batch Data


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