Skip to main content

System Status: 

Financial Accountability

Find out about business scenarios, data selection, report view options, and data definitions for Financial Accountability Panoramas available under Budget & Finance in the Business Analytics Hub (bah.ucsd.edu).

Exceptions Panorama 

The Exceptions Panorama is designed to highlight the transaction discrepancies and errors in the Oracle financial system.

Receipts to PPM Recon

Business Scenarios

  • Miscellaneous Receipt does not post the expected negative cost to the Project in PPM, uupdate only made in the GL

  • My Department submitted Cash Deposit ticket for the reimbursement of the Cost on a Project, however, we do not see this Cost yet reimbursed within the Project Cost

  • At the time of the Receipt Creation we did not know the Task to which to apply, and once we updated the Services and Support ticket, the Cost was still not captured in the Project
  • If the Receipt needs to be reversed, will it show and reflect the Cost within PPM?

Data Selection and View Options

  • Use these parameters to filter for the data you want to see
  • These filters can be used in combination or individually to produce desired results




Report Views

  • Results display in a default table with the ability to export the result set into a file
  • Additional columns are available for users to add to the report
  • Refer to the section below titled Understanding the Data for definitions, data includes usage rules and full description

Revenue in Fund 13037

Business Scenarios

  • Miscellaneous Receipts (Revenue) should not be posted to Fund 13037 (Treasurer’s Cash Fund), they should be identified and posted to the correct Fund (and Account code if available)
  • Did my transactions post to the correct COA?
  • What should I do if this happened?
  • Any more actions needed on my side?

Data Selection and View Options

  • Use these parameters to filter for the data you want to see
  • These filters can be used in combination or individually to produce desired results

revenue-in-Fund-13037_p.png
Report Views

  • Results display in a default table with the ability to export the result set into a file
  • Additional columns are available for users to add to the report
  • Refer to the section below titled Understanding the Data for definitions, data includes usage rules and full description


Non-Invoiced PO to GL & PPM Reconciliation

Business Scenarios

  • This report is used to correct a financial discrepancy where a Purchase Order has been created with a Project within the Chart of Accounts and has been recorded on the General Ledger, but does NOT contain Project information within the Project Costing section of the Purchase Order and is incorrectly reflected within PPM Costing

Data Selection and View Options

  • Use these parameters to filter for the data you want to see
  • These filters can be used in combination or individually to produce desired results



Report Views

  • Results display in a pivot table with 3 columns
  • Additional columns are available for users to add to the report
  • Refer to the section below titled Understanding the Data for definitions, data includes usage rules and full description

Invoiced PO to GL & PPM Reconciliation

Business Scenarios

  • This report is used to correct a financial discrepancy where a Purchase Order has been created and Invoiced

  • The PO has a Project within the Chart of Accounts and has been recorded on the General Ledger, but does NOT contain Project information within the Project Costing section of the Purchase Order and is incorrectly reflecting within PPM Costing

Data Selection and View Options

  • Use these parameters to filter for the data you want to see
  • These filters can be used in combination or individually to produce desired results 



Report Views

  • Results display in a pivot table with 3 columns
  • Additional columns are available for users to add to the report
  • Refer to the section below titled Understanding the Data for definitions, data includes usage rules and full description

 

AP Invoice to GL & PPM Reconciliation

Business Scenarios

  • Report is used to correct a financial discrepancy where an Invoice contains a Project within the Chart of Accounts and has been recorded on the General Ledger, but does NOT contain Project information within the Project Costing section of an Invoice and is incorrectly reflected within PPM Costing

Data Selection and View Options

  • Use these parameters to filter for the data you want to see
  • These filters can be used in combination or individually to produce desired results



Report Views

  • Results display in a pivot table with 3 columns
  • Additional columns are available to users to add to the report
  • Refer to the section below titled Understanding the Data for definitions, data includes usage rules and full description

 

Non-Sponsored Project Names Starting with SP

Business Scenarios

  • What General Projects need to be renamed because they are referencing the SP prefix for a Sponsored Project?
  • Does my department have any General Projects named using Sponsored Project naming conventions?

Data Selection and View Options

No parameters are available for this report

Report Views

  • Results display in a default table of 7 columns
  • Refer to the section below titled Understanding the Data for definitions, data includes usage rules and full description 

 

Find answers, request services, or get help from our team at the UC San Diego Services & Support portal.