How to Use DOPE Information to View Posting in OFC


Overview


The Distribution of Payroll Expense (DOPE) report is designed to show payroll expenses based on several search parameters. You should 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. 

Essential Information


Next Steps


There are 3 ways to access and view this data:

1. Transaction Details Report (TDR)

2. Project Costs Detail Report

a. Use this option if you don’t know which Project the payroll posted to

3. Oracle Manage Project Costs screen.


Option 1: Transaction Details Report

1. Log into BAH
2. Search/navigate to the report: Transaction Details Report (TDR)

  1. See full report instructions here.

Option 2: Project Costs Detail Report 

1. Log into bah.ucsd.edu
2. Search/navigate to the report: Project Costs Detail Report
3. Enter the following Information

a. Transaction Source: UCSD UCPath
b. Original Transaction Reference: that equals the Labor Ledger identifying information.
c. OR, search for a more global criteria such as Fin Unit (Project Owning Organization) or Creation date (this is the date posted to PPM, not the accounting date).

4. When parameters are complete, select Apply.
5. Click View Report icon, to the left of Gear icon, select file type for download. 


Option 3: Individual Project Costs Screen

1. The PPM Project Inquiry and Reporting role is required to access the Project 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.

DOPE Report Line References


  1. IFIS Journal Description 200731M0X|PJ00000959|0000912 = Pay Run Code|Salary Journal ID|Salary GL Journal Line Number.
  2. OFC Original Transaction Reference: 200731M0X.PJ00000959.912 = Pay Run Code.Salary Journal ID.Salary GL Journal Line Number.
  3. UCPath DOPE/Labor Ledger columns:
    • Pay run code = 200731M0X
    • Salary Journal ID = PJ00000959 (PJ = Payroll Journal, PT = Payroll Transfer (a.k.a. Direct Retro))
    • Salary GL Journal Line Number = 912

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. 

Questions?


If you need any additional assistance, please submit a ticket here.