Resources: Oracle Financials Report Types and Uses
Reporting against the financial data in the Oracle Financial System is done in the ReportMart3 web portal and in Oracle Business Intelligence (OBI). Select an activity below to view related reports and descriptions.
Account Structure: Stanford's Chart of Accounts
PLEASE NOTE: Robust and dynamic ad hoc analyses for experienced financial analysts, and simple interactive Finance Reference Data and Inquiry (e.g., PTA attributes) reports for administrative and financial staff, are available using Oracle Business Intelligence (OBI). For more information, visit OBI Financial Reporting.
Additionally, the following reports are available in ReportMart3 to help staff track the setup status of Projects, Tasks, and Awards.
| Report Title | Report Description |
|---|---|
| FIN_REF_216_Award_Config_Report | The Award Configuration Report shows the setup values, funding installments, award budget, and project funding information for a selected list of awards. The budget information is consistent with the data displayed in the Oracle "Award Budgets" form updated during Award entry. All tasks (baselined and not baselined) associated with any project which has been budgeted, will be represented in the report table. One report will print per award. |
| FIN_REF_217_Award_Listing | The Award Listing Report provides a quick listing of Awards for a specific organization, award name, or award creation date range. |
| FIN_REF_225_Fund_Authorization | The Fund Authorization Report provides the award setup information pertinent to gift and endowment funds together with text describing fund usage as detailed by donor / department. Used for non-sponsored projects. |
| FIN_REF_227_Project_Task_Listing | The Project Task Listing Report provides a quick listing of Projects and associated Tasks for a specific project-owning organization, project name, legacy activity number, project owner name, project number, task-owning organization, or creation date range. |
| FIN_REF_229_PTA_Listing | The PTA Listing Report displays the title, owning organization, principal owner, manager, type, start date, end date, and legacy account for requested Project, Task, and Award combinations. |
Buying and Paying
The following reports are available in ReportMart3 to help staff track purchase requisitions, purchase orders and invoice payments.
| Report Title | Report Description |
|---|---|
| FIN_PO_209_AP_Supplier_Info | Provides a listing of all vendors that currently have records in Stanford's Oracle Internet Procurement system. Also includes records for University faculty, staff, and affiliates which are used in the iOU reimbursement system. |
| FIN_PO_207_AP_Requisition_Detail | Run this report to see all the information pertinent to your requisitions, including Purchase Order, Invoice, and Payment information. |
| FIN_PO_206_AP_Purch_Order_Detail | Use this report to find and display information specific to Purchase Orders. This report is searchable by PO Number, Supplier Name, or Buyer Name. Provides detailed information associated with a given Purchase Order, including Receiving, Invoice, and Payment information. |
| FIN_EXP_148_Purch_Order_Recon | This report can be used to aid in the detailed review of Purchase Orders. The report includes information related to the Purchase Order including any PO Change Order Number, Receiving information, Invoice information and Payment information. An alternative to this report is using the SU Inquiry Tool "Requisition and Purchase Order Query" and drilling to the purchase order information. |
| FIN_PO_201_AP_Invoice_Detail | Provides detailed information associated with invoices based on the search criteria provided. Includes Supplier, Invoice, and Payment information. |
| FIN_EXP_138_Invoice_Detail_Recon | This report can be used to aid in the detailed review of invoices. It can also be used to provide additional details to facilitate PI Quarterly Certification for Sponsored Projects. The report includes information related to the Invoice including Supplier Information, Invoice Information and Payment information. An alternative to this report is using the SU Inquiry Tool "Requisition and Purchase Order Query" and drilling all the way to the Invoice information and image of the actual vendor invoice. |
| FIN_PO_205_AP_Remittance_Advice | Provides complete information about checks generated from the Accounts Payable system. Displays check number, date, and amount, and all invoices and invoice amounts related to that check. |
PLEASE NOTE: Robust and dynamic ad hoc analyses for experienced financial analysts, and simple interactive Expense Requests and SU Card Activity reports for administrative and financial staff, are available using Oracle Business Intelligence (OBI). For more information, visit OBI Financial Reporting.
| Report Title | Report Description |
|---|---|
FIN_PCARD_186_Transaction_Summary FIN_PCARD_187_Transaction_Detail FIN_PCARD_189_Aging_Report FIN_PCARD_257_Custodians |
These ReportMart3 reports are being retired in the transition to OBI Integrated Payments and Expenditure reporting. Expense Requests and SU Card Activity dashboard reports include PCard transaction details and custodian information in a single reporting platform. To explore all support resources on how to access OBI dashboard reports, visit: • About OBI Financial Reporting |
| Report Title | Report Description |
|---|---|
FIN_IOU_266_Other_Check_Trans FIN_IOU_267_Other_Check_MP_Trans |
These ReportMart3 reports are being retired in the transition to OBI Integrated Payments and Expenditure reporting. Expense Requests and SU Card Activity dashboard reports include Non-PO Payment (i.e., Check Request) transaction details in a single reporting platform. To explore all support resources on how to access OBI dashboard reports, visit: • About OBI Financial Reporting |
Capital Equipment and Capital Projects
The following reports are available in ReportMart3 to assist with managing capital equipment and capital projects.
| Report Title | Report Description |
|---|---|
| FIN_PMO_196_CEET | The Capital Equipment Expenditure Transactions Report shows all expenditures by expenditure type and by transaction detail by Project Task Award in a given month. This report contains Expenditure Types 531% and 550%. This report is searchable by Project, Task and/or Award Number. |
| FIN_PMO_198_Fabrication_Exp | The PMO Fabrication Expenditures Report is a summarized report of expenditures for all Fabrication PTA where through the reporting period. This report is searchable by Project, Task and/or Award Number. |
| FIN_PMO_199_Non_Capital_Exp | The Non Capital Expenditures Report shows all expenditures by expenditure type and by transaction detail by Project Task Award in a given month. This report contains Expenditure Types 55135, 55140, 55145 and 55150. This report is searchable by Project, Task and/or Award Number. |
| Report Title | Report Description |
|---|---|
| FIN_CAP_107_Prj_to_Date_Mo | This report intended for use by those who are managing Capital and Non-Capital Projects. The report displays detailed and summary budget, expenditure, and commitment information for each project, top task, task and award where the project status is not "Closed" in the Oracle system. It combines salary and non-salary information into one report. |
| FIN_CAP_192_Cap_and_NonCap_Proj | This report displays budget, expenditure, and encumbrance information for each project and task. |
| FIN_CAP_193_Open_Pos_Cap_Acct | This report provides a list of capital accounting contracts based on Project Number, Award, and Purchase Order Number. Report will display contract totals, total invoices received, payments to date and remaining contract accounts. |
| FIN_CAP_195_Proceeds_Used | This report shows total award amount, funding and expenditures by project. |
Cash Handing and Deposits
The following reports are available in ReportMart3 to help staff manage receipts.
| Report Title | Report Description |
|---|---|
| FIN_FUND_153_Fund_Statement | The Fund Statement shows the beginning fund balance, transactional activity, and ending fund balance for the set of books, reporting period, and fund(s) selected by the report user. All balances and transfers included in this report are derived from tables within Oracle's General Ledger module. Fund information for Operations or Income Funds is displayed by entering "SU" at the Set of Books prompt. Fund information for Endowment Principal Funds is displayed by entering "EN" at the Set of Books prompt. |
| FIN_REV_283_Mo_By_Mo_Revenue |
This report provides a month-by-month summary of actual revenue by Award / Award-Project at the revenue object level. |
| FIN_OP_101_Operating_Detail_FTD | This report can be used for all award types but is set to report by fiscal year. It contains detailed revenues and expenditures (salary and non-salary) transactions for the last month selected in the reporting period, as well as annual revenue / expense controls (budget), fiscal year to date actuals and variances. |
Financial Authority
Anyone with a valid SUnet ID and password can view authority roles for an individual, a department or unit, or an authority privilege using Authority Reports available in Authority Manager. Use the reports to verify that the correct level of authority has been granted to you or your department(s).
For more information, see How To: View Authority Assignments.
Financial Reporting Tools
Not applicable to this activity. Select one of the other activities to view related Oracle Financials reports available in ReportMart3 or Oracle Business Intelligence (OBI).
Funds Management
The following reports are available in ReportMart3 and Oracle Business Intelligence (OBI) to help manage funds. The reports are organized in the following sections:
- Fund Restrictions
- Receipts
- Transfers In / Transfers Out / Other Journals
- Expenditures – Summary
- Expenditures – Detail
- Fund Balance
- Budgeting
- Endowment
PLEASE NOTE: Robust and dynamic ad hoc analyses for experienced financial analysts, and simple interactive Finance Reference Data and Inquiry (e.g., PTA attributes) reports for administrative and financial staff, are available using Oracle Business Intelligence (OBI). For more information, visit OBI Financial Reporting.
Additionally, the following reports are available in ReportMart3 to help manage funds.
Related Report Types and Uses for Fund Restrictions Report Title Report Description FIN_REF_216_Award_Config_Report The report shows the setup values, funding installments, award budget, and project funding information. All tasks associated with any project which has been budgeted, will be represented in the report table. Primarily used for sponsored projects. FIN_REF_225_Fund_Authorization The Fund Authorization Report provides the award setup information pertinent to gift and endowment funds together with text describing fund usage as detailed by donor / department. Used for non-sponsored projects. back to Funds Management menu list
Related Report Types and Uses for Receipts Report Title Report Description FIN_FUND_153_Fund_Statement The Fund Statement shows the General Ledger beginning fund balance, transactional activity, ending fund balance and available balance. Fund information for Operations or Income Funds is displayed by entering "SU" at the Set of Books prompt. Fund information for Endowment Principal Funds is displayed by entering "EN" at the Set of Books prompt whereas "SU" is used for operating funds. Fund Statements group receipts into meaningful categories such as Endowment Payout, Other Additions and EFP Allocations. Authority is required. FIN_REV_283_Mo_By_Mo_Revenue This report provides a month-by-month summary of actual revenue by Award / Award-Project at the revenue object level. Authority is required. FIN_OP_101_Operating_Detail_FTD This report can be used for all award types but reports by fiscal year. It contains detailed revenues and expenditures (salary and non-salary) transactions for the last month selected, as well as annual revenue / expense controls (budget), fiscal year to date actuals and variances. Authority is required. FIN_OP_284_Mo_By_Mo This report provides Operating Statement summary information by Award / Award-Project in a monthly or yearly columnar format. This report also provides monthly and yearly asset and liability information not found on other reports. The report is useful in identifying trends. Authority is required.
TIP: In order to receive 3 years of data on the yearly summary tab (tab 2), enter SEP of the first year in the "Report Period Begin Date" prompt and AUG of the third year in the "Report Period End Date" prompt.back to Funds Management menu list
Related Report Types and Uses for Transfers In / Transfers Out / Other Journals Report Title Report Description FIN_JNL_252_Core_Journals The report provides detailed descriptions and other information for Core Oracle journals (which are originated by central office staff). The beginning of the journal name is displayed on the FUND_153 report (and other FUND or GL reports) in the "Journal" column.
TIP: Use the "Journal Name" prompt ( and eEnter the journal name as displayed, on Fund Reports followed by the % sign, in case the name was truncated to fit on the report. Authority is required.FIN_JNL_230_Journal_Inquiry This report displays the entries that were made in iJournals. One tab shows a brief display (including business purpose and originator) regardless on whether the entries are from an individual iJournal or a Feeder. This report retrieves the entire journal entry for individual iJournals. However, for Feeder journals, it does not contain journal line transactions due to the volume of data in each feeder journal entry. Summary information for Feeder journals is visible to all users; Salary authority is required for other iJournals. FIN_LABOR_247_Distrib_ Adj_Detail This ReportMart3 report is being retired in the transition to OBI Payroll and Labor Management (PLM) reports.
The new "Labor Distribution Adjustment Batches – All statuses" report is available in the OBI PLM Dashboard. There are two hyperlinks in the PLM Dashboard where you can access the report. The first is on the "Actual Pay" tab, in the "Labor Distribution Adjustment Batches" report section. The second is available in the Labor Distribution Adjustments section from the "Actual Pay Details By Employee" page.
To explore all support resources on how to access OBI dashboard reports, visit:
• About OBI Financial Reporting
• RM3 to OBI PLM Task MappingFIN_FUND_153_Fund_Statement The Fund Statement shows the General Ledger beginning fund balance, transactional activity, ending fund balance and available balance. Fund information for Endowment Principal Funds is displayed by entering "EN" at the Set of Books prompt whereas "SU" is used for operating funds. Fund Statements group fund transfers into meaningful categories such as Operating Budget Support, Transfers In, Transfers Out and Capital Purchases. Authority is required. FIN_OP_101_Operating_Detail This report can be used for all award types but reports by fiscal year. It contains detailed revenues, transfers and expenditures (salary and non-salary) transactions for the last month selected, as well as annual revenue / expense controls (budget), fiscal year to date actuals and variances. Authority is required. back to Funds Management menu list
Related Report Types and Uses for Expenditures – Summary Report Title Report Description FIN_EXP_275_Award_View
FIN_EXP_276_Project_View
FIN_EXP_277_Task_ViewThe three "view" reports provide a consistent approach towards viewing report data. Tabs are available to view data at a summary PTA level, and by category or expenditure type. Based on your role or perspective, you can choose to view expenditures by Award, Project, or by Task. Data provided includes Budget, Expenditure, Commitments and variance. All the reports include a data-rich download tab ready for use in excel. Authority is required. FIN_EXP_278_Executive_Summary The Executive Summary report provides a summary level overview of expenses, budget and commitment to date data for a specific reporting period, by high level Award Type. It is an aggregate report and combines all PTAs in search result into one summarized report, grouped and totaled by high level Award Type and to the Expenditure Category level. It can be used to look across an organization and answer the question "what was spent on...?". Authority is required. FIN_EXP_280_Month_By_Month_Drill The report provides view and drill-down on monthly expenditure data from an Award, Project or Task focused perspective. Report contains 3 tabs, each with different drill paths (Award, Project or Task). Users may look at summary pages or drill through to Expenditure Type totals. Authority is required. FIN_EXP_281_PTA_Interactive_Drill
The report provides view and drill-down on expenditure data from a Project, Task or Award focused perspective. Report contains 3 tabs, each with different drill paths (Award, Project or Task). Users may look at summary pages or drill through to Expenditure Type totals. Authority is required. FIN_OP_284_Mo_By_Mo This report provides Operating Statement summary information by Award / Award-Project in a monthly or yearly columnar format. This report also provides monthly and yearly asset and liability information not found on other reports. The report is useful in identifying trends. Authority is required.
TIP: In order to receive 3 years of data on the yearly summary tab (tab 2), enter SEP of the first year in the "Report Period Begin Date" prompt and AUG of the third year in the "Report Period End Date" prompt.back to Funds Management menu list
Related Report Types and Uses for Expenditures – Detail Report Title Report Description FIN_EXP_285_Mo_Detail_Statement The Expenditure Statement provides detailed transactions posted to the PTA for the month requested, as well as actual-to-date balances, expense control (budget) and commitments. It is designed to facilitate the review and reconciliation of each PTA. For a detailed review of the report features, visit the Expenditure Detail Report web page. Authority is required. FIN_EXP_279_Transaction_Detail The report provides transaction detail expenditure information by PTA. It does not present budget or commitment data. It can be used to query activity in an account (PTA), expenditure type or by many other search criteria for expenditure analysis. This report contains detailed JCC level information on salary expenditure line items that is not contained in any other expenditure report and has a rich data download tab. Authority is required. FIN_LABOR_169_Earnings_Dist_Emp
FIN_LABOR_173_Suspense_AccountThese ReportMart3 reports have been retired, completing that portion of the transition to OBI Payroll and Labor Management (PLM) reports.
Payroll and Labor Management dashboard reports bring together payroll-related information from both PeopleSoft (e.g., earnings, one-time payments, timecards, and leave information) and Oracle (e.g., labor schedule and labor adjustment information) on a single reporting platform.
To explore all support resources on how to access OBI dashboard reports, visit:
• About OBI Financial Reporting
• RM3 to OBI PLM Task Mapping.FIN_LABOR_247_Distrib_ Adj_Detail This ReportMart3 report is being retired in the transition to OBI Payroll and Labor Management (PLM) reports.
The new "Labor Distribution Adjustment Batches – All statuses" report is available in the OBI PLM Dashboard. There are two hyperlinks in the PLM Dashboard where you can access the report. The first is on the "Actual Pay" tab, in the "Labor Distribution Adjustment Batches" report section. The second is available in the Labor Distribution Adjustments section from the "Actual Pay Details By Employee" page.
To explore all support resources on how to access OBI dashboard reports, visit:
• About OBI Financial Reporting
• RM3 to OBI PLM Task MappingFIN_EXP_138_Invoice_Detail_Recon
FIN_EXP_148_Purch_Order_Recon
FIN_PO_201_AP_Invoice_DetailThese reports provide more detail about Accounts Payable transactions. (Expenditure Detail Report source code: APINV; Acct Ref: invoice number; Dept Ref: Purchase Order number.) FIN_PCARD_186_Transaction_Summary
FIN_PCARD_187_Transaction_Detail
FIN_IOU_265_Reimbursement_Trans
FIN_IOU_266_Other_Check_Trans
FIN_IOU_267_Other_Check_MP_Trans
FIN_IOU_268_Petty_Cash_Replenish
FIN_IOU_269_Advance_Transaction
These ReportMart3 reports are being retired in the transition to OBI Integrated Payments and Expenditure reporting.
Expense Requests and SU Card Activity dashboard reports include all Expense Requests system (e.g., expense reports / reimbursements, advances, Travel Card charges, Non-PO payment and petty cash replenishment), historical iOU and PCard transaction details in a single reporting platform.
To explore all support resources on how to access OBI dashboard reports, visit:
• About OBI Financial Reporting
• RM3 to OBI IPE Task CrosswalkFIN_JNL_230_Journal_Inquiry This report provides more detail about iJournals transactions. (Expenditure Detail Report source code: iJRNL or feeder name; Acct Ref: journal number.) back to Funds Management menu list
Related Report Types and Uses for Fund Balance Report Title Report Description FIN_FUND_153_Fund_Statement The Fund Statement shows the beginning fund balance, transactional activity, and ending fund balance for the set of books, reporting period, and fund(s) selected by the report user. Fund information for Operations or Income Funds is displayed by entering "SU" at the Set of Books prompt. Fund information for Endowment Principal Funds is displayed by entering "EN" at the Set of Books prompt. One fund or award will print per page. FIN_Fund_154_YTD_Fund_Balance_Listing The report provides a brief listing (one line per Award) of the beginning balance receipts, transfers, expenses, investments and available balance. It has a rich data download tab. Authority is required. back to Funds Management menu list
Related Report Types and Uses for Budgeting Report Title Report Description FIN_BGT_165_Current_iBudget_Sum The report displays budget information. Initial 9/1 consolidated Budget data from Hyperion Planning is displayed, along with budget changes or additions entered via the iBudgets application. This report is generally run for non-sponsored and non-capital PTAs. Authority is required. FIN_BGT_166_iBudget_Download The report displays detailed budget information. Initial 9/1 consolidated Budget data from Hyperion Planning is displayed, along with budget changes or additions entered via the iBudgets application. The report is intended for download to Excel where the data can be further manipulated for budget management and decision making purposes. This report is generally run for non-sponsored and non-capital PTAs. Authority is required. FIN_BGT_211_PTA_Budget_Report The report lists budget details and budget amounts by each budget period. The report can be used to verify the budgets on sponsored projects only. This report can be used as a detail budget to accompany the Awards Configuration Report. The report will identify budget lines for different GL periods as well as total project-to-date budget lines. Authority is required. back to Funds Management menu list
Related Report Types and Uses for Endowment Report Title Report Description FIN_FUND_153_Fund_Statement
• Shows beginning fund balance, transactional activity, and ending fund balance for the set of books, reporting period, and fund(s) selected by the report user.
• Endowment Principal Funds displayed by entering "EN" at the Set of Books prompt. One fund or award will print per page.
• When run for "SU" Set of Books, actual endowment payout posted monthly. Includes footnote showing "Anticipated Remaining Payout," "Anticipated Annual Payout" and "Anticipated Available Balance."FIN_FUND_154a_YTD_Fund_Balance_Listing_Noting_Anticipated_Endow_Payout
• Provides a brief listing (one line per Award) of the beginning balance receipts, transfers, expenses, investments and available balance.
• Receipts increase as actual endowment payout posts monthly.
• Data Download tab includes columns for "Anticipated Future Payout" and "Anticipated Available Balance."Note: 154a is functionally the same as 154, but includes additional columns on the data download tab.
FIN_ENDOW_123_Endow_Display
• Reflects an endowment fund's investment holdings including book value, market value and share quantity by pool and share type.
• Investments broken out by pure and quasi shares.
• Provides share valueNote: Reports run for closed periods will reflect Ending Share Value. Reports run for a current, open month will reflect Interim Share Value. See Share Value Calculations.
FIN_ENDOW_128_Endow_Investment
• Summary of share book value and market value by fund / pool.
• Data Download tab provides breakdown of quasi, pure limited and pure unlimited shares, allowing assessment of available Payout Resources for each share type.Note: Reports run for closed periods will reflect Ending Share Value. Reports run for a current, open month will reflect Interim Share Value. See Share Value Calculations.
FIN_ENDOW_134_Pool_Share_Rates
• Displays the selected rate type up through the selected period, by period and by investment pool.
• The "Matrix" report displays the selected rate type in a crosstab format with the periods represented in columns and the pools represented in rows
Month-End / Year-End Close
The following reports are available in ReportMart3 to help staff manage tasks related to closing the books on a monthly and annual basis. See also Year-End Report Matrix for additional information about each of the reports listed below including purpose, required reporting authority (Salary or Non-Salary View), and frequency of updates.
| Report Title | Report Description |
|---|---|
| FIN_EXP_285_Mo_Detail_Statement | The Monthly Expenditure Statement provides detailed transactions posted to the PTA for the month requested, as well as actual-to-date balances, expense control (budget) and commitments. It is designed to facilitate the review and reconciliation of each PTA. |
| FIN_OP_101_Operating_Detail_FTD | This report can be used for all award types but is set to report by fiscal year. It contains detailed revenue and expenditure (salary and non-salary) transactions for the last month selected in the reporting period as well as annual revenue / expense controls (budget), fiscal year to date actuals and variances. |
| FIN_OP_284_Mo_By_Mo | This report provides monthly and yearly Operating Statement summary information by Award / Award-Project. This report also provides monthly and yearly asset and liability information not found on other reports. |
| FIN_FUND_253_YTD_Award_Status | Provides GL & GA category summary level data in a data download format. Allows Budget Officers to see the current status (FTD actuals, expense control) of Projects and Funds prior to year-end and during year-end close. Provides information that will assist in the ability to fund deficits or reallocate surpluses as needed to close their operating budget awards at year-end. |
| FIN_FUND_154_YTD_Fund_Bal_List | Displays Fund Balance for each Fund / Award. Report provides a summary of beginning balance, receipts, operating budget transfers, other transfers, expenses, net investments and available balance. |
| FIN_FUND_152_Fund_Mo_By_Mo | Provides monthly summarized fund information broken down into the following categories: Beginning fund balance, available balance forward, receipts, transfers, expenses, net investments and available balance. |
| FIN_FUND_254_Balance_Sheet_List | Report identifies the types of assets and liabilities held within an Award. |
| FIN_EXP_280_Month_By_Month_Drill | The Month-By-Month Interactive Drill report provides view and drill-down on monthly expenditure data from an Award, Project or Task focused perspective. Report contains 3 tabs, each with different drill paths. There is no "Data Download" tab included on this report. |
| FIN_EXP_281_PTA_Interactive_Drill | The PTA Interactive Drill report provides view and drill-down on expenditure data from a Project, Task or Award focused perspective. Report contains 3 tabs, each with different drill paths. There is no "Data Download" tab included on this report. |
| Report Title | Report Description |
|---|---|
| FIN_FUND_153_Fund_Statement | The Fund Statement shows the beginning fund balance, transactional activity, and ending fund balance for the set of books, reporting period, and fund(s) selected by the report user. Fund information for Operations or Income Funds is displayed by entering "SU" at the Set of Books prompt. Fund information for Endowment Principal Funds is displayed by entering "EN" at the Set of Books prompt. One fund or award will print per page. |
| FIN_REF_225_Fund_Authorization | The Fund Authorization Report provides the award setup information pertinent to gift and endowment funds together with text describing fund usage as detailed by donor / department. Used for non-sponsored projects. |
| FIN_EXP_279_Transaction_Detail | The Transaction Detail report provides transaction detail and JCC level salary expenditure information by Project, Task and Award, for a requested period. |
| FIN_JNL_230_Journal_Inquiry | This report displays the entries that were made in iJournals, including summary information for Feeder Journals. |
| FIN_LABOR_173_Suspense_Account | This report has been retired, completing that portion of the transition to OBI Payroll and Labor Management (PLM) reports. Using the Payroll and Labor Management (PLM) Dashboard in OBI, you can view the current balance (as of the most recently posted pay period end-date) of your Organization Suspense Account on the "Summary" tab. You can also drill to the transaction detail by clicking on the "Amount" hyperlink. Based on the transaction detail, you can process the Labor Distribution Adjustment to clear the balance accordingly. Also, you are able to find all LDA transactions being posted to your Org Suspense Account, by using the Suspense Clearing Details on the "Scheduled Vs Actual" tab. To explore all support resources on how to access OBI dashboard reports, visit: • About OBI Financial Reporting |
Payroll Administration
PLEASE NOTE: Robust and dynamic ad hoc analyses for experienced financial analysts, and simple interactive predefined reports for administrative and financial staff, are available using Oracle Business Intelligence (OBI). For more information, visit OBI Financial Reporting.
| Report Title | Report Description |
|---|---|
FIN_LABOR_167_Earnings_Dist_Plan FIN_LABOR_168_Earn_Dist_Assig_Org FIN_LABOR_169_Earnings_Dist_Emp FIN_LABOR_170_Earnings_Dist_PTA FIN_LABOR_172_Schedules_Planning FIN_LABOR_173_Susp_Charge_Reason LBR 671 Payroll Detail and Planning Report |
These ReportMart3 reports have been retired, completing that portion of the transition to OBI Payroll and Labor Management (PLM) reports. Payroll and Labor Management dashboard reports bring together payroll-related information from both PeopleSoft (e.g., earnings, one-time payments, timecards, and leave information) and Oracle (e.g., labor schedule and labor adjustment information) on a single reporting platform. To explore all support resources on how to access OBI dashboard reports, visit: • About OBI Financial Reporting |
| FIN_LABOR_247_Distrib_ Adj_Detail | This ReportMart3 report is being retired in the transition to OBI Payroll and Labor Management (PLM) reports. The new "Labor Distribution Adjustment Batches – All statuses" report is available in the OBI PLM Dashboard. There are two hyperlinks in the PLM Dashboard where you can access the report. The first is on the "Actual Pay" tab, in the "Labor Distribution Adjustment Batches" report section. The second is available in the Labor Distribution Adjustments section from the "Actual Pay Details By Employee" page. To explore all support resources on how to access OBI dashboard reports, visit: • About OBI Financial Reporting |
Payroll for Employees
Currently there are no Oracle Financials reports available to assist with employee payroll activities.
See How To... in Payroll for Employees for information on how to view personal information like current and historic pay statements, direct deposit enrollments, withholding allowances, W-2 Statements, and more.
Petty Cash Administration
| Report Title | Report Description |
|---|---|
| FIN_IOU_268_Petty_Cash_Replenish | This ReportMart3 report is being retired in the transition to OBI Integrated Payments and Expenditure reporting. Expense Requests and SU Card Activity dashboard reports include petty cash replenishment transaction details and petty cash fund information in a single reporting platform. To explore all support resources on how to access OBI dashboard reports, visit: • About OBI Financial Reporting |
Reimbursement / Expense Reporting
| Report Title | Report Description |
|---|---|
FIN_IOU_265_Reimbursement_Trans FIN_IOU_269_Advance_Transaction FIN_IOU_301_Transaction_Report |
These ReportMart3 reports are being retired in the transition to OBI Integrated Payments and Expenditure reporting. Expense Requests and SU Card Activity dashboard reports include all Expense Requests system (e.g., expense report / reimbursements, advances, and Travel Card charges) and historical iOU transaction details in a single reporting platform. To explore all support resources on how to access OBI dashboard reports, visit: • About OBI Financial Reporting |
Supporting Students
The following reports are available in ReportMart3 and Oracle Business Intelligence (OBI) to help staff reconcile Graduate Financial Support (GFS) to Expenditure Reports.
| Report Title | Report Description |
|---|---|
| FIN_EXP_285_Mo_Detail_Statement | The Expenditure Detail Reports:
|
| FIN_EXP_149_Qtrly_EXP_Cert | The Quarterly Review and Certification Report includes Salary and Non-Salary detail data for multiple months and can be used for both sponsored and non-sponsored PTAs. |
| FIN_EXP_279_Transaction_Detail | The Transaction Detail report provides transaction detail and JCC level salary expenditure information by Project, Task and Award, for a requested period. |
| FIN_LABOR_170_Earnings_Dist_PTA | This ReportMart3 reports have been retired, completing that portion of the transition to OBI Payroll and Labor Management (PLM) reports. Payroll and Labor Management dashboard reports bring together payroll-related information from both PeopleSoft (e.g., earnings, one-time payments, timecards, and leave information) and Oracle (e.g., labor schedule and labor adjustment information) on a single reporting platform. To explore all support resources on how to access OBI dashboard reports, visit: • About OBI Financial Reporting |
| FIN_LABOR_247_Distrib_Adj_Detail | This ReportMart3 report is being retired in the transition to OBI Payroll and Labor Management (PLM) reports. The new "Labor Distribution Adjustment Batches – All statuses" report is available in the OBI PLM Dashboard. There are two hyperlinks in the PLM Dashboard where you can access the report. The first is on the "Actual Pay" tab, in the "Labor Distribution Adjustment Batches" report section. The second is available in the Labor Distribution Adjustments section from the "Actual Pay Details By Employee" page. To explore all support resources on how to access OBI dashboard reports, visit: • About OBI Financial Reporting |
Tax Compliance
Currently there are no Oracle Financials reports used specifically for tax compliance activities.
Travel
The following reports are available to help staff track travel related business expenses.
| Report Title | Report Description |
|---|---|
FIN_CREDIT_257_Custodian_Report FIN_IOU_265_Reimbursement_Trans FIN_IOU_266_Other_Check_Trans FIN_IOU_267_Other_Check_MP_Trans FIN_IOU_269_Advance_Transaction FIN_TCARD_301_Transaction_Report |
These ReportMart3 reports are being retired in the transition to OBI Integrated Payments and Expenditure reporting. Expense Requests and SU Card Activity dashboard reports include all Expense Requests system (e.g., expense report/reimbursements, advances, and Travel Card charges) and historical iOU transaction details in a single reporting platform. To explore all support resources on how to access OBI dashboard reports, visit: • About OBI Financial Reporting |