Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
per_availability_details.GET_AVAILABILITY_DETAILS sometimes returns no entries
Summary
Not receiving expected data on occasionContent
I have opened SR 3-20637810941 for this. Upon occasion we receive no records for any employee when executing a BI report that contains the following query. The goal of using GET_AVAILABILITY_DETAILS, is to determine if a full (N) or half (Y) day is registered for the absence. (If person scheduled for 7.5 hours, then 3.75 hours is half day, et cetera.)
When this fails, it seems to fail for the entire population.
WITH parms AS (
SELECT ADD_MONTHS(TRUNC(:date1, 'YEAR'), - 12) AS last_year_begin -- First day of prior year
, ADD_MONTHS(TRUNC(:
0