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
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.