Creating Many Calendars Periods Fails With Error JBO-25089 (Doc ID 1643547.1)

Last updated on NOVEMBER 05, 2016

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.7.0.0 and later
Oracle Fusion Incentive Compensation - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.7.0.0 version, Set Up Compensation Management

When attempting to add periods to Calendar in scope of Implementation Project > Manage Calendar task
the following error occurs.

ERROR
-----------------------
"JBO-25089: View object CalendarAM.CalendarEO_Periods_CalendarEOToPeriodEO attempted to fetch rows beyond the row limit"
A second attempt to create the period succeeds. We also get this error often when saving the new periods. If we close and reopen the Manage Calendars task, we also get a related error when reopening it:
"JBO-25089: View object CalendarAM.PeriodCreUpdDel attempted to fetch rows beyond the row limit"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigator > Implementation Project > Manage Calendar task > Add periods
2. Get error : "JBO-25089: View object CalendarAM.CalendarEO_Periods_CalendarEOToPeriodEO attempted to fetch rows beyond the row limit"
3. A second attempt to create the period succeeds. We also get this error often when saving the new periods. If we close and reopen the Manage Calendars task, we also get a related error when reopening it:
"JBO-25089: View object CalendarAM.PeriodCreUpdDel attempted to fetch rows beyond the row limit"


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot add new periods to calendar

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