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
· Upload Insurance Allocation Percent
· Verify Insurance Allocation Results
Prerequisite
· Recording Financial Transaction in Oracle Cloud: Introduction to the Chart of Accounts and POETAF
· Oracle Planning 101 & Budget Development Overview
Enter Insurance Cost Pool
1. Login to Oracle by selecting the Company Single Sign-On button
2. Navigate to the Insurance cluster
3. Select the Insurance Allocation card
4. Select Vertical 1 on the left side of the page
5. Navigate to the horizontal tab Insurance Cost Pool at the bottom of the page
6. Select the Period member at the top left of the page
7. Navigate to the relevant Period member
a. NOTE: Users can also utilize the search bar to search for the desired member selection
8. Select the check box next to the desired period
9. Select OK in the top right of the member selector box
10. Select the Go icon
11. For each Insurance Type enter in Cost Pool amount in the Current Year column
a. NOTE: There are more columns then able to be demonstrated in the screen capture, utilize the cursor to view all columns and enter data as desired
12. Select Save
You have now completed the process of entering insurance cost pools
Upload Insurance Allocation Percent
1. Login to Oracle by selecting the Company Single Sign-On button
2. Navigate to the Insurance cluster
3. Select the Insurance Allocation card
4. Select Vertical 1 on the left side of the page
5. Navigate to the horizontal tab Upload Allocation Percents at the bottom of the page
6. Select Actions
7. Select Open in Smart View
a. NOTE: Open downloaded file in the browser downloads
8. If applicable utilize SSO to log into SmartView
9. Enter in the current year allocation percent
a. NOTE: The cells will turn to dark yellow upon data entry
10. Select the SmartView Ribbon, Submit Data
11. Navigate back to the application and to the Update Allocation Percents horizontal tab
12. Select the Refresh on the top right of the page
13. Confirm the data entered in SmartView is reflected in the data form
You have now completed the process of uploading an insurance allocation percent
Run Insurance 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 201 for the first Sequence number and 300 for the last Sequence Number
10. Select the Run button at the top right corner of Calculate Model window
a. NOTE: The Insurance Rule Set Range is 201-300
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 insurance allocation
Verify Insurance Allocation Results
1. Login to Oracle by selecting the Company Single Sign-On button
2. Navigate to the Insurance cluster
3. Select the Insurance Allocation card
4. Select Vertical 2 on the left side of the page
5. Ensure the POV Matches what is shown (with the relevant fiscal year and Period)
a. NOTE: POV selections can be made by clicking into the desired dimension in the POV
6. Validate the Allocation In, Allocation Out, Net Change columns for the calculation results
7. Select Vertical 3 on the left side of the page
8. Ensure the POV Matches what is shown (with the relevant fiscal year and Period)
a. NOTE: POV selections can be made by clicking into the desired dimension in the POV
9. Validate the Allocation In, Allocation Out, Net Change columns for the calculation results
You have now completed the process of verifying insurance allocation results