Getting Error (2,156) When Trying to Add Items - Using Copy Requisition, Delete a Line and Save (Doc ID 2098015.1)

Last updated on APRIL 02, 2024

Applies to:

Symptoms

Getting an error message when trying to add items - using copy requisition, delete a line and save

Steps to Reproduce the Issue:
1) The user is going into eprocurement > Manage Requisitions -
2) selecting a requisition to copy - deletes and line - saves for later -
3) adds additional lines from the catalog and when they add to cart gets the

Error message:

FetchValue: Row 0 not found in scroll level 1. (2,156) REQ_LINE.LINE_NBR.RowInsert Name:update_nav PCPC:2399 Statement:65
Called from:REQ_LINE.LINE_NBR.RowInsert Statement:84
The specified row number is invalid for the indicated scroll level. This may occur with various PeopleCode built-in functions that specify a row within a scroll.
Review the PeopleCode that is generating the message and the page definition and correct as appropriate.

Clicking OK, returns the following message:
4)SetID not found for name='SETID', value='' with record 'LOCATION_TBL', tree ' '. (2,214) PV_REQ_WRK.PV_RETURN_PANEL.FieldChange Name:DisplayAddress PCPC:2951 Statement:35
Called from:REQ_DFLT_TBL.BUSINESS_UNIT.FieldChange Name:chng_sched_addr Statement:236
Called from:ITM_CAT_WRK.ORDER_BUTTON.FieldChange Name:Insert_Req Statement:501
Called from:ITM_CAT_WRK.ORDER_BUTTON.FieldChange Name:place_order Statement:892
Called from:PV_REQ_ITM_WRK.PV_REQ_ITM_ADD.FieldChange Name:Add_Item Statement:777
Called from:PV_ADDITEMS_WRK.ADD_ITEMS.FieldChange Statement:162

The PeopleCode built-in function GetSetID has been called with parameters that were
not found in the table set definitions.

Review the table set control tables and the PeopleCode and correct whichever is wrong.

Cause

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