11i ‘Program – Restore Journals’ resolves GL Journals Stuck with Funds Reservation In Process
Oracle released a new 11i concurrent program a few months back which is meant to resolve issues with GL Journals when the gl journal batch is perpetually stuck with Funds Reservation “In Process”. I’ve dealt with this issue numerous times and from my experience, the issue normally has been caused by getting a connection/network hiccup while in the process of reserving Funds for a large GL Journal Entry. Until now, a datafix has been required to fix these issues. The datafix essentially clears out gl_bc_packets & gl_bc_packet_arrival_order of any fund reservation entries for the batch & sets the je batch back to an an unreserved status. Then the user should take another shot at reserving the journal.
This datafix process can now be retired due to Patch 8975321 in 11i. This Patch provides a new concurrent program ‘Program – Restore Journals’ as a replacement for the previously required datafix steps. The program requires journal batch name as an input parameter and the program essentially executes the same steps as the datafix did.
The My Oracle Support (MOS) note on this new functionality is:
GLXJEENT Funds Status Is Showing ‘In-Process’, Can Not Post Journal [ID 1141794.1]
It is also interesting to note that the original bug for this issue (944420: NEED A CONCURRENT PROCESS TO FIX JE AFTER FAILED FUNDS RESERVATIONS) dates back to 1999!!
Just wanted to share as this new functionality should save a good amount of time when encountering this issue going forward and mitigate the risk of having to run the datafix update.
Oracle Federal Applications 
Leave a comment