PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

I created a query on a new audit table I created. When I run the query I get this error, 'Query Resu

edited Feb 24, 2020 9:39AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 10 commentsAnswered ✓

I'm not sure if this is the correct space for this question.

I created a query on a new audit table I created. When I run the query, I get this error, 'Query Result Set too Large. (50,546)  Result of 'SQL Fetch' is over the maximum result size specified for the application server. Modify your query or increase the maximum result size.' I use the emplid as the prompt, and it should only return two rows, but it is duplicating the two rows; thus, I get the error. What am I doing wrong? Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center