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.
How to report Open Requisitions with AS OF DATE parameter
Summary:
Need OTBI report that shows all open requisitions with an AS OF date parameter. For example, all open requisitions as of 1-1-2022.
Content (required):
I have an OTBI requisition report using Subject Area Recruiting - Recruiting Real Time. The requirement is to identify open requisitions AS OF the Requisition Open Date. I have added a Variable Prompt (AsOfDate), and in the Advanced Tab, have applied Prefix SET VARIABLE PARAM_EFFECTIVE_DATE='@{AsOfDate}';
The report returns the below error. What needs to be done in order to use an As Of Date prompt in this subject area? Should I be using a different date field, for example if I want to report on all open requisitions as of 1/1/2022?
Tagged:
1