Scheduling HCM Extract - Effective Date Parameter Value Change
(Doc ID 2317107.1)
Last updated on MARCH 12, 2024
Applies to:
Oracle Fusion Benefits Cloud Service - Version 11.12.1.0.0 and laterInformation in this document applies to any platform.
Goal
Oracle Fusion Benefits Cloud Service
Release 12
Scheduling HCM Extract - Effective Date Parameter value change
Client has HCM extract created for benefit enrollments (With Effective date as default parameter).
When Scheduling HCM extract, Effective Date Parameter is dynamically changing (to sysdate) if edit the Parameter Details as below
Parameter Basis = Context Binding
Basis Value = System Date
But requirement is to pass first day of next month as 'Effective Date' (When Scheduling the extract).
So they have updated the Parameter Details as below but is not working as expected.
Parameter Basis = SQL Binding
Basis Value = select last_day(sysdate) +1 from dual
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |