DBMS Scheduler logic required
<p>I need to set up a due date concept using DBMS scheduler below is the requirement .please suggest how I can achieve this using DBMS scheduler.
I am planning to pick this date from <code>dbms_scheduler</code> tables where it should calculate the date and hold in some column for referencing.   </p>

<p>Requirement</p>

<ul>
<li>The due date needs to change every 6 months:</li>
<li>For June: Last working Friday</li>
<li>For Dec: Second-week ending date on Friday</li>
</ul>

<p>e.g. For 2016 it should be 24 June 2016 &amp; 9 Dec 2016</p>