Fusion Global HR: Scheduled HCM Extracts have Incorrect Effective Date (Doc ID 1615954.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Fusion Global Human Resources - Version 11.1.7.0.0 and later
Oracle Fusion Global Human Resources Cloud Service - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Symptoms

HCM extracts have been scheduled to run daily.
The Effective Date being passed as date of submission rather than the SYSDATE.

Interfaces are running with incorrect effective date (1 day in the past)

Configuration done in "Refine HCM Extract" to make parameter "Effective Date" as Parameter Basis = Post SQL Bind and Basis Value = select TO_CHAR(SYSDATE,'YYYY-MM-DD') from dual
The sql is being evaluated on submission, resulting in effective date being date of submission, and not date of extract run

Tried changing the "Refine HCM Extract" configuration to sql bind, context bind (sysdate) but it is not working.


The issue can be reproduced at will with the following steps:
1. Login to Fusion Apps as an HCM Admin
2. Navigator > Data Exchange > Refine HCM Extracts.
3. Select the Payroll Flow. Click on the Parameters tab
4. Set the "Effective Date" parameter with Parameter Basis = Post SQL Bind and Basis Value = select TO_CHAR(SYSDATE,'YYYY-MM-DD') from dual
5. Submit the extract on 07-JAN-14
Set the Start Date for the extract to 10-JAN-14
6. Review the Payroll Flow Parameters after it has been submitted.
Effective Date shows SYSDATE (07-JAN-14) instead of the intended date (10-JAN-14)




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms