This guide also applies to on-premise implementations

6Reports Customization

This chapter contains the following:

Creating and Editing Reports: Explained

Use reports to generate and print documents for internal operations, external business transactions, or legal requirements. To meet specific requirements, you may need to create or edit reports to capture different data, or present data in another way.

Report Components

Each report has components that you can customize, as described in this table:

Report Component Description Tool for Customizing

Data model

Defines the data source, data structure, and parameters for the report. Multiple reports can use the same data model. Each report has one data model.

Data model editor in the application

Layout

Defines the presentation, formatting, and visualizations of the data. A report can have multiple layouts. There are different types of layout templates, for example Excel and RTF.

Depending on the template file type:

  • XPT: Layout editor in the application

  • RTF: Microsoft Word

  • PDF: Adobe Acrobat Professional

  • Excel: Microsoft Excel

  • eText: Microsoft Word

Properties

Specifies formatting and other settings for the report.

Report editor in the application

What You Can Create or Edit

This table gives just a few examples of creating or editing reports.

Task Example

Edit the layout of a report.

Add your company logo to the report output.

Add a new layout to a report.

Design a new layout template that provides less detail than the existing template.

Edit a data model.

Add two fields to the data model used by a report so you can add those new fields to a custom layout for the report.

Create a new report based on a new data model.

Create a new data model based on data from an external system, and create reports using the custom data model.

Accessing Report Components to Customize: Points to Consider

To create or edit reports, you must access the business intelligence (BI) catalog. In the catalog, objects of type Report represent the report definition, which includes report properties and layouts. Data models are separate objects in the catalog, usually stored in subfolders called Data Models.

Accessing the BI Catalog

You can access the BI catalog in any of the following ways:

  • In the Reports and Analytics pane, click Browse Catalog to open the BI catalog, and find your report or data model in the Folders pane.

  • In the Reports and Analytics pane, find your report and select More to go to the report directly in the catalog. The data model associated with the report should be in the Data Models subfolder within the same folder as the report.

  • Sign in to the application directly (for example: http://host:port/analytics/saw.dll) to open the catalog.

  • Sign in to the BI server directly (for example: http://hostname.com:7001/xmlpserver) to open the catalog.

    • Alternatively, once you are in the catalog using another method, for example, through the Reports and Analytics pane, change the final node of the URL. For example, change (http://host:port/analytics/saw.dll) to xmlpserver. So the URL you use would be: http://host:port/xmlpserver.

Predefined Reports

A special Customize option is available only:

  • For predefined reports, not data models.

  • Through direct access to the BI server using the /xmlpserver URL. When you find your report in the BI catalog, select Customize from the More menu.

The Customize option automatically creates a custom copy of a predefined report and stores it in the Shared Folders - Custom folder within the catalog. The new report is linked to the original, so that when users open or schedule the original, they are actually using the custom version.

If you don't have access to the Customize option or don't want the original version linked to the new report, then make a copy of the predefined report and save it in the Custom folder.

Predefined Data Models

Don't edit predefined data models. Instead, copy the data model into the Custom folder and edit the copy.

Using the Customize Option for Predefined Reports: Points to Consider

The Customize option automatically creates a custom copy of a predefined report and stores it in the Shared Folders - Custom within the business intelligence (BI) catalog. The custom copy includes the report definition, folder structure, and original report permissions, and is linked internally to the original report. You can edit the custom copy of the report, leaving the original report intact. When users open or schedule the original report, they are actually using the custom version.

Benefits of the Customize Option

In addition to conveniently copying a predefined report to the Custom folder, the Customize option:

  • Makes it unnecessary to update processes or applications that invoke the report. For example, if the original report is set up to run as a scheduled process, you don't need to change the setup. When users submit the same scheduled process, the custom report runs instead of the original.

  • Automatically copies the security settings of the original report.

  • Removes the risk of patches overwriting your edits. If a patch updates the original report, the custom report is not updated in any way.

    Note: The custom report still references the original data model. The data model is not copied. A patch that updates the data structure of the data model might affect your custom report.

Accessing the Customize Option

To access the Customize option:

  1. Sign in to the BI server (for example, http://hostname.com:7001/xmlpserver).

  2. In the Folders pane, select the predefined report.

  3. Select Customize from the More menu for the report.

  4. The copied report in the Custom folder opens, so proceed to edit this report.

To edit the custom report again later, you don't need to be in the BI server. Just go to the BI catalog and either:

  • Select the Customize or Edit option for the original report.

  • Find your custom report in the Custom folder and select Edit.

Links Between Original and Custom Reports: Points to Consider

The Customize option for predefined reports creates a custom copy of the report that is linked to the original. Consider the following points when you work with both the original and custom versions.

Maintaining the Link Between Reports

The link between the predefined and custom report is based on the name of the custom report and its location within the Custom folder in the business intelligence (BI) catalog.

  • If you manually create a report with the same name as a predefined report, and give it the same folder path under the Custom folder, then the new report becomes a custom version of the original. It would be as if you had used the Customize option to create the custom report.

  • You can edit the custom report so that it uses a different data model. But if the original data model is updated later, then your custom report doesn't benefit from the change.

Important: The link to the original report breaks if you rename the custom or original report.

Tasks Performed on Original Reports

This table describes what happens when you use the original report and a corresponding custom report exists.

Task Performed on the Original Report Result When There's a Custom Report

Open

Opens the custom report.

Schedule

Creates a report submission for the custom report.

Edit

Edits the custom report.

Delete

Deletes the original report only. If you delete the custom report, the original report is not deleted.

Copy

Copies the original report.

Cut and Paste

Cuts and pastes the original report.

Rename

Renames the original report. The custom report name is not changed.

Caution: This breaks the link between the original and custom reports.

Download

Downloads the custom report.

Customize

Edits the custom report.

History

Opens the job history of the custom report.

Layouts

Creating and Editing Report Layouts: Overview

The layout determines what and how data is displayed on report output. Each report has at least one layout template. This topic describes the following aspects of report templates:

  • Layout templates

  • Layout template types

  • Overall process of managing layouts

  • Deleting layout templates

Layout Templates

To customize a layout, you edit the layout template, which:

  • Defines the presentation components, such as tables and labeled fields.

  • Maps columns from the data model to these components so that the data is displayed in the right place.

  • Defines font sizes, styles, borders, shading, and other formatting, including images such as a company logo.

Layout Template Types

There are a few types of template files to support different report layout requirements.

  • RTF: Rich text format (RTF) templates created using Microsoft Word.

  • XPT: Created using the application's layout editor, these templates are for interactive and more visually appealing layouts.

  • eText: These templates are specifically for Electronic Data Interchange (EDI) and electronic funds transfer (EFT) information.

You can also create and edit other types of templates using Adobe PDF, Microsoft Excel, Adobe Flash, and XSL-FO.

Overall Process to Create or Edit Layouts

Editing or creating report layout, for example using Microsoft Word or the layout editor, involves making the actual changes to the template file. But that task is just one part of the entire process for customizing layouts.

  1. Copy the original report and save the custom version in Shared Folders - Custom in the business intelligence (BI) catalog. You create or edit templates for the custom copy of the report.

    Tip: You can use the Customize option if the original is a predefined report.
  2. Review report settings for online viewing.

  3. Generate sample data for the report.

  4. Edit or create the layout template file.

  5. Upload the template file to the report definition. Skip this step if you're using the layout editor.

  6. Configure the layout settings.

Deleting Layout Templates

To remove a layout template for a report:

  1. Select your report in the BI catalog and click Edit.

  2. In the report editor, click View a list.

  3. Select the layout template and click Delete.

Making Reports Available for Online Viewing: Procedure

Some reports are set up so that you can only view them through another application or submit them as scheduled processes. To view your report online while you're editing it, you must define a few settings. When you're done editing your report, make sure that you reset these settings as needed.

Updating Report Properties

  1. Select your report in the business intelligence catalog and click Edit.

  2. In the report editor, click Properties at the top of the page.

  3. In the Report Properties dialog box, select Run Report Online and deselect Report is Controlled by External Application.

Updating Layout Settings

  1. Back in the report editor, click View a list.

  2. Make sure that the View Online check box is selected.

Generating Sample Report Data: Procedure

Depending on the type of report layout changes you're making, sample data can be required or optional. You generate sample data, and then load it for use with your layout so that you can map data fields to layout components. For example, for the Start Date table column in your layout, you can set it so that the data displayed in that column comes from the Start Date field in the sample data.

You can generate sample data from the:

  • Report data model

  • Report viewer

  • Scheduler

Generating Sample Data from the Data Model

Follow these steps:

  1. Select your data model in the business intelligence (BI) catalog and click Edit.

    Tip: If you're not sure which data model is the source for your report, find the report in the catalog and click Edit. The data model is displayed in the upper left corner of the report editor.
  2. In the data model editor, click View Data.

  3. Enter values for any required parameters, select the number of rows to return, and click View.

  4. To save the sample data to the data model, click Save As Sample Data.

    If you're designing an RTF template, click Export to save the file locally.

  5. Save the data model.

Saving Sample Data from the Report Viewer

For reports that are enabled for online viewing, you can save sample data from the report viewer:

  1. Select the report in the BI catalog.

  2. Click Open to run the report in the report viewer with the default parameters.

  3. On the Actions menu, click Export, then click Data.

  4. Save the data file.

Saving Sample Data from the Scheduler

For reports that are enabled for scheduling (not necessarily as a scheduled process), you can save sample data from the scheduler:

  1. Select the report in the BI catalog.

  2. Click Schedule.

  3. On the General tab, enter values for any report parameters.

  4. On the Output tab, ensure that Save Data for Republishing is selected.

  5. Click Submit.

  6. Open the Report Job History page.

  7. On the global header, click Open, then click Report Job History.

  8. Select your report job name in the Job Histories table.

  9. On the details page, under Output and Delivery, click the XML Data Download icon button.

New Reports

Creating Custom Reports: Procedure

Create a custom report when the predefined reports don't provide the data you need. Or, if you want to use a predefined data model, and also want to change other aspects of the report other than layout. Save your custom report to Shared Folders - Custom in the business intelligence catalog.

Creating a Report

  1. Open the Reports and Analytics work area, or the Reports and Analytics pane if available in other work areas.

  2. Click Create and select Report.

  3. Select the data model to use as the data source for your report.

  4. Continue with the wizard to create the report layout, or choose to use the layout editor and close the wizard.

  5. Define the layout for the report.

  6. Click the Properties button in the report editor to set specific formatting, caching, and processing options for your report.

Setting Up Access

You or your administrator can:

  • Create a job definition so that users can run your custom report as a scheduled process.

  • Set up the report for scheduling in the Reports and Analytics pane.

  • Secure general access to your report and its job definition, if any.

Changing the Branding Logo in a Predefined Oracle Fusion Project Performance Reporting RTF Report Template: Worked Example

The Update Project Performance Data report layout includes a standard Oracle logo in the report header. You want to replace the Oracle logo with your own logo.

The following table summarizes the key decisions for this scenario.

Decisions to Consider In This Example

What version of Microsoft Word are you using?

Microsoft Word 2007

What image do you want to use as your logo?

O_FusionApps_ProjectPortfolioMgmt_clr.gif

Which data model do you need to download sample report data from?

SummarizationDM

Do you want to preview the changed template?

Yes

Prerequisite

  1. Install the Template Builder for Word add-in, and download sample data (save it locally).

Changing the Logo

To change the logo in the report output:

  1. Select the Update Project Performance Data Execution Report in the BI catalog and click Edit.

  2. In the report editor, click the Edit link of the Update Project Performance Data Execution Report layout to download the RTF file.

  3. Open the RTF file in Microsoft Word.

  4. In the BI Publisher tab, click Sample XML in the Load Data group, and select sample data that was saved from the data model.

  5. In the template, delete the Oracle logo and the text Fusion Projects and Project Performance Reporting.

  6. On the Insert tab in the Illustrations group, click Picture.

  7. Select the O_FusionApps_ProjectPortfolioMgmt_clr.gif file and insert it into the Word document.

  8. Resize the image if you need to.

  9. If the template file includes section breaks, you must insert the new logo for each section header.

  10. In the Oracle BI Publisher tab, in the Preview group, click PDF. You can preview the PDF output that's generated with the sample data that you loaded.

Reports

Process Output Reports: Overview

This topic lists the business intelligence publisher reports available in Oracle Project Portfolio Management. You can use these reports to review your processed data in a predefined format and print them.

The following table lists the available process output reports.

Report Name Report Description Process Name Intended User

Absence Management Transfer Processing Report

Report for the process that loads new, updated, or withdrawn absence records from Oracle Absence Management to Project Execution Management.

Initiate Absence Records Transfer to Oracle Fusion Project Execution

Resource Manager

Accounting and Project Accounting Periods Close Exceptions Report

Report for the processes that close accounting or project accounting periods.

Also displays unprocessed transactions and conditions that prevent the closing of accounting or project accounting periods.

Close Accounting Period

Close Project Accounting Period

Accounting Period Close Exceptions Report

Project Accounting Period Close Exceptions Report

Project Accountant

Grants Accountant

Adjust All Expenditure Items Execution Report

Report for the process that provides a summary of the adjusted expenditure items and adjustment exceptions.

Adjust All Expenditure Items

Project Accountant

Grants Accountant

Billing Event Upload Error Report

Report for the process that creates contract billing events in Oracle Project Billing based on the data loaded into the open interface table.

Import Project Billing Events

Project Billing Specialist

Build New Organization Burden Multipliers Execution Report

Report for the process that adds burden multipliers for a new organization to burden schedules after the organization is added to the organization hierarchy.

Build New Organization Burden Multipliers

Project Accountant

Grants Accountant

Change Project and Task Organizations Execution Report

Report for the process that reassigns all projects in one organization to a different organization, or changes the organization on a single project and optionally cascades the changes to the project tasks.

Used particularly when the enterprise is undergoing reorganization.

Change Project and Task Organizations

Business Unit Administrator

Create Periodic Capital Events Execution Report

Report for the process that groups unprocessed assets and costs for capital projects based on the in-service date, expenditure item date, and project, and then associates the groups of unprocessed assets and costs with the event period.

Create Periodic Capital Events

Project Accountant

Grants Accountant

Delete Allocation Transactions Execution Report

Report for the process that deletes all transactions for a draft allocation.

Delete Allocation Transactions

Project Accountant

Grants Accountant

Delete Capitalized Interest Transactions Execution Report

Report for the process that deletes the selected capitalized interest batch that is in draft success status.

Delete Capitalized Interest Transactions

Project Accountant

Grants Accountant

Delete Cost Transactions Report

Report for the process that deletes rejected or all unprocessed project cost transactions in an expenditure batch.

Delete Cost Transactions

Project Accountant

Project Manager

Delete Unreleased Invoices Execution Report

Report for the process that deletes draft, approved, and rejected project contract invoices.

Delete Draft, Approved, and Approval Rejected Invoices

Project Billing Specialist

Grants Accountant

Denormalize Organization Hierarchies Execution Report

Report for the process that converts all hierarchical lists of organizations specified in the business unit implementation options into flat lists to enhance performance throughout the Project Financial Management application.

Denormalize Organization Hierarchies

Project Application Administrator

Generate Borrowed and Lent Amounts Execution Report

Report for the process that creates borrowed and lent distributions for cross-charge transactions within a legal entity.

Generate Borrowed and Lent Amounts: Generate Output Report

Project Accountant

Grants Accountant

Export Invoice Data Report

Report for the process that exports released project contract invoice details to third-party receivables applications.

Export Invoice Details

Project Billing Specialist

Export Revenue Data Report

Report for the process that exports project contract revenue distributions to third-party general ledger applications.

Export Revenue Details

Project Billing Specialist

Federal Financial Report

Federal report that tracks the summary transactions for an award, the amount spent or received, and the outstanding obligation amount.

Generate Federal Financial Report

Grants Administrator

Fusion Projects Coexistence Cross-Charge Data Report

Report for the process that extracts cross-charge distributions for accounting in third-party applications. The export status of such cross-charge distributions is updated in the application.

Extract Cross-Charge Distributions for External Accounting

Project Accountant

Fusion Projects Coexistence Data Output Report

Report for the process that extracts cost distributions for accounting in third-party applications. The export status of such cost distributions is updated in the application.

Extract Cost Distributions for External Accounting

Project Accountant

Generate Allocations Execution Report

Report for the process that generates an allocation for the specified allocation rule.

Generate Allocations

Project Accountant

Grants Accountant

Generate Asset Lines Execution Report

Report for the process that creates summarized asset lines for capital assets and retirement adjustment assets based on the asset line grouping method defined for the project.

Generate Asset Lines

Project Accountant

Grants Accountant

Generate Burden Costs Execution Report

Report for the process that summarizes burden costs for expenditure items and then creates and processes separate expenditure items for burden costs.

Generate Burden Costs

Project Accountant

Grants Accountant

Generate Capitalized Interest Transactions Execution Report

Report for the process that calculates capitalized interest and generates transactions for eligible projects and tasks.

Generate Capitalized Interest Transactions

Project Accountant

Grants Accountant

Generate Financial Plan Amounts Execution Report

Report for the process that generates working versions of budgets or forecasts based on existing financial or project plans.

Generate Financial Plan Amounts

Project Manager

Generate Invoices Execution Report

Report for the process that creates invoices for project contract customers according to contractual terms.

Generate Invoices

Project Billing Specialist

Grants Accountant

Generate KPI Values Execution Report

Report for the process that generates KPI values and determines overall project health status.

Generate KPI Values

Project Manager

Generate Revenue Execution Report

Report for the process that recognizes project contract revenue according to contractual terms by creating revenue distributions.

Generate Revenue

Project Accountant

Grants Accountant

Identify Cross-Charge Transactions Execution Report

Report for the process that identifies cross-charge transactions and classifies them as intercompany or borrowed and lent.

Identify Cross-Charge Transactions: Generate Output Report

Project Accountant

Grants Accountant

Project Billing Specialist

Import Costs Execution Report

Report for the process that creates expenditure items and cost distributions for the transactions in the open interface table.

Import Costs

Project Accountant

Grants Accountant

Import Awards Report

Report to track the status of the Import Awards process that imports award data from the open interface table.

The award data includes creating of awards, award projects, award funding, and other related details.

Import Awards

Grants Administrator

Import Project Budget Execution Report

Report for the process that imports budget versions from the open interface table.

Displays the list of budget versions that are imported successfully and error details for the rejected budget versions.

Budget Import Execution Report

Project Application Administrator

Project Integration Specialist

Import Project Enterprise Resources Execution Report

Report for the process that imports project enterprise resources from the open interface table and creates project enterprise resources.

Import Project Enterprise Resources

Project Administrator

Import Project Plan Execution Report

Report for the process that imports projects and tasks from the open interface table and creates projects and tasks.

Import Project Plan

Project Manager

Project Administrator

Project Integration Specialist

Import Project Report

Report for the process that imports projects from the open interface table.

Displays the list of projects that are imported successfully and error details for the rejected projects.

Import Projects

Project Administrator

Grants Administrator

Import Project Resource Assignments Execution Report

Report for the process that imports project resource assignment data from the open interface table and creates project resource assignments.

Import Project Resource Assignments

Resource Manager

Import Project Resource Requests Execution Report

Report for the process that imports project resource request data from the open interface table and creates project resource requests.

Import Project Resource Requests

Project Administrator

Import Project Tasks Report

Report for the process that imports project tasks from the open interface table.

Displays the list of project tasks that are imported successfully and error details for the rejected project tasks.

Import Project Tasks

Project Administrator

Grants Administrator

Import Resource Actual Hours Execution Report

Report for the process that imports resource actual hours data from the open interface table and creates time transactions.

Import Resource Actual Hours

Project Administrator

Import Resource Pools and Memberships Execution Report

Report for the process that imports resource pool and pool membership data from the open interface and creates resource pools and memberships.

Import Resource Pools and Memberships

Implementation Administrator

Resource Manager

Maintain Project Performance Data Execution Report

Report for the process that improves performance during project performance data summarization by purging unused or deleted dimension members and summaries, reordering data, merging Oracle Essbase incremental slices, and optionally deleting project performance data.

Maintain Project Performance Data

Project Application Administrator

Open Accounting and Project Accounting Periods Execution Report

Report for the processes that update the status of the accounting or project accounting periods to open.

Open Accounting Period

Open Project Accounting Period

Project Accountant

Grants Accountant

Reclassify Billing Offset Balances Execution Report

Report for the process that creates reclassification accounting transactions to effectively net the unbilled receivables and deferred revenue balances together into a single balance.

Reclassify Billing Offset Balances

Project Accountant

Grants Accountant

Recalculate Burden Cost Amounts Execution Report

Report for the process that identifies expenditure items impacted by a burden schedule version change and processes the resulting burden cost recalculation adjustments.

Recalculate Burden Cost Amounts

Project Accountant

Grants Accountant

Release Allocation Transactions Execution Report

Report for the process that release and processes allocation and offset transactions for a draft allocation.

Release Allocation Transactions

Project Accountant

Release Capitalized Interest Transactions Execution Report

Report for the process that releases a capitalized interest batch that is in draft success status and creates expenditure items for the interest transactions.

Release Capitalized Interest Transactions

Project Accountant

Grants Accountant

Reverse Allocation Transactions Execution Report

Report for the process that creates and processes transactions to reverse a released allocation.

Reverse Allocation Transactions

Project Accountant

Grants Accountant

Reverse Capitalized Interest Transactions Execution Report

Report for the process that reverses a capitalized interest batch that is in released status and creates reversal transactions.

Reverse Capitalized Interest Transactions

Project Accountant

Grants Accountant

Sweep Transaction Accounting Events Execution Report

Report for the process that sweeps unaccounted transactions into the next open or future-enterable accounting period so that the current period can be closed.

Sweep Transaction Accounting Events

Project Accountant

Grants Accountant

Transfer Assets to Oracle Fusion Assets Execution Report

Report for the process that creates one additional line for each capital asset line or retirement cost line in Oracle Project Costing and transfers these lines to Oracle Assets to become fixed assets or group retirement reserve adjustments.

Transfer Assets to Oracle Fusion Assets

Project Accountant

Grants Accountant

Transfer Invoice Details to Receivables Execution Report

Report for the process that transfers released project contract invoices to the Oracle Receivables interface tables.

Transfer Invoice Details to Receivables

Project Billing Specialist

Grants Accountant

Update Asset Details from Oracle Fusion Assets Execution Report

Report for the process that identifies assets and asset lines. Updates asset number and asset period in which these assets and asset lines are posted.

Update Asset Details from Oracle Fusion Assets

Project Accountant

Grants Accountant

Update Financial Project Plan and Progress Execution Report

Report for the process that generates working versions of budgets or forecasts based on existing financial or project plans.

Update Financial Project Plan and Progress

Project Manager

Project Administrator

Update Invoice Details from Receivables Execution Report

Report for the process that identifies whether project contract invoices are successfully transferred to the Oracle Receivables application, updates the receivables invoice number in the Project Financial Management application, and triggers currency conversion and summarization.

Update Invoice Details from Receivables

Project Billing Specialist

Grants Accountant

Update Project Contract Performance Data Execution Report

Report for the process that summarizes contract revenue and billing data for project performance reporting.

Update Project Contract Performance Data

Project Manager

Update Project Performance Data Execution Report

Report for the process that summarizes project cost, budget, forecast, and commitment data for project performance reporting.

Update Project Performance Data

Project Manager

Project Administrator

Update Project Plan Data Execution Report

Report for the process that updates the project plan with summarized amounts from actual cost transactions.

Update Project Plan Data

Project Manager

Update Resource Rates for Project Enterprise Resources Execution Report

Report for the process that updates project enterprise resource rates from resource rate schedules.

Update Resource Rates for Project Enterprise Resources

Resource Manager

Update Work Type Execution Report

Report for the process that provides a summary of the number of updated objects with work type details.

The updated objects are projects, tasks, expenditure items, and cost distributions.

Update Work Type

Project Administrator

Accounting and Project Accounting Periods Close Exceptions Reports: Explained

This topic provides an overview of the Accounting and Project Accounting Periods Close Exceptions reports.

Overview

You can review the unprocessed transactions and other conditions that prevent accounting or project accounting periods from being closed by using the Accounting and Project Accounting Periods Close Exceptions reports. Multiple reports are grouped under the Accounting and Project Accounting Periods Close Exceptions reports as listed below.

  • Close Accounting Period Execution Report

  • Close Pending Accounting Period Execution Report

  • Close Project Accounting Period Execution Report

  • Close Pending Project Accounting Period Execution Report

  • Accounting Period Close Exceptions Report

  • Project Accounting Period Close Exceptions Report

Key Insights

These reports answer the following business questions:

  • What needs to be done before I can close the periods?

  • Are there any issues which will prevent me from closing the periods?

  • Which unprocessed transactions can prevent the periods from being closed?

Frequently Asked Questions

The following table lists the frequently asked questions about these reports.

FAQ Answer

How do I find these reports?

  • Reports and Analytics - Shared Folders - Projects - Project Cost - Accounting

  • Cost Work Area - Tasks - Reporting

  • Revenue Work Area - Tasks - Reports

How do I generate these reports?

Using the following processes:

  • Close Accounting Period

  • Close Project Accounting Period

  • Accounting Period Close Exceptions Report

  • Project Accounting Period Close Exceptions Report

Who uses these reports?

  • Grants Accountant

  • Project Accountant

When do I use these reports?

When you need to close accounting or project accounting periods.

What can I do with these reports?

You can:

  • Confirm that the status of the accounting period has been updated to close or close pending.

  • Confirm that the status of the project accounting period has been updated to close or close pending.

  • Identify unprocessed cost transactions, unaccounted cost transactions, and transactions which exist in account payables but haven't been imported into project costing that prevent accounting and project accounting periods from being closed.

What type of reports are these?

Oracle Business Intelligence Publisher

Process Parameters for the Reports

The following table lists the parameters you must provide for the various processes that generate these reports.

Report Process Process Parameters Values

Close Accounting Period Execution Report

Close Accounting Period

  • *Ledger

  • *Processing Action

  • *Period

  • Report Style

  • Ledger name from list of values

  • Accounting period close

  • Accounting period for the ledger from list of values

  • Detail

    Summary

Close Pending Accounting Period Execution Report

Close Accounting Period

  • *Ledger

  • *Processing Action

  • *Period

  • Report Style

  • Ledger name from list of values

  • Accounting period close pending

  • Accounting period for the ledger from list of values

  • Detail

    Summary

Close Project Accounting Period Execution Report

Close Project Accounting Period

  • *Ledger

  • *Processing Action

  • *Period

  • Report Style

  • Ledger name from list of values

  • Project accounting period close

  • Project accounting period for the ledger from list of values

  • Detail

    Summary

Close Pending Project Accounting Period Execution Report

Close Project Accounting Period

  • *Ledger

  • *Processing Action

  • *Period

  • Report Style

  • Ledger name from list of values

  • Project accounting period close pending

  • Project accounting period for the ledger from list of values

  • Detail

    Summary

Accounting Period Close Exceptions Report

Accounting Period Close Exceptions Report

  • *Ledger

  • *Period

  • Report Style

  • Transaction Category

  • Ledger name from list of values

  • Accounting period for the ledger from list of values

  • Detail

    Summary

  • Cross-charge transactions

    Expenditure transactions

    Inventory transactions

    Receipt accrual transactions

    Revenue transactions

    Supplier invoice transactions

Project Accounting Period Close Exceptions Report

Project Accounting Period Close Exceptions Report

  • *Business Unit

  • *Period

  • Report Style

  • Transaction Category

  • Business unit name from list of values

  • Project accounting period for the business unit from list of values

  • Detail

    Summary

  • Cross-charge transactions

    Expenditure transactions

    Inventory transactions

    Receipt accrual transactions

    Revenue transactions

    Supplier invoice transactions

The following processes always trigger the Validate Pending Inventory and Receipt Transactions process:

  • Close Accounting Period

  • Close Project Accounting Period

The following processes for inventory or receipt accrual transactions always trigger the Validate Pending Inventory and Receipt Transactions process:

  • Accounting Period Close Exceptions Report

  • Project Accounting Period Close Exceptions Report

The following processes have the processing mode set to Update:

  • Close Accounting Period

  • Close Project Accounting Period

The following processes have the processing mode set to Review:

  • Accounting Period Close Exceptions Report

  • Project Accounting Period Close Exceptions Report

Federal Financial Report: Explained

This topic provides an overview of the Federal Financial Report.

Overview

You can utilize the Federal Financial Report to view and print award financial information in a standard layout defined by the federal agency. Using this report you can track the summary transactions for an award, the amount spent or received, and the outstanding obligation amount.

Key Insights

This report answers the following business questions:

  • What is the cumulative amount of actual cash received that you need to report to the federal agency?

  • What is the cumulative amount of federal fund disbursements that you need to report to the federal agency?

  • What is the total funds authorized, total expenditures, and total unliquidated obligation that you need to report to the federal agency?

Frequently Asked Questions

The following table lists the frequently asked questions about this report.

FAQ Answer

How do I find this report?

Report and Analytics - Shared Folders - Projects - Grants Management - Award

How do I generate this report?

Using the Federal Financial Report process

Who uses this report?

Grants Administrator

When do I use this report?

When you need to view and print award financial information in the standard federal format.

What can I do with this report?

You can view the following information and print the report.

  • Federal agency details

  • Recipient details

  • Project or grant period

  • Transactions:

    • Federal cash amount

    • Federal expenditures and unobligated balance

    • Recipient share

    • Program income

What type of report is this?

Oracle Business Intelligence Publisher

Process Parameters for the Report

The Federal Financial Report process accepts the following parameters:

Parameter Values

* Generate Report

  • Multiple awards

  • Single award

* Business Unit

List of values, for example, Vision City Operations

* Award Name

List of values for the selected business unit, for example, Oncology Research Award

Sponsor

List of values of federal sponsors

You must enter a value for this parameter if you choose to generate the report for multiple awards.

Institution

List of values defaulted to selected business unit

You must enter a value for this parameter if you choose to generate the report for multiple awards.

* Certifying Official

List of values, for example, Amy Marlin

* Report Date

Default value set to current date

* Period End Date

Date, for example, 11/11/2014

* Report Type

  • Annual

  • Final

  • Quarterly

  • Semiannual

Total Recipient Share Required

Amount, for example, 1,000.000

Total Federal Program Income

Amount, for example, 1,000.000

Program Income Expended in Accordance with the Deduction Alternative

Amount, for example, 1,000.000

Program Income Expended in Accordance with the Addition Alternative

Amount, for example, 1,000.000

Comments

Text notes

Preview Invoice Report: Explained

This topic provides an overview of the Preview Invoice report.

Overview

You can review invoice information in a specific format using the Preview Invoice feature in the Invoices work area before printing the invoice or sending it to account receivables. To preview the invoice, you must select the:

  • Invoice format template in which you want to preview the invoice. For example, Services Fusion Invoice Report, Services Standard Invoice Report, and so on.

    You can create your own format templates for your invoices.

  • Output format in which you want to preview the invoice. For example, HTML, PDF, RTF, and so on.

    To generate the Preview Invoice report in PDF format, you must install Adobe Acrobat Reader. You can download it from http://adobe.com.

Key Insights

This report answers the following business questions:

  • Which cost transactions and billing events are billed through the invoice?

  • Are the transactions billed at the correct rates?

  • Are the invoice line descriptions well formatted and do they provide the requested information?

Frequently Asked Questions

The following table lists the frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics - Shared Folders - Projects - Project Billing

How do I generate this report?

Invoices Work Area - Invoice Processing Status:

  • Draft Invoices - Actions - Preview

  • Submitted Invoices - Actions - Preview

  • Released Invoices - Actions - Preview

Alternatively, click the Preview button on Draft Invoices, Submitted Invoices, and Released Invoices tabs in the Invoice Processing Status region of the Invoices work area.

Who uses this report?

  • Grants Accountant

  • Project Billing Specialist

When do I use this report?

When you need to preview the invoice before printing or sending it to account receivables.

What can I do with this report?

You can view the following information:

  • Contract terms

  • Due date

  • Invoice date

  • Invoice line details

  • Project summary

  • Total billed amount

What type of report is this?

Oracle Business Intelligence Publisher

You must select a single invoice to generate the Preview Invoice report. You can't generate the report if you select multiple invoices in the Invoices work area.

Preview SF270 Report: Explained

This topic provides an overview of the Preview SF270 federal report.

Overview

You can use the Preview SF270 report to request only for reimbursements on federal grant awards which aren't sponsored through letters of credit.

Key Insights

This report answers the following business question:

  • What is the reimbursement amount to request, as of a certain period, from the federal agency?

Frequently Asked Questions

The following tables lists the frequently asked questions about this report.

FAQ Answer

How do I find this report?

Reports and Analytics - Shared Folders - Projects - Project Billing

How do I generate this report?

  • Using the Generate Invoices process

  • Manage Invoices - Review SF 270

Who uses this report?

  • Grants Accountant

  • Project Billing Specialist

When do I use this report?

When you need to:

  • Request for reimbursements on federal grant awards which aren't sponsored through letters of credit

  • Display current and previously billed transactions, and cost sharing details in a standard federal format

What can I do with this report?

You can view the following information in the report:

  • Bill From and Bill To

  • Type of payment requested

  • Basis of request

  • Federal sponsoring agency and organization to which the SF270 invoice is submitted

  • Federal grant or other identification number assigned by the federal agency

  • Partial payment request number

  • Employer identification number

  • Recipient account number

  • Period covered by the request

  • Recipient organization name and address

  • Federal amount of reimbursement

  • Total program outlay to date

  • Cumulative Program Income

  • Estimated net cash outlay for advance period

  • Federal and non-Federal share of the cost

  • Additional notes

What type of report is this?

Oracle Business Intelligence Publisher

Prerequisites

Before you can generate and review your invoice in the SF270 report format, you must:

  • Implement Grants Management application for the business unit to which the invoice contract belongs.

  • Select SF270 as the invoice format in the contract bill plan.

  • Create your invoice contract as an award contract.

  • Select only a single invoice to preview.

Reclassify Billing Offset Balances Execution Report: Explained

This topic provides an overview of the Reclassify Billing Offset Balances Execution Report.

Overview

You can utilize the Reclassify Billing Offset Balances Execution Report to review the reclassification of accounting transactions to effectively net unbilled receivables and deferred revenue balances together into a single balance.

Key Insights

This report answers the following business questions:

  • What are the summary results of the reclassify billing offset balances process?

  • What errors were encountered attempting to reclassify billing offset balances?

  • What billing offset reclassification accounting transactions were successfully created by the process?

Frequently Asked Questions

The following table lists the frequently asked questions about this report.

FAQ Answer

How do I find this report?

Report and Analytics - Shared Folders - Projects - Project Revenue

How do I generate this report?

Using the Reclassify Billing Offset Balances process from:

  • Revenue Work Area - Tasks - Accounting

  • Scheduled Processes - Schedule New Process

Who uses this report?

  • Grants Accountant

  • Project Accountant

When do I use this report?

When you need to group the unbilled receivables and deferred revenue balances into a single balance.

What can I do with this report?

You can view the following information and print the report.

  • Reclassification errors

  • Reclassification warnings

  • Successful reclassifications

What type of report is this?

Oracle Business Intelligence Publisher

Process Parameters for the Report

The Reclassify Billing Offset Balances process accepts the following parameters.

Parameter Values

*Business Unit

List of values, for example, Vision Operations

*Accounting Period

List of values, for example, 2009-AUG

Contract Type

List of values

Revenue Method Classification

  • Rate Based

  • Amount Based

  • Percent Complete

  • Percent Spent

  • As Incurred

  • As Billed

Contract Number

List of values

Contract Line Number

List of values

*Generate Success Report

  • Yes

  • No

Sweep Transaction Accounting Events Execution Report: Explained

This topic provides an overview of the Sweep Transaction Accounting Events Execution Report.

Overview

You can utilize the Sweep Transaction Accounting Events Execution Report to review unaccounted transactions that are moved into the next open or future-enterable accounting period so that the current period can be closed.

Key Insights

This report answers the following business questions:

  • Are there transactions which need to be accounted before I can close the period?

  • If I run the Sweep Transaction Accounting Events process, which transactions are moved from the current period into the next open period?

  • What's the result of the Sweep Transaction Accounting Events process?

Frequently Asked Questions

The following table lists the frequently asked questions about this report.

FAQ Answer

How do I find this report?

Report and Analytics - Shared Folders - Projects - Project Cost - Accounting

How do I generate this report?

Using the Sweep Transaction Accounting Events process from:

  • Revenue Work Area - Tasks - Accounting

  • Scheduled Processes - Schedule New Process

Who uses this report?

  • Grants Accountant

  • Project Accountant

When do I use this report?

When you need to close a period that has unaccounted transactions.

What can I do with this report?

You can review the output of the Sweep Transaction Accounting Events process and print the report.

What type of report is this?

Oracle Business Intelligence Publisher

Process Parameters for the Report

The Sweep Transaction Accounting Events process accepts the following parameters.

Parameter Values

*Ledger

List of values, for example, Vision City

Business Unit

List of values, for example, Vision Operations

*Accounting Period

List of values, for example, Jan-06

Source Application

  • Project Billing

  • Project Costing

*Process Mode

  • Review

  • Update