Home » Applications » Oracle Fusion Apps & E-Business Suite » Reset gl and subledgers (R12)
Reset gl and subledgers [message #438031] Wed, 06 January 2010 20:47 Go to next message
bananaman
Messages: 71
Registered: March 2009
Member
Hi!
I'd like to know if there is way to reset or delete the transactions entered in GL, AP, AR, and CM as if these are all fresh set up?

Report message to a moderator

Re: Reset gl and subledgers [message #438032 is a reply to message #438031] Wed, 06 January 2010 21:09 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
That depends!!
Have you posted the data to GL?
This would be a very lengthy process, reversing batches, etc
I feel better to raise an SR.

By
Vamsi

Report message to a moderator

Re: Reset gl and subledgers [message #438116 is a reply to message #438031] Thu, 07 January 2010 03:28 Go to previous messageGo to next message
bananaman
Messages: 71
Registered: March 2009
Member
All subledger transactions are not yet posted to GL.

Report message to a moderator

Re: Reset gl and subledgers [message #438158 is a reply to message #438116] Thu, 07 January 2010 05:14 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
When I mean posted, have you run Create Accounting with "Transfer to GL" parameter as Yes (Or) run Transfer Journal Entries to GL?

Once it is accounted in SLA or Transferred to GL, I would suggest you to log an SR.
If you want NET to be zero, you may cancel the invoice, void the payment in AP, reverse the Receipt in AR. Transactions in AR, we can't do anything. I'm not sure about CM.
But there is a concept of UNDO Accounting in SLA. It is having some impacts, Hence touch base with Oracle Support would be a good idea.

By
Vamsi

Report message to a moderator

Re: Reset gl and subledgers [message #438292 is a reply to message #438158] Thu, 07 January 2010 21:08 Go to previous messageGo to next message
bananaman
Messages: 71
Registered: March 2009
Member
No. Not yet. All transactions in AP and AR are still unaccounted and thus not transferred and posted yet to GL. The problem in reversing and voiding my subledger transactions is the volume. I have thousands of transactions to be reversed and voided. I tried to look at the concurrent program if there is an available program which will allow me to reverse/void the transactions but failed to find one. Any other idea bout this?

[Updated on: Thu, 07 January 2010 21:10]

Report message to a moderator

Re: Reset gl and subledgers [message #438320 is a reply to message #438292] Fri, 08 January 2010 01:38 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Why do you want to delete them?
Is it a production instance?
If not and I'm in your place, I would take a back of the relevant tables and delete the data from AP or AR
and mark the SLA events to Z Z status, so that Create Accounting won't pick them up.
If it is production, I'm afraid to do so.
Anyway why are you hesitating to contact Oracle Support?

By
Vamsi

Report message to a moderator

Re: Reset gl and subledgers [message #438564 is a reply to message #438320] Sun, 10 January 2010 23:35 Go to previous message
bananaman
Messages: 71
Registered: March 2009
Member
Because the data entered via interface tables have erroneous values, like the amount. Thanks.

Report message to a moderator

Previous Topic: Other financial system to OraFin
Next Topic: Absence request reason, Pending Transaction
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 16:03:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.