Empty Positions Cause an Error in All Manager Self Service Components Set Up By Reports to Position: "Invalid Row -1 for Class Rowset Method Get Row (2,263)" (Doc ID 1455232.1)

Last updated on JANUARY 06, 2017

Applies to:

PeopleSoft Enterprise HCM Succession Planning - Version 9.1 to 9.1 [Release 9]
PeopleSoft Enterprise HCM eProfile Manager Desktop - Version 9.1 to 9.1 [Release 9]
PeopleSoft Enterprise HCM eCompensation Manager Desktop - Version 9.1 to 9.1 [Release 9]
PeopleSoft Enterprise HCM eDevelopment - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

When a user accesses the Manager Self Service > Succession Planning > Succession 360 page and uses the + to access the Direct Reports positions the user gets the error "Invalid row -1 for Class Rowset Method get Row (2,263)"

Steps to Replicate

1.  Create 3 new positions, the first position reporting to an existing position 190000003
2.  Add 3 new employees to the database adding one of these new position to each of the new employees.
3.  Run the Set Up HRMS Common Definitions Direct Reports for Managers Direct Reports Table Build
4. Terminate the two employees in the first two positions
5. Update the Set Up HRMS Common Definitions Direct Reports for Managers Configure Direct Reports UI for the Component HR_VT_SEARCH to Reports to Position and ensure that the check box for the Indirect Reports is checked
6. Go to Manager Self Service and select any Component, e.g. Succession Planning, Employee Personal Information, View Compensation History providing they are set up with By Reports to Position
7. Click the "+" against the top position that was newly created
8.  System issues the error
Invalid row number -1 for class Rowset method GetRow. (2,263) HR_DIRECT_REPORTS.DirectReports.OnExecute  Name:AppendRowset  PCPC:87667  Statement:1245
Called from:HR_DIRECT_REPORTS.DirectReports.OnExecute  Name:FetchReportsMethod4  Statement:741
Called from:HR_DIRECT_REPORTS.DirectReports.OnExecute  Name:iDrillDown  Statement:501
Called from:HR_DIRECT_REPORTS.DirectReports.OnExecute  Name:DrillDown  Statement:166
Invalid row number -1 for class Rowset method GetRow. (2,263) HR_DIRECT_REPORTS.DirectReports.OnExecute  Name:AppendRowset  PCPC:87667  Statement:1245
Called from:HR_DIRECT_REPORTS.DirectReports.OnExecute  Name:FetchReportsMethod4  Statement:741
Called from:HR_DIRECT_REPORTS.DirectReports.OnExecute  Name:iDrillDown  Statement:501
Called from:HR_DIRECT_REPORTS.DirectReports.OnExecute  Name:DrillDown  Statement:166
Called from:HR_DIRECT_REPORTS.DirectReportsAPI.OnExecute  Name:GetAllDirectAndIndirectReports  Statement:34
Called from:HR_DIRECT_REPORTS.DirectReports

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