ERPstuff - Oracle EBS Community

Hi All,
This is one of the interesting issue,

A Consultant has used the calendar periods as 12+12...24.. ie for every month there will be an adjusting period, and defined the sob using that calendar.
and started using the SOB - entered two months data
Now the client wants to change the calendar style to 12+1 13 months....

Can anyone suggest what measure we can do to have 12+1 calendar ????

Thanks

I would suggest to setup 12+2 that is one adjusting for opening balances and one for closing balances. thanks

Hi,
your suggestion is good but how to reduce the 12+12 to 12+2 ???

that is my query?

Pls suggest me....

Thanks,

This is what Oracle says about changing a Calendar...

You can change a period?s specifications, except for the period type, as long as the period has not been used in a set of books. You cannot change a calendar period that is open, closed, future enterable, or permanently closed in any set of books, or is included in an open budget or encumbrance year.

Thanx

Muzaffar Naim

Oracle Consultant

Hi,
Thanks for your reply, but I want to know is there any work around for that??
I have tried for the status that is never opened and I can delete the period, but what can we do for the status that are with future period or opened as the client wants to change the pattern....

Thanks

Hi Anu,

I suggest this way. Please look at it how much possible:

1. Take Opening Balance as on Date from the Current SoB
2. Create a fresh SOB with a fresh 12+1 calendar.
3. Upload the opening balances to the newly assigned SoB

I suggest this practice because, as a functional consultant we will not know what happens in the backend database. It is always better to opt for simple solution than extensions or work arounds or personalization.

However, I am not against these Worarounds or personalization. I am saying this should be kept as last resort.

Thanks.