Project and Portfolio Management Practitioners Forum
cancel

Generate Periods in PPM 7

Highlighted
Pachi
Super Contributor.

Generate Periods in PPM 7

Hi All,

 

We are in PPM Version 7

 

we are unable to create ITG’s on project requests as year field
which is mandatory is only up to Dec 2012, and we had a
document where in that document was for PPM8 to generate periods and not for PPM7 , we tried to use the same and tried on 7 but was not able to find the script for generate periods.

 

Now that we dont any other options, we are planning to write insert query on the DB directly for Jan 2013 and Feb 2013 as shown below, will this cause any problems? or is there any other way to generate the periods?

 

 

INSERT all

 

INTO knta_periods

 

(PERIOD_ID,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,PERIOD_TYPE,PERIOD_CODE,START_DATE,END_DATE,PERIOD_FULL_NAME,PERIOD_SHORT_NAME,PERIOD_TYPE_ID,SEQ,PERIOD_GROUP_ID)

 

VALUES(30180,10,'1995-08-28 00:00:00.0',10,'1995-08-28 00:00:00.0','FISCAL_MONTH','Jan  2013-01-01 00:00:00.0','2013-01-31 00:00:00.0','January 2013','01/13',4,181,30300)

 

INTO knta_periods

 

(PERIOD_ID,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,PERIOD_TYPE,PERIOD_CODE,START_DATE,END_DATE,PERIOD_FULL_NAME,PERIOD_SHORT_NAME,PERIOD_TYPE_ID,SEQ,PERIOD_GROUP_ID)

 

VALUES(30181,10,'1995-08-28 00:00:00.0',10,'1995-08-28 00:00:00.0','FISCAL_MONTH','Feb  2013-02-01 00:00:00.0','2013-02-31 00:00:00.0','February 2013','02/13',4,182,30300)

 

 

 

Regards,
Pachi
1 REPLY
Erik Cole
Acclaimed Contributor.

Re: Generate Periods in PPM 7

kGenFiscalPeriods.sh should be in your server_home/bin directory