The Distribution of Payroll Expense (DOPE) report is designed to show payroll expenses based on several search parameters. You can use the information from the DOPE report to determine where it posted in Oracle Financial Cloud (OFC). The OFC Original Transaction Reference is a direct mapping to the UCPath Labor Ledger reference information.
In the DOPE report, there are 3 critical pieces of information that will allow you to trace transactions from UCPath into OFC.
These 3 critical values, separated by periods become the Original Transaction Reference number.
Example: OFC PPM Original Transaction Reference: 200731M0X.PJ00000959.912
There are two reports to look in OFC for the Original Transaction Reference Number:
Project Costs Detail Report
The Project Costs Detail Report can be used to check cost details for all projects by Award number, Financial Unit, Accounting Period(s) and more. These transactions will match the costs found in the PPM Manage project costs screen of the Oracle User Interface(UI).
Transaction Details Report (TDR)
The Transaction Details report provides detailed information about transactions posted to the Oracle General Ledger and PPM subledger. The report also allows users to isolate pre-defined high-risk transactions for ledger review.
There are 3 ways to access and view this data:
1.DOPE Report drillthrough
2. Transaction Details Report (TDR)
a. Use this option if you don’t know which Project the payroll posted to
3. Oracle Manage Project Costs screen.
Option 1: DOPE Report drillthrough
1. While in the DOPE Report on the Salary-Fringe Combination tab, click on the Original Transaction Reference Number. This will open the Transaction Details Report to identify all Oracle PPM transactions associated with that Original Transaction Reference Number.
Option 2: Transaction Details Report (TDR)
1. Log into BAH
2. Search/navigate to the report: Transaction Details Report (TDR)
3. Under Display Prompts, select PPM Full.
3. Enter the Original Transaction Reference Number from the DOPE Report in the Original Transaction Reference search box, found under Transaction Detail Prompts. An Original Transaction Reference Number can be associated with more than one Earnings Period End Date. To find transactions associated with a specific date, use the Expenditure Item Date search under Time and Display Prompts.
4. Alternatively, to search more globally for payroll transactions, select UCSD UC Path as the Transaction/Journal Source (also under Transaction Detail Prompts) and search using other parameters, such as the Accounting Period, Creation Date, or Expenditure Item Date, and a Project or Financial Unit.
5. To run the report, click Finish.
Option 3: Manage Project Costs Screen
1. The PPM Project Inquiry and Reporting role is required to access the Project Costs module, if you have this role, the Project icon will display on the Home page.
2. Navigate to the Project Costs area by either:
a. Home > Projects and Awards > Costs > Task Pane > Review and Adjust > Manage Project Costs (any Project)
b. Home > Awards > Search for Award > Manage Project Costs (Sponsored Projects only)
3. Search by Transaction Source: UCSD UCPath:
a. If Transaction Source is not a visible column, please refer to KB0033337: Editing and Defining Columns in OFC PPM Project Management Costs, to add column.
b. When viewing a specific transaction, the DOPE line information is in the Expenditure Item Comments column and the Original Expenditure item.
NOTE: On the DOPE report, you will see individual employee payroll data, however in OFC, you will see summarized data by Expenditure Type and UCPath Labor Ledger journal lines.