Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Data missing in outbound integration — Cloud Customer Connect
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

Question
11
Views
0
Comments

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)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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