PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Job Interval time

edited Mar 20, 2023 8:39AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered

When I submit a job, there is a 1-hour interval between the request time and the start time, which is why ?

select * from ps_pmn_prcslist where (rundttm -rqstdttm) > interval '60' minute and rqstdttm > sysdate -7 order by rqstdttm desc;

ps_pmn_prcslist

rqstdttm

rundttm

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