Purpose
The following guide is intended for a Planning and Budgeting Administrator who is looking to view or complete any of the following actions:
Action
· Run Net Asset Release Calculation
· Validate Net Asset Release Calculation Results
Prerequisite
· Recording Financial Transaction in Oracle Cloud: Introduction to the Chart of Accounts and POETAF
· Oracle Planning 101 & Budget Development Overview
Review GL Monthly Data
1. Login to Oracle by selecting the Company Single Sign-On button.
2. Navigate to the Finance cluster
3. Select the Net Asset Release card
4. Select Vertical 1 on the left side of the page
5. Select the Period member at the top left of the page
6. Navigate to the relevant Period member
a. NOTE: Users can also utilize the search bar to search for the desired member selection
7. Select the check box next to the desired period
8. Select OK in the top right of the member selector box
9. Select the Go icon
10. Review Data from the GL for the Period
You have now completed the process of Reviewing GL Monthly Data
Run Net Asset Release Calculation
1. Login to Oracle by selecting the Company Single Sign-On button.
2. Select the Modeling cluster
3. Select Calculation Control
4. Select the relevant fiscal year -> relevant month -> Actual -> Final utilizing the check box
5. Select Calculate Model
6. Click the dropdown box at the top of the page, select Actual Data Model
a. NOTE: You can enter a job comment below if desired
7. Leave the Processing Options as they appear
8. Set Processing Range to Ruleset Range
9. Enter the number 101 for the first Sequence number and 200 for the last Sequence Number
10. Select the Run button at the top right corner of Calculate Model window
a. NOTE: The Finance Rule Set Range is 101-200
11. Select the Calculation Analysis card at the top of the page
12. Select the Refresh button at the top left of the page until status moves from Processing -> Completed for the calculation you executed
You have now completed the process of running a net asset release calculation
Validate Net Asset Release Calculation Results
1. Login to Oracle by selecting the Company Single Sign-On button.
2. Navigate to the Finance cluster
3. Select the Net Asset Release card
4. Select Vertical 2 on the left side of the page
5. Select the Period member at the top left of the page
6. Navigate to the relevant Period member
a. NOTE: Users can also utilize the search bar to search for the desired member selection
7. Select the check box next to the desired period
8. Select OK in the top right of the member selector box
9. Select the Go icon
10. The second column (the 55700 Account column) shows the results of the calculation
11. Verify the totals in row TR Gift - Spend Funds - D10200, All Entity and All Organization in both columns B7000 and O-55700 equal each other
12. Select Vertical 3 on the left side of the page
13. Ensure the POV Period is set to the relevant month
a. NOTE: If the period is not set to the relevant month already, follow steps 5 thru 9 above again to select it
14. Validate the Adjustment In, Adjustment out, and Net Balance columns for the Account Restriction Met on Existing Gifts
15. Scroll to the bottom and validate the totals. The Net Balance column should net to zero.
You have now completed the process of validating net asset release calculation results