Data missing in outbound integration

Summary:

Data missing in outbound integration

Content (required):

Hi Experts,

We implemented GL Journals outbound integration between fusion and AWS SFTP server. We have scheduled the job for every hour, but for some specific days and timings, JV's are not picked and generated the empty file pushed to the server. But it shouldn't happen.

But when we run the query separately, we got the JV's.

Every hour frequency is based on the Journal Posted Date. We don't have any clue why the issue happened.

I am using the below code to validate every hour,

gl_je_headers.posted_date >= (select max(PROCESSSTART)