When reversing a posted Journal or batch if you get this error message, it means the journal source for the subledger journal is frozen.
This is an intended functionality in R12.
To reverse the journal you need to unfreeze the subledger journal source.
Navigation:
General Ledger – Setup – Journal – Sources
Query for the source of your journal
Select the pretended option from the ‘Freeze Journals’ list of values.
- Yes: Journals from this source cannot be changed in the Enter Journals form nor the Journal Correction form. In addition, you cannot reverse journals with Subledger Accounting journal sources that are frozen.
- No: Journals from this source can be changed in both the Enter Journals form and the Journal Correction form. In addition, you can reverse journals with unfrozen Subledger Accounting journal sources.
- Journal Entry Page Only: Journals from this source cannot be changed in the Enter Journals form but can be changed in the Journal Correction form. In addition, you cannot reverse journals with Subledger Accounting journal sources that have this option.
Change the value to ‘No’ & save. Now the system will allow you to reverse the journal.
Note:
After reversing the journal, freeze the subledger source (i.e.) change the value to ‘Yes’. If not frozen this will allow users to reverse subledger sourced journals at will, causing reconciliation problems between general ledger and the subledgers.
---X---
Great post - so many issues that relate to Oracle online often present a problem without a solution; this clearly lays out the solution with screenshots.
ReplyDeleteThanks for acknowledging my work....
DeleteI don't even know how I ended up here, but I thought this post was great.
ReplyDeleteI don't know who you are but definitely you're going to a famous blogger if you aren't already ;) Cheers!
My webpage that site
Thanks for your kind words....
Deleteonce a journal source is "unfrozen", is there auditability to when the change was made, by whom, and for how long? our external auditors are concerned about the ability to unfreeze journals and are interested in controls that mitigate the risk of subledger data not tying to general ledger because of changes to the batch journals
ReplyDeleteDhananjayan
ReplyDeleteCould you please tell us how can we unfreeze the journal in 11i for correction
Tnx
Sri