Project and Portfolio Management Practitioners Forum
cancel

Sequence gets Incremented by 100 in PPM 8 for FM Tables

Highlighted
Santoshkumar.mo
New Member.

Sequence gets Incremented by 100 in PPM 8 for FM Tables

Hi,

I found that sequence of primary key for Fm_Finance_cells and Fm_Actual_Forecast_Period_Sum has been designed to increment by 100.

i.e. If I do
Select FM_AF_Period_Sum_S From dual
Select FM_Financial_Line_Cells_S.nextval From dual it is incrementing by 100.

sequence for this has been desgined to increment by 100.

Not sure why it is so.. Could anyone please suggest what is the problem.

Thanks,
Kumar
1 REPLY
Shravan Kathuri
Honored Contributor.

Re: Sequence gets Incremented by 100 in PPM 8 for FM Tables

Yes, I do see the same problem.

While I wanted to copy the existing financial summary to new financial summary, I found that the sequence of mentioned tables are getting incremented by 100.

but not sure what impact it will have on copy financial summary function.

As of now it is copying properly, but it is costly affair to use sequence which increments by 100..

Please any one could suggest on this...

Thanks
Shravan