UCPath-Oracle Salary Reconciliation

Access has been provisioned to anyone with DOPE Report access.  Staff who do not have access should request UCPath Cognos reports access to Payroll Accounting and Reconciliation. Access failure appears as error "Unable to load requested view. Displaying home view instead."

1. Navigate to bah.ucsd.edu.

2. Select Budget & Finance. 

3. If using the List View, look for UCPath-Oracle Salary Reconciliation in the list or use the search bar at the top right and click the dashboard name.

   • If using the Card View, click the Payroll Accounting and Reconciliation tab and click Launch on the UCPath-Oracle Salary Reconciliation tile 

4. Use your Active Directory credentials to sign in, if prompted.

Here you can find various tips and tricks on navigating Cognos report functionality

• Use these parameters to filter for the data you want to view
• These filters can be used in combination or individually to produce desired results
• Accounting Period: We recommend excluding the current accounting period so the report does not include amounts that simply have not yet posted in Oracle.
• Report Format: 
  • Sort by Variance: Recommended when looking at a very small number of accounting periods, particularly in FY21. This view will sort the largest variances (positive or negative) to the top for quick identification of project mismatches.
  • Sort by Project: Most commonly used when searching a broad range of accounting periods and best for seeing when corrections were made. When sorting by project, two pages are provided to ease reconciliation. One page reconciles by accounting period and the other reconciles by expenditure date.

The report has three levels: a main report and two levels of drill-throughs. The third report level is where you will identify the reason for any differences between UCPath and Oracle. The different levels are detailed in respective drawers below.

(Click on the image below to see a larger version)

Summary

The UCPath-Oracle Salary Reconciliation report compares salary amounts in the UCPath Labor Ledger to amounts in Oracle by project, task, account, and accounting period. It does not display rows where the amounts are the same. It also does not display project-tasks where the total variance is zero. The Variance column is calculated as the difference between the UCPath Amount and the Oracle Amount. 

UCPath Pay for Family Care and Bonding (PFCB) amounts are shown in a separate column and are not included in the Variance calculation. These amounts post originally in both Labor Ledger and in Oracle, and then will be refunded in Oracle only in the month subsequent to the original posting.  

When sorting by project, two pages are provided to ease reconciliation. One page reconciles by accounting period and the other reconciles by expenditure date, matching the Earnings Period End Date in the Labor Ledger to the Expenditure Item Date for Oracle PPM transactions or the Accoutning Date for Oracle GL transactions.  

Reconciling by accounting period is useful for monthly reconciliation, but you may see a variance in one accounting period and then the opposite (positive or negative) variance in another accounting period for the same project-task. This indicates either a correction or a timing difference and no further investigation is required.

• This report uses Oracle PPM data for payroll on projects, and Oracle GL data for payroll not on a project. It does not compare Oracle PPM to Oracle GL data. 
• The report reconciles only salary amounts, not other non-salary payroll amounts.
• Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules.

Report Views

Reconciling by accounting period

Reconciling by expenditure date

Summary

Clicking on the Variance amount at Level 1 allows you to see detailed Labor Ledger and Oracle ledger transactions for the selected Financial Unit, Project, Account, and Accounting Period. You may see multiple Original Transaction Reference numbers in each list. Identify Original Transaction Reference numbers that appear in one list but not the other as the source of the variance. Click on the Original Transaction Reference number to get to Level 3.

Report Views

(Click on the image below to see a larger version)

Summary

Clicking on the Original Transaction Reference number at Level 2 allows you to see detailed Labor Ledger and Oracle ledger transactions for that Original Transaction Reference. Note that information will appear only in the Oracle PPM section for payroll on projects and only in the Oracle GL section for payroll not on a project.  Both Oracle sections will not be populated, and lack of information in one section or the other does NOT indicate a GL-PPM variance. Compare the details for the UCPath transaction to the details for the Oracle PPM or Oracle General Ledger transaction.  

Possible differences

• Project number: Payroll may have posted to one project in the Labor Ledger and a different project in the Oracle ledger. There are a variety of reasons for this, which may or may not require correction.
• Task number: In FY21, payroll may have posted to one project-task in the Labor Ledger but a different task of the same project in the Oracle Ledger. If the Labor Ledger task is correct, the Oracle transactions can be corrected via PPM cost transfer. If the Oracle task is correct, no action is required.
• Accounting Period: A mismatch between the UCPath Salary Accounting Date and the Oracle Accounting Period indicates a timing difference. No action is required.
• The same transaction appears twice with the same amount on the same project in Oracle: The payroll transaction posted twice and has not been corrected. 
• No transaction appears in either Oracle section: The transaction has not posted in Oracle.

Report Views

(Click on the image below to see a larger version)