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

Issue with HCM Extract – Effective Date Not Picking Sysdate on Scheduled Runs

Summary:

Hi Forum,

We have a requirement to generate an HCM extract (changes-only file) scheduled on the 15th and 28th of each month. For this, we are using Flow Schedule FF.

The challenge we’re facing is that the effective date is not picking up as sysdate during the scheduled runs on the 15th and 28th.

I have tried two approaches so far: - Post SQL Bind and Context Bind in Refine Extracts..

Unfortunately, both scenarios resulted in the wrong effective date being picked.

Could you please guide me on how to achieve the correct effective date (sysdate) for these scheduled runs?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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