You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data missing in outbound integration



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)

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!