Maintain Press Actuals Allocations
KB06003907 •141 Views • Updated 3-Mar-2025
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
· Review GL Trailing Months Credit Card Fee Data
· Upload Credit Card Funds Drivers
· Run Credit Card Fees Allocation
· Validate Credit Card Fees 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 Trailing Months Credit Card Fee Data
1. Login to Oracle by selecting the Company Single Sign-On button.
2. Navigate to the Press cluster
3. Select the Credit Card Fees card
4. Select Vertical 1 on the left side of the page
5. Navigate to the horizontal tab Review Credit Card Fee Pool at the bottom of the page
6. Review monthly credit card fees data loaded from the GL
You have now completed the process of reviewing GL trailing months credit card fee data
Upload Credit Card Funds Drivers
1. Login to Oracle by selecting the Company Single Sign-On button.
2. Navigate to the Press cluster
3. Select the Credit Card Fees card
4. Select Vertical 1 on the left side of the page
5. Navigate to the horizontal tab Upload Credit Card Funds Driver at the bottom of the page
6. Select Actions
7. Select Open in SmartView at the bottom the dropdown
a. NOTE: Select Downloaded File in browser after to open
8. If applicable utilize SSO to log into SmartView
9. Enter the data in the column of the relevant month in the yellow cells
a. NOTE: The cells will turn dark yellow upon data entry
10. Select the SmartView Ribbon
11. Select Submit Data
a. NOTE: The cells you entered data into will turn back to a light-yellow color upon successful submission of data
b. NOTE: Navigate back to the application and to the Upload Credit Card Funds Driver horizontal tab in Vertical 1
12. Select Refresh on the top right of the page
13. Confirm the data entered in SmartView is reflected in the column for the relevant month of the data form
You have now completed the process of uploading credit card funds drivers
Run Credit Card Fees Allocation
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 301 for the first Sequence number and 400 for the last Sequence Number
10. Select the Run button at the top right corner of Calculate Model window
a. NOTE: The Press Rule Set Range is 301-400
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 credit card fees allocation
Validate Credit Card Fees Calculation Results
1. Login to Oracle by selecting the Company Single Sign-On button.
2. Navigate to the Press cluster
3. Select the Credit Card Fees card
4. Select Vertical 2 on the left side of the page
5. Review POV in the top menu bar, validate the Chart of Account intersection for the Credit Card Fee source data
6. Review data in the relevant month's column of GL Results - Press Credit Card Fees
a. NOTE: Users also can scroll to the bottom and review the total in the GL Results – Press Credit Card Fees column
7. Select Vertical 3 on the left side of the page
8. Review POV in the top menu bar, validate the Chart of Account intersection for the Credit Card Fee source data
9. Review the columns including Allocation In, Allocation out, and Net Balance. Totals at the bottom should net to zero.
You have now completed the process of validating credit card fees calculations results