ROWNUM SQL error in Task Management Work Center
(Doc ID 2456787.1)
Last updated on JULY 10, 2020
Applies to:PeopleSoft Enterprise CS Campus Community - Version 9.2 and later
Information in this document applies to any platform.
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 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
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
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