My Oracle Support Banner

GLXJEENT: Funds Is Still Remaining Although Performing Unreserve Funds on GL Budget Journals (Doc ID 2465274.1)

Last updated on OCTOBER 26, 2018

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Funds is still remaining although performing Unreserve Funds on GL budget journals.

Summary
1. Create GL budget journals to reduce available funds
2. Reserve Funds
3. Unreserve Funds
--> Unreserve Funds is NOT working fine and Funds is still remaining


Steps to Reproduce

1. Settings

1.  System Profile Option "Journals: Allow Preparer Approval" : Yes

2.  (N)Setup > Employees > Limits  - Authorization Limit : 10000

3.  (N)Setup > Journal > Sources
       >> "Budget Journal" with Require Journal Approval = Yes

2. Check Funds Available

(N)Inquiry > Funds

10.100.10.B1001.2000 - Funds Available : 200

GL_BC_PACKETS(1)
PACKET_ID STATUS_CODE ENTERED_DR ENTERED_CR
--------- ----------- ---------- ----------
2001                S        200            <--Original

 3. Reduce 100 Funds Available

(N)Budgets > Enter > Journals

(1) Enter 100 to Credit

Period : APR-16
Credit : 200

(2) Press [Create Journals] button
(3) Press [Check Funds] button
(4) Press [Run Journal Import] button
(5) Press [Done] button

4. Review Budget Journal

(N)Journals > Enter

10.100.10.B1001.2000   (DR)    (CR) 100

GL_BC_PACKETS(2)
PACKET_ID STATUS_CODE ENTERED_DR ENTERED_CR
--------- ----------- ---------- ----------
2001                S        200             <--Original
2009                S                    100 <--Reduce 100

5. Check Funds

(N)Journals > Enter - Press [Check Funds] button

GL_BC_PACKETS(3)
PACKET_ID STATUS_CODE ENTERED_DR ENTERED_CR
--------- ----------- ---------- ----------
2001                S 200                   <--Original
2009                S                   100 <--Reduce 100
2010                S                   100 <--Check Funds

6. Approve

 (N)Journals > Enter - Press [Approve] button

7. Reserve Funds

(N)Journals > Enter - Press [Reserve Funds] button

GL_BC_PACKETS(4)
PACKET_ID STATUS_CODE ENTERED_DR ENTERED_CR
--------- ----------- ---------- ----------
2001                S        200            <--Original
2009                S                   100 <--Reduce 100
2010                S                   100 <--Check Funds
2011                A                   100 <--Reserve Funds

8. Check Funds Available

(N)Inquiry > Funds

10.100.10.B1001.2000 - Funds Available : 100


9. Unreserve Funds

(N)Journals > Enter - Press [Unreserve Funds] button

GL_BC_PACKETS(5)
PACKET_ID STATUS_CODE ENTERED_DR ENTERED_CR
--------- ----------- ---------- ----------
2001                S        200            <--Original
2009                S                   100 <--Reduce 100
                                            <--Check Funds is deleted
2011                A                   100 <--Reserve Funds

PACKET_ID:2010 (STATUS_CODE = S and it created by Check Funds) is deleted wrongly.
PACKET_ID:2011 (STATUS_CODE = A and it created by Reserve Funds) should be deleted

10. Check Funds Available

(N)Inquiry > Funds

10.100.10.B1001.2000 - Funds Available : 100

---> Funds Available should be 200 because "Reduce 100 Funds Available" is Un-reserved.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.