Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Update of "graphic of bar" and "Cost details" "of financial summary, by fiscal year

SOLVED
Go to solution
Highlighted
Pedro_X
Occasional Contributor

Update of "graphic of bar" and "Cost details" "of financial summary, by fiscal year

hello,

 

please I need help to update the graph financial summary and cost details by fiscal year.

 

- The fiscal year begins July 1 and ends on June 1
- I need the chart and cost details starts in July and ends in June
- Update the file "periods.conf" no results "PPM / conf / fiscal / periods.conf"

 

help me, thank you!

 

Example

Imágenes integradas 1

7 REPLIES
Dennis Handly
Honored Contributor

Re: Update of "graphic of bar" and "Cost details" "of financial summary, b

>- The fiscal year begins July 1 and ends on June 1

 

Not June 30?

Pedro_X
Occasional Contributor

Re: Update of "graphic of bar" and "Cost details" "of financial summary, b

Sorry,

 

The fiscal year begins july 1 and ends on june 30.

 

 

randull
HPE Expert

Re: Update of "graphic of bar" and "Cost details" "of financial summary, b

Hi Dennis,

 

You can find the information about how to shift the Starting month of fiscal years on the guide that you can find in the following link, on page 11.

 

 

http://support.openview.hp.com/selfsolve/document/KM995165

Best regards,
Randall

-- Remember to give Kudos to answers! (click the KUDOS star)
"If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”
Pedro_X
Occasional Contributor

Re: Update of "graphic of bar" and "Cost details" "of financial summary, b

Hi randull,
 
after updating the "period.conf" when running the command "shif". I figure the following error.
 
"Existing periods do not seem to be contiguous."
 
 
randull
HPE Expert

Re: Update of "graphic of bar" and "Cost details" "of financial summary, b

Pedro,

 

Please run this query and check if there is any period missing,

 

select * from ppm_fiscal_periods_nls.

 

In a previous case we found something like this,

 

I checked the file "select from ppm_fiscal_periods_nls.xls" and I found the following problem.

1 27/04/12 13:33:59,000000000 1 27/04/12 13:34:31,000000000 AMERICAN 8 31855 18/10/98 01:00:00,000000000 24/10/98 01:00:00,000000000 10/18 10/18 3 43
1 27/04/12 13:33:59,000000000 1 27/04/12 13:34:31,000000000 AMERICAN 8 31860 01/11/98 01:00:00,000000000 07/11/98 01:00:00,000000000 11/01 11/01 0 44

 

There is a weeke missed between those two records. The week missed is 25/10/98 - 31/10/98.

 

That's what we need to found here.

 

Best regards,
Randall

-- Remember to give Kudos to answers! (click the KUDOS star)
"If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”
Pedro_X
Occasional Contributor

Re: Update of "graphic of bar" and "Cost details" "of financial summary, b

Hi Randull, thanks for your help...

 

I found several weeks lost, what should I do now?

 

best regards

randull
HPE Expert
Solution

Re: Update of "graphic of bar" and "Cost details" "of financial summary, b

Hi,

 

This is based on the example I mentioned previously where they were missing this week, 25/10/98 - 31/10/98.

 

We can do the following to resolve the problem:

1. Backup the table PPM_FISCAL_PERIODS_NLS.

2. Check how many records there are in the PPM_FISCAL_PERIODS_NLS where the SEQ is bigger than 43 and the period type is 8 (weeks):

 

(This is why the week they were missing was the has to be after the seq 43, Period_type 8 is the week one)


Select * from PPM_FISCAL_PERIODS_NLS where SEQ>=44 and PERIOD_TYPE=8;

3. Update the sequence for the existing record, so we can insert the missed week.


(They update the sequences after the 43 increasing 1, because they were missing just one week, and it has to be the 44 sequence)


Update PPM_FISCAL_PERIODS_NLS set SEQ=SEQ+1
where SEQ>=44 and PERIOD_TYPE=8;

- Be sure that the quantity of rows updated is the same as the records returned in step 2.
- Commit the operation

Commit;

4. Insert the week missed:

Insert into PPM_FISCAL_PERIODS_NLS (FISCAL_PERIOD_ID,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,
DEFINITION_LANGUAGE,PERIOD_TYPE,PARENT_PERIOD_ID,START_DATE,END_DATE,
LONG_NAME,SHORT_NAME,CHILD_PERIOD_SEQ,SEQ)
VALUES (PPM_FISCAL_PERIODS_NLS_S.nextval, 1, sysdate, 1,sysdate,
'AMERICAN',8,31855,'25/10/98 01:00:00,000000000','31/10/98 01:00:00,000000000',
'10/25','10/25',4,44);

 

(Here they insert the week missing, notice that they were using the 44 sequence to insert it because it was the one missing)


- Commit the operation

Commit;

5. Try to shift the fiscal month again from the console feature.
________________________________________

Best regards,
Randall

-- Remember to give Kudos to answers! (click the KUDOS star)
"If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”
//Add this to "OnDomLoad" event