Home » Applications » Oracle Fusion Apps & E-Business Suite » Define Budget Form: AutoCopy
Define Budget Form: AutoCopy [message #213552] Thu, 11 January 2007 04:19 Go to next message
kelliherj
Messages: 11
Registered: October 2006
Location: Killarney
Junior Member
Hi,

I was wondering if anyone could help with this query.
A person on our client team was setting up the budget for next year in GL for one of the orgs on our application and they used the AutoCopy function for that org from 2006 and it has now populated the 2007 budget for every month with all 2006 data.
Can we undo this step?
And how?

Cheers!
Re: Define Budget Form: AutoCopy [message #213568 is a reply to message #213552] Thu, 11 January 2007 05:17 Go to previous messageGo to next message
David.K.Dickson
Messages: 413
Registered: October 2005
Location: Surrey, England
Senior Member
kelliherj wrote on Thu, 11 January 2007 10:19
..... and they used the AutoCopy function for that org from 2006 and it has now populated the 2007 budget for every month with all 2006 data.
Can we undo this step?

If you can determine the names of the table(s) that have been effected, you could talk nicely to your APPS DBA about rolling back the updates to that(those) table(s). Alternatively, if you still have the 2007 budget in a spreadsheet, you could upload it again (via ADI?).

Cool HTH

David.
Re: Define Budget Form: AutoCopy [message #213571 is a reply to message #213568] Thu, 11 January 2007 05:33 Go to previous messageGo to next message
kelliherj
Messages: 11
Registered: October 2006
Location: Killarney
Junior Member
Cheers, I think lots of tables would have been updated but if we can isolate them that may well work.
Re: Define Budget Form: AutoCopy [message #335031 is a reply to message #213552] Sat, 19 July 2008 12:03 Go to previous message
slamonty
Messages: 8
Registered: October 2007
Junior Member

delete all rows created in tables

1)gl_bc_period_map where budget_version_id=(yourbudget_version_id).

2)gl_balances where budget_version_id=(your budget_version_id).

3) update latest_opened_year from 2007 to null

4) Press Open Next Year or Autocopy as you want

Previous Topic: Is there a report to search for invoices by Payment Term and Due Dates?
Next Topic: Tax on PO
Goto Forum:
  


Current Time: Sun Dec 08 18:14:19 CST 2024