Project and Portfolio Management Practitioners Forum
cancel

PPM ::Calender problem

Highlighted
Pachi
Super Contributor.

PPM ::Calender problem

Hi,

 

We have our planned end to be till dec 2012, we would like this to be extended till dec 2014 in Project details request type.

Please find the screen shot which i am refering to, and the query which is being used for this.

 

Please let me know, how can we extend this date till 2014

 

select period_id, period_full_name
from knta_periods
where period_type_id = 4 AND
     start_date >= (select start_date from knta_periods where period_id = [REQ.P.KNTA_PLAN_START_DATE]) AND
     UPPER(period_full_name) like UPPER('?%') AND
     (period_full_name like UPPER(substr('?', 1, 1)) || '%' OR
      period_full_name like LOWER(substr('?', 1, 1)) || '%')
order by start_date

Regards,
Pachi
6 REPLIES
penoles
Super Contributor.

Re: PPM ::Calender problem

You should extends the periods in DB by command kGenFiscalPeriods.sh located in Bin directory

Pachi
Super Contributor.

Re: PPM ::Calender problem

Hi,

Thanks for your help

 

kGenFiscalPeriods.sh -startYear <2013> -endYear <2014>

 

will the above command do? will it cause anyproblems to old dates or request?

 

Is there any ways to revert back the changes? if it fails. Please advice.

Regards,
Pachi
penoles
Super Contributor.

Re: PPM ::Calender problem

This command can insert fiscal period into db. I attach the document for your reference.

Pachi
Super Contributor.

Re: PPM ::Calender problem

will this hold good even for

HP PPM 7.1.0 SP6 ? and do we have a roll back step?

Regards,
Pachi
penoles
Super Contributor.

Re: PPM ::Calender problem

7.1 is too old for me, but  you can find kGenFiscalPeriods.sh in your ppm instance, it should work for just extending the periods on 7.1.

You'd better back up ppm db if you want to  roll back.

Mohit_Agrawal
Outstanding Contributor.

Re: PPM ::Calender problem

Hi Prachi,

 

What I would suggest is, don't run the kGenFiscalPeriods.sh command without consulting with HP PPM support. Because this command will change the fiscal years period in the financial summaries of the proposals and many other places as shown below. For more information as till how many periods you have defined...you can refer to the .CSVfile located at  <PPM_HOME>/bin/fiscal/output.

 

JUST FYI: You can run the kGenFiscalPeriods.sh script to generate periods for a range of years. The periods appear in or are used for the following:
1. Total costs, benefits, and approved budgets for fiscal quarters and fiscal
years in financial summaries
2. Scenario comparisons in HP Portfolio Management
3. Staffing profiles in HP Resource Management
4. Calendar auto-complete fields, used in creating projects, for example
5. Portlets and reports

 

First thoroughly analyze the impact and then do the needful rather than blindly runnin this script.

 

Thanks!!

Mohit Agrawal