Procure to Pay Panoramas
Find out about business scenarios, data selection, report view options, and data definitions for Procure to Pay Panoramas available under Budget & Finance in the Business Analytics Hub (bah.ucsd.edu).
Procure to Pay Reports
The Procure to Pay Panorama provides insights to all campus reporting needs related to Requisitions, Purchase Orders, and Invoices. This panorama offers high-level dashboard views and detailed inquiry reports for campus use.
Procure to Pay Action Items
Required Oracle Roles
Roles needed to view data:- PO Reporting Inquiry JR
- AP Reporting Inquiry JR
Business Scenarios
How you can use these reports & business questions these reports answer:
- What Requisitions that have been submitted are still pending?
- What Purchase Orders that are not closed still have Commitment amount pending to be Invoiced?
- How long have non-paid Invoices been aging?
- What Invoices are currently on hold within OFC?
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 Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Procure to Pay Transaction Inquiry
Required Oracle Roles
Roles needed to view data:- PO Reporting Inquiry JR
- AP Reporting Inquiry JR
Business Scenarios
- How you can use these reports & business questions these reports answer:
- I want to know all the transactions for the entire P2P process that are associated to a specific transaction
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 Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Requisition Summary
Required Oracle Roles
Roles needed to view data:- PO Reporting Inquiry JR
Business Scenarios
-
How you can use these reports & business questions these reports answer:
- What Requisitions that have been submitted are still pending?
- How many Requisitions are being submitted per month by each requestor? by preparer?
- What is the total number of Requisitions that have been placed for a given time period?
- What is the average processing time for my Requisitions by Vendor? by Account Code?
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 numerical form and as bar graphs, pie charts, and tables
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Requisition Inquiry
Required Oracle Roles
Roles needed to view data:- PO Reporting Inquiry JR
Business Scenarios
-
How you can use these reports & business questions these reports answer:
- What is the approval history of my Requisition?
- What does this Requisition look like within Oracle UI?
- What items were placed on a Requisition?
- What CCOA used on a Requisition?
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 Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Purchase Order Summary
Required Oracle Roles
Roles needed to view data:- PO Reporting Inquiry JR
Business Scenarios
-
How you can use these reports & business questions these reports answer:
- What is my PO Commitment over time?
- What is the volume of POs that have been placed over time?
- What Suppliers are we using within my department?
- What types of commodities are we utilizing for our POs?
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 numerical form and as bar graphs, and tables
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
PO Inquiry
Required Oracle Roles
Roles needed to view data:- PO Reporting Inquiry JR
Business Scenarios
-
How you can use these reports & business questions these reports answer:
- What are the items placed on a PO?
- What is the CCOA or POETAF string used on a PO?
- What is the revision history on a PO?
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 numerical form and as bar graphs, and tables
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Purchase Order Commitments
Required Oracle Roles
Roles needed to view data:- PO Reporting Inquiry JR
Business Scenarios
-
How you can use these reports & business questions these reports answer:
- What PO have open Commitment amounts that need to be Invoiced?
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 numerical form and as bar graphs, and tables
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Invoice Summary
Required Oracle Roles
Roles needed to view data:- AP Reporting Inquiry JR
Business Scenarios
How you can use these reports & business questions these reports answer:
- What are all of the Suppliers Invoices and payments during a period of time?
- How much as been paid to each Supplier and with what payment methods?
- What received Invoices are unpaid and how long have they been unpaid and why are they unpaid?
- What is the number of Invoices that are being paid by Invoice source? (OFC, Transcepta, External, etc.)
- What payment methods are Invoices being paid with?
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 numerical form and as bar graphs, and tables
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Invoice Inquiry
Required Oracle Roles
Roles needed to view data:- AP Reporting Inquiry JR
Business Scenarios
How you can use these reports & business questions these reports answer:
- What is the approval history of an Invoice?
- What is the current status of an Invoice?
- What items were placed on an Invoice?
- What CCOA or POETAF were used on an Invoice?
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 numerical form and as bar graphs, and tables
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Supplier Inquiry
Required Oracle Roles
Roles needed to view data:- PO Reporting Inquiry JR
Business Scenarios
How you can use these reports & business questions these reports answer:
- What are Vendors can I use in OFC?
- What Vendors are active within OFC?
- What are all the business classifications for a Vendor?
- What kind of payment option is set up for the Supplier?
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 numerical form and as bar graphs, and tables
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Demo
Watch the Procure to Pay Demo