Calendar Periods

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
anu_uma
Posts: 456
Joined: Sat Feb 03, 2007 4:39 am
Location: India
Contact:

Calendar Periods

Post by anu_uma »

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
admin
Posts: 2118
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

I would suggest to setup 12+2 that is one adjusting for opening balances and one for closing balances. thanks
anu_uma
Posts: 456
Joined: Sat Feb 03, 2007 4:39 am
Location: India
Contact:

Post by anu_uma »

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

that is my query?

Pls suggest me....

Thanks,
muzaffarnaim
Posts: 66
Joined: Fri Dec 15, 2006 4:59 pm
Location: USA

Post by muzaffarnaim »

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
anu_uma
Posts: 456
Joined: Sat Feb 03, 2007 4:39 am
Location: India
Contact:

Post by anu_uma »

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
vijayasarathyr
Posts: 38
Joined: Sat Sep 02, 2006 2:36 am
Location: India
Contact:

Post by vijayasarathyr »

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.
Post Reply

Who is online

Users browsing this forum: No registered users and 9 guests