Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to generate Monthly Report

TinaJan 26 2015 — edited Jan 26 2015

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 23 2015
Added on Jan 26 2015
3 comments
417 views