Error Received when Saving Requisition after Deleting a Distribution Row. Error: INVALID ROW NUMBER 1 FOR CLASS ROWSET METHOD GETROW. (2,263) REQ_FORM.ACTIVATE (Doc ID 2031225.1)

Last updated on APRIL 24, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

A requisition is created with 1 line, 1 schedule and 2 or more distribution rows. The requisition is saved.  If the requisition is displayed, and the User deletes a distribution row and adjusts the quantities for the remaining distribution rows, the following error message is received.  

ERROR:
Invalid row number 1 for class Rowset method GetRow. (2,263) REQ_FORM.Activate PCPC:4699 Statement:56

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 the 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. Using a VAT related PO Business Unit, create a requisition that will calculate vat.
  2. Requisition should have 1 line, 1 schedule, 1 distrib row.
  3. Query REQ_LN_DIST: 1 row is returned.
  4. Query REQ_LN_DIST_VAT. 1 row is returned.
  5. Display the Requisition, drill to the distribution and split the Distrib into 2 rows.
  6. Save the Req.
  7. Query REQ_LN_DIST: 2 rows are returned.
  8. Query REQ_LN_DIST_VAT. 2 rows are returned.
  9. Display the Requisition, drill to the distribution and delete the added row, leaving 1 row for 100%.
  10. Save the Req.
  11. Query REQ_LN_DIST: 1 row is returned.
  12. Query REQ_LN_DIST_VAT. 2 rows are returned.
  13. Display the Requisition
  14. Error message is received.



The issue has the following business impact:
Due to this issue, users cannot continue with a requisition if a distrib row has been deleted.

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