My Oracle Support Banner

ROWNUM SQL error in Task Management Work Center (Doc ID 2456787.1)

Last updated on FEBRUARY 03, 2019

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Campus Solutions 9.2 up to PUM Image 10.

When a search that would return 300+ results is performed on the Task List, View Task Activity, or View Agreements page in the Task Management Work Center,
the following error occurs.

ERROR
-----------------------
Error in PeopleCode ScrollSelect processing. (2,213) SCC_TM_TASK_MGMT.COMPONENTS.SCC_TM_TASK_LOG.OnExecute
Name:SCC_TM_AGR_WRK_SCC_TM_LINK1_FieldChange PCPC:7963 Statement:78
Called from:SCC_TM_TASK_LOG.GBL.SCC_TM_AGR_WRK.SCC_TM_LINK1.FieldChange Statement:1

"ROWNUM" is not valid in the context where it is used


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Main Menu > Campus Community > Task Management Work Center -> View Task Activity (or Task List, or View Agreements)
2. Enter search criteria that will return a large number of results


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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