Hi Gurus,
I am running into one scenario where I have a query that generates name of the REPORTS configured to run on Monthly Basis.
I am seeing a bug in the query which uses 2 tables Report and Calander.
Report table has Begin_Date as 1/30/2015 (Seems configuration issue, as we don't have 30th Day in FEB) and End_Date as 12/31/2015
Report
Name / Eff_Begin_Date / EFF_End_Date
Calander
Month Name/Day of a month Name
Currently for the Month of FEB , it is failing as we have only 28 days in FEB and the join condition 'EFF_BEGIN_DT' = 'Day OF A month' fails.
Correcting Configuration is the 1st option (I believe for FEB we should have EFF_BG_DT as 1/28/2015 instead of 1/30/2015).
Apart from this is there any workaround so that I can still pick the FEB row with 'EFF_BEGIN_DT' = 'Day OF A month' condition using some case/decode statement?
Thanks