PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Query Manager - long running queries

edited Sep 26, 2017 5:02AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered

My business partners have created a query via Query Manager.  Unfortunately it runs about 6 minutes which causes their session of PeopleSoft to crash.  Our DBA has looked at the query and re-written it via SQL Server.  This  executes directly against the database in a few seconds.  Is there an easy way to get query manager query to use the DBA's SQL statement? 

This is the Query Manager SQL:

SELECT A.OPEN_ITEM_KEY, A.OPEN_ITEM_STATUS, (CONVERT(CHAR(10),A.OPEN_DT,121)), (CONVERT(CHAR(10),A.CLOSED_DT,121)), (CONVERT(CHAR(10),A.JOURNAL_DATE,121)), A.JOURNAL_ID, A.JOURNAL_LINE, A.UNPOST_SEQ

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