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!
Go to Solution.
>- The fiscal year begins July 1 and ends on June 1
Not June 30?
The fiscal year begins july 1 and ends on june 30.
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.
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 431 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.
Hi Randull, thanks for your help...
I found several weeks lost, what should I do now?
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+1where 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 operationCommit;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 operationCommit;5. Try to shift the fiscal month again from the console feature.________________________________________