Get Error AV_PROSPECT.INSTITUTION Not Found In Scroll Level 0. (2,155) and Error in PeopleCode ScrollSelect processing. (2,213) (Doc ID 1517271.1)

Last updated on MARCH 06, 2017

Applies to:

PeopleSoft Enterprise CS Contributor Relations - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to view the details on the Person Profile page, Prospect Profile tab (Contributor Relations > Constituent Information > People > Person Profile) when you click on the "Action Description" under the "Recent Actions" Scroll

or

when Navigating to Contributor Relations > Prospect Management > Stewardship Plans > Prospect Strategy > Strategy - Person and pull up a record (e.g. AV0020 in Demo) and go to the “Linked Actions” tab and click on the details of a scheduled action.

or

Navigate to Strategy Summary - Person and pull up a record (e.g. AV0020 in Demo).  Click on Details link.  On the Prospect Strategy Detail page, click on the Details link.

the following error occurs.

ERROR
________
Message 1
GetField: Field 'AV_PROSPECT.INSTITUTION' not found in scroll level 0. (2,155) AV_PRSN_BIO_DEMO.GBL. PCPC:39 Statement:1

or

GetField: Field 'AV_PROSPECT.INSTITUTION' not found in scroll level 0. (2,155) AV_PRSP_STRATEGY.GBL.DERIVED_AV.RowInit  PCPC:39  Statement:1
followed by

Error in PeopleCode ScrollSelect processing. (2,213) AV_ACTN_DTL_SP.Activate PCPC:859 Statement:10

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Navigate to Main Menu, Contributor Relations, Constituent Information, People, Person Profile (or the alternate navigation above)
2) Select the Prospect Profile tab (component = AV_PRSN_BIO_DEMO; page = AV_PROSPROF_P)
3) Select an "Action Description" under the "Recent Actions" Scroll
4) The error messages display

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot view the details on this page.

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