Established Member.. HP_Jack
Established Member..
622 views

How to configure the number of days in one year

Hello,

I need to change the number of working days from this year onward (from 200 to 210).

 

I also need to have this value set in some place (db?) because I need to use it from several reports and I don't want to write it as a constant into reports (otherwise it would be a pain if/when I'll have to change it again).

 

Which is the correct way to set this value?

 

thanks and kind regards

0 Likes
1 Reply
Established Member.. Utkarsh_Mishra
Established Member..

Re: How to configure the number of days in one year

The best way to achive this is to use Regional calander and mark the non-working days according to your organization. This option will adjust the Resoruce capacity/load  which is used by out of the box entities.

 

Now if above option does not fits to your reqirement then define this as constant at DB level.

 

  1. First option is to create a DB table and store your value for specific year. So ever vise there will be number of working days.
  2. Another option is to create a custom oracle package and within it create a custom function with your business logic. So based on year passed to this function you will get the number of working days.
Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.