My Oracle Support Banner

PJF-2235120-Manage Rate Schedule Not Allow Inserting Row Between The Dates (Doc ID 2677241.1)

Last updated on JUNE 03, 2020

Applies to:

Oracle Fusion Project Foundation Cloud Service - Version 11.13.20.01.0 and later
Information in this document applies to any platform.

Symptoms

On Manage Rate Schedules we have accidentally entered future date 11/23/20 instead of 11/23/19 for a person. We are now unable to correct the date and getting an error -

Error
A rate with an overlapping date range already exists for this person (PJF-2235120).
Revise at least one of the date ranges to remove the overlap.

Replication Steps
1. Navigate to Project> Costs
2. Open 'Manage Rate Schedules' page
3. Search the rate schedule
4. Filter rates for person 'XYZ' -

- Manage Rate Schedules -

From Date

To Date

Rate

UOM

2017-01-01 2018-04-20 14.86 HOURS
2018-04-21 2018-10-26 15.12 HOURS
2018-10-27 2019-05-31 16.12 HOURS
2019-06-01 2019-11-22 16.43 HOURS
2020-11-23 2020-11-23 10.00 HOURS


5. Getting message below when trying to insert a row with from date as 2019-11-23 (Today's Date Is 2020-03-20) -

  A rate with an overlapping date range already exists for this person. (PJF-2235120)
  Revise at least one of the date ranges to remove the overlap.

6. Unable to delete the last row either.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
 From Date
 To Date
 Rate
 UOM
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.