select distinct olf.invoice_date, TO_CHAR(olf.invoice_date,'DAY'), trunc(create_date), 
count(*)
from order_line_fact olf
where invoice_date in
       (-- invoice date loaded on more than 1 day
         select distinct invoice_date
         from order_line_fact
         where invoice_date between to_date('01-JAN'||to_char(sysdate-2, '-rr')) and sysdate-2
         having count(distinct trunc(create_date)) > 2
         group by invoice_date
         union
         -- invoice date not loaded next day
         select distinct invoice_date
         from order_line_fact
         where invoice_date between to_date('01-JAN'||to_char(sysdate-2, '-rr')) and sysdate-2
         and ((invoice_date > trunc(create_date))
           or (invoice_date < trunc(create_date) - 1))
         union
         -- invoice date record count outside of normal range (Mon-Fri)
         select distinct invoice_date
         from order_line_fact 
         where invoice_date between to_date('01-JAN'||to_char(sysdate-2, '-rr')) and sysdate-2
         and to_number(to_char(invoice_date, 'D')) <> 1 
         and to_number(to_char(invoice_date, 'D')) <> 7
         having count(*) < 10000 or count(*) > 17000
         group by invoice_date
         union
         -- invoice date record count outside of normal range (Sat)
         select distinct invoice_date
         from order_line_fact 
         where invoice_date between to_date('01-JAN'||to_char(sysdate-2, '-rr')) and sysdate-2
         and to_number(to_char(invoice_date, 'D')) = 7
         having count(*) <= 0 or count(*) > 1700
         group by invoice_date
         union
         -- invoice date record count outside of normal range (Sun)
         select distinct invoice_date
         from order_line_fact 
         where invoice_date between to_date('01-JAN'||to_char(sysdate-2, '-rr')) and sysdate-2
         and to_number(to_char(invoice_date, 'D')) = 1
         having count(*) < 0 or count(*) > 50
         group by invoice_date
) 
group by olf.invoice_date, TO_CHAR(olf.invoice_date,'DAY'), trunc(create_date);

  SELECT invoice_date
  FROM order_line_fact
  WHERE invoice_date BETWEEN
        to_date('01-JAN'||to_char(sysdate-2, '-rr')) 
        AND sysdate-2
  HAVING count(distinct trunc(create_date)) - 1  -- two_or_more_days
  +      MAX(
           CASE invoice_date
           WHEN trunc(create_date) THEN 0
           WHEN trunc(create_date) + 1 THEN 0
           ELSE 1
           END
         )                                  -- not_next_day
  +      COUNT(
           CASE to_char(invoice_date, 'D')
           WHEN 1 THEN NULL
           WHEN 7 THEN NULL
           ELSE 1
         )                                  -- num_weekdays
  +      COUNT(
           CASE to_char(invoice_date, 'D')
           WHEN 1 THEN NULL
           WHEN 7 THEN 1
           ELSE NULL
         )                                  -- num_saturdays
  +      COUNT(
           CASE to_char(invoice_date, 'D')
           WHEN 1 THEN 1
           WHEN 7 THEN NULL
           ELSE NULL
         )                                  -- num_sundays
  > 0

count(distinct trunc(create_date)) - 1

  +      MAX(
           CASE invoice_date
           WHEN trunc(create_date) THEN 0
           WHEN trunc(create_date) + 1 THEN 0
           ELSE 1
           END
         )                                  -- not_next_day