ETL9.2: Error On Assign Work Schedule PeopleCode 'Invalid Row Number' (Doc ID 2071208.1)

Last updated on JULY 13, 2016

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to delete one of the effective dated rows in the Assign Schedule page for an employee with multiple effective dated rows they receive PeopleCode Error.

ERROR
-----------------------
Invalid row number 8 for class Rowset method GetRow. (2,2683) TL_SCHEDULES.SCH_ASSIGN.Assign.OnExecute
Name: LoadAssignmentHistory PCPC: 22963 Statement 195
Called from: SCH_ASSIGN.EFFDT.RowDelete Statement 5

A PeopleCode program has called an object method with an invalid value for the row number parameter. The row number should be within the range of existing rows in the rowset.

Use PeopleCode Debugger or a PeopleCode trace to determine the point of the error and correct the program.


The issue can be reproduced at will with the following steps:
1. find employee with numerous eff dated rows in assign schedule page.
2. 2 rows contain the exact same values but with different effective dates in sequence
3. delete the second duplicate row using correction mode

The issue has the following business impact:
Due to this issue, users cannot correct invalid schedules online.

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