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.
BIP report, for identifying the missing Time Entries
Summary
This will be useful If we are expecting to see missing time entries in report or infolets. This SQL query logic is based on the Working hours of the User.Content
> The SQL logic checks if the sum of the Time Entry hours is less than Assignment Working Hours, then that week is considered as there are some missing entries in that week.
> As the Time Card would automatically picks the Absence Type (any absence entry) and Holiday Payroll Time Type, these entries are also considered by SQL and it will sum up to the Time Entry Hours.
Code Snippet
Tagged:
5