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.
Parameterised Dates in OTBI
Summary
Need to get Tax year start and end dates relative to current dateContent
I need to get the UK tax year start date (April 6th) applicable to current date, the report needs to be scheduled overnight so must not require manual intervention to set the dates, otherwise it would be easy ;-)
In the good old days I would just have created repos variables, but here I only have OTBI, I have tried some overly complicated nested statements to extract the year based on current_date but that didn't work.
OTBI is still a learning curve for me, we appear to have Cloud HCM 19A (11.13.19.01.0) and OTBI 11.1.1.9
Tagged:
0