Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Benefits OTBI Analysis with Effective Date Parameter Not working
Summary
Benefits OTBI Analysis with Effective Date Parameter Not workingContent
Team,
I have a Benefits enrollment details OTBI analysis which is working fine without prompt.
I am trying to add an Effective Date Prompt to check between the Enrollment period start and end date. It is erroring out.
Could you check and help me to fix this report.
Some key points highlighted below:
Filters added:
and CAST (Enrollment Period Start Date AS DATE ) is less than or equal to 01/01/2021
and CAST (Enrollment Period End Date AS DATE ) is greater than or equal to 01/01/2021
Prompt used:
cast("Time"."Date" as date)
Tagged:
0