My Oracle Support Banner

How to pass first day of next month as 'Effective Date' within the Effective Date Parameter when defining extract (Doc ID 2343488.1)

Last updated on OCTOBER 16, 2023

Applies to:

Oracle Fusion Benefits Cloud Service - Version and later
Oracle Fusion Benefits - Version and later
Information in this document applies to any platform.


 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

Requirement is to pass first day of next month as 'Effective Date' (When Scheduling the extract). when updating the Parameter Details as below, it is not working as expected.

Parameter Basis = SQL Binding
Basis Value = select last_day(sysdate) +1 from dual



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.