ePro Requisition Using Mass Change Not Updating Distribution Lines When Multiple Distribution Lines Per Schedule, Getting "FetchValue: Row 0 not found in scroll level 3. (2,156)" (Doc ID 2922414.1)

Last updated on FEBRUARY 14, 2023

Applies to:

Symptoms

Getting error on online page when trying to add multiple distribution lines to same ePro requisition line schedule using Mass Change.

Issue is reproducible with newly-created requisitions after update to 9.2 PUM 45.

When adding multiple distribution accounting lines to each line of an ePro requisition with 2 or more requisition lines, getting below error and split distribution using Mass Change feature not applied correctly.

Steps:
1.Requester Setup for VP1, contains default values for Account, Dept, Oper Unit, and Fund Code (Navigation: Set Up Financials/Supply Chain > Product Related > Procurement Options > Requester Setup)
2.After enter a requisition with 2 lines, select both Line 1 and Line 2 and click on Mass Change (Navigation: eProcurement tile > Create Requisition)
3.Next click on “Load Values from Defaults” to load in default chartfield string from Requester setup for VP1
4.See ‘blank’ Percent in Accounting Lines after click on “Load Values from Defaults”
5.Next click on + sign to add a 2nd distrib line
6.In 2nd distrib line, enter Location and GL Unit in Chartfields1 tab. Then click on Chartfields2 tab.
7.In Chartfields2 tab, select in Oper Unit, Fund, Dept on Distrib Line 2 - then click back on Chartfields1 tab
8.Select in Account on Distrib Line 2
9.Then manually enter the percentages for each distrib line and click OK
10.Choose Replace button and click OK
11.Get the below peoplecode error on the Checkout page, click OK

"FetchValue: Row 0 not found in scroll level 3. (2,156)
PV_REQ_APLY_DEF.BUSINESS_UNIT.FieldChange Name:apply_distrib_dflts
PCPC:43863 Statement:762
Called from:PV_REQ_APLY_DEF.BUSINESS_UNIT.FieldChange Name:chng_distrib
Statement:834
Called from:PV_REQ_APLY_DEF.BUSINESS_UNIT.FieldChange
Name:apply_changes_to_all Statement:878
Called from:REQ_HDR_WRK.DEFAULTS_PB.FieldChange Name:retrofit_default_value
Statement:476
Called from:PV_HIDDEN_LINKS.PV_MULTI_DISTRIB.FieldChange Name:MassChange
Statement:162
Called from:PV_HIDDEN_LINKS.PV_MULTI_DISTRIB.Fi

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."

12.Return to Requisition Summary page. Expand Line 1 then expand Accounting Lines for Line 1. In each distrib line in Chartfields1 tab see that quantity, percent and amount fields are not populated correctly
13.And in Chartfields2 tab see that Account, Oper Unit, Fund and Dept in distrib line 2 have not been correctly updated due to above peoplecode error received
14.Also expand Line 2 then expand Accounting Lines for Line 2. In each distrib line in Chartfields1 tab see that quantity, percent and amount fields are not populated correctly
15.And in Chartfields2 tab see that Account, Oper Unit, Fund and Dept in distrib line 2 have not been correctly updated due to above peoplecode error received

RESULT: the split distribution is not applied correctly in Support environment (PT8.59.11/PUM45) using Mass Change feature.

Cause

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