SQL not fetching pending worker created in last 1 hour

Summary:

SQL not fetching pending worker created in last 1 hour

Content (please ensure you mask any confidential information):

Hi All,

There is a BIP report with bursting query written to fetch the pending workers created in last 1 hour and to sent it as a list. The report is scheduled to run every 1 hour.

But, pending workers are getting missed out in the report randomly. Doubtful if it is due to time zone issue. Any suggestions or input on this will be helpful. Thanks in advance.

The below condition is used for fetching last 1 hour data:

AND  paam.CREATION_DATE between SYSDATE - (1/ 24) AND SYSDATE