Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
where to add parameter effective date conditions to OTBI — 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

where to add parameter effective date conditions to OTBI

Received Response
36
Views
2
Comments
in Reporting and Analytics for HCM 2 comments

Hi All,

Requirement: Added Effective date as a parameter in prompt and report should fetch all active employees as of that date which is given in the effective date parameter.

Can someone help us to set the below condition in OTBI reports.

Used subject area is Workforce Management - Worker Assignment event Real time.

AND to_Char (:P_EFFECTIVE_DATE, 'YYYY/MM/DD') between to_Char(PPPMF.EFFECTIVE_START_DATE, 'YYYY/MM/DD') and to_Char(PPPMF.EFFECTIVE_END_DATE, 'YYYY/MM/DD') -> (Given in SQL)

Regards,

Sreeja N.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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