My Oracle Support Banner

Peoplecode Scrollselect Processing Error When Navigating To Contributor Relations Acknowledgement Suspense Page (Doc ID 2570346.1)

Last updated on JULY 26, 2019

Applies to:

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


On : Campus solutions 9 version, Contributor Relations

When attempting to review acknowledgements in suspense
the following error occurs.

 A SQL error has occurred Please consult your system logs for details

Error in PeopleCode ScrollSelect processing (2,213) DERIVED_AV.Scroll_FLUSH.RowInit PCPC:1855 Statement:33
A SQL error occurred during processing of the PeopleCode ScrollSelect (or ScrollSelectNew, RowScrollSelect , RowScrollSelectNew) built in function.
This error may have been described in a preceding message.
Examine the error messages and the PeopleCode program containing the ScrollSelect call to determine the cause of the error.

The issue can be reproduced at will with the following steps:
1. Contributor Relations > Session Management > Acknowledgments> acknowledgements suspense. AV_ACKNLDG_SPSNS
or Contributor Relations > Session Management > Acknowledgments> acknowledgement list AV_ACKNLDG_LIST

The issue has the following business impact:
Due to this issue, users cannot review any acknowledgments that need to be processed


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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