The summarize unbilled receivables/unearned revenue balances process creates summary data required for running the UBR and UER reports. The process creates summary balances for draft revenue and draft invoices in Oracle Projects. The process summarizes amounts for draft revenues for which the process PRC: Generate Revenue Accounting Events has successfully generated events. The process summarizes amounts for draft invoices that have been transferred, imported, and successfully tied back to Oracle Receivables.
The unbilled receivables and unearned revenue transactions are summarized by project, by account segment, cost center, and GL period, deriving the summary amounts used in the reports.
Before you can carry out the PRC: Summarize Unbilled Receivables/Unearned Revenue Balances process, you must do the following:
Define the General Ledger Account Key Segment that is associated with the Key Flexfield Qualifier Cost Center and the General Ledger Account Key Segment that is associated with the Key Flexfield Qualifier Account.
For more information on defining General Ledger Account Key Segments, refer to the Oracle General Ledger Implementation Guide.
Setup Self-Service environment to view the UBR and UER reports. For complete instructions on setting up your self-service environment, refer to the Oracle Self-Service Web Applications Implementation Manual.
Submit the PRC: Summarize Unbilled Receivables / Unearned Revenue Balances process from the Submit Request window.
From Project Number and To Project Number: Enter the range of project numbers that you want to include.
Note: For faster performance, enter a range of projects.
GL Period (required): Enter a GL Period for selecting draft revenue and draft invoices in Oracle Projects. The default value is derived from the system date.
Note: To create accurate balances, run your process at the end of your GL period, after transaction processing is complete.
The following reports show you the results of this process:
This report lists the unbilled receivables and unearned revenue for revenue transactions. For each revenue transactions, the report lists the project, project type, draft revenue transaction number, GL period, revenue amount, unbilled receivables amount, unearned revenue amounts, GL header ID, and the GL line ID.
This report lists the unbilled receivables and unearned revenue for draft invoices. For each draft invoice, the report lists the project number, project type, GL period, invoice amount, unbilled receivables amount, and unearned revenue amount.
This report lists the unbilled receivables and unearned revenue balances by GL period for all projects in which draft revenue or draft invoices were processed. The report shows the resulting balances of the unbilled receivables and unearned revenue by GL period for each project.
The results of the process can also be viewed online. You can export the online views to an Excel spreadsheet for further calculation, analysis, and formatting.
These online reports have an accounting view and a project view. Both of these views are included in the Project Super User and Operations Manager menus.
Project accountants can use the Accounting View reports to review all entries to UBR and UER accounts in the GL from the Oracle Projects subledger.
The following accounting view reports are available:
The report shows summary balances for selected cost centers for a given UBR or UER account.
You can click on the Details icon in the summary line, to drill down and view the unbilled receivables or unearned revenue transactions in Oracle Projects.
You can click on a selected project number in the Project Number field to view details of transactions for all the cost centers in the selected project.
The Operating Unit, Account and As of GL period fields are required. Use the following other parameters to further filter the report:
Start and End Cost Center
Project Type
Start and End Project Number
Start and End Project Name
Projects with Zero Balances: Check the box to retrieve summary amounts for projects having zero account balances.
Note: The Account parameter represents the Natural Account segment defined as the General Ledger Accounting Key Flexfield Qualifier. Cost Center parameter represents the cost center segment defined as the General Ledger Accounting Key Flexfield Qualifier.
The default sort order is Project Number and Cost Center columns in ascending order. You can click on any column in the results section of the report to sort the report in the ascending order of that column.
If project number and project name are given, project name takes precedence for retrieving the data.
This report shows UER and UBR transaction details for a selected project. You can access this report in the following ways:
From the Results section of the Unearned Revenue/Unbilled Receivables by Project, Cost Center: Accounting View report, click on the Details icon or on the project number in the Project Number field. If you click on the project number, you can view the transaction number, GL period and transaction amount for invoices, credit memos, payments, and adjustments for all cost centers in the project.
Using the Project Finance Manager responsibility in the Self Service environment.
The Operating Unit, Account and As of GL Period fields are required. Use the following other parameters to further filter the report:
Cost Center
Project Type
Project Number
Project Name
Note: The default sort order is Project Number, GL Period, Transaction Type and Transaction Number columns in the descending order. You can click on any column in the results section of the report to sort the report in the ascending order of that column.
If project number and project name are given, project name takes precedence for retrieving the data.
Project managers can use the Project View reports to review the balances of UBR and/or UER accounts on a project. The following project view reports are available:
This report shows the period-to-date summary balances for both the Unearned Revenue and Unbilled Receivable accounts for a specified GL period.
You can click on a selected project number in the Project Number field to view both the UBR period-to-date summary balance and the UER period to date summary balance for each individual cost center in the project.
The Operating Unit and As of GL Period fields are required. Use the following other parameters to further filter the report:
Project Type
Start and End Project Number
Start and End Project Name
Cost Center Filter: Show: Select one of the following filters:
All Projects
Project with Multi Cost Center
Projects with Single Cost Center
Projects with Zero Balances: Check the box to retrieve summary amounts for projects having zero UBR or UER account balances.
Note: The Cost Center parameter represents the cost center segment defined as the General Ledger Accounting Key Flexfield Qualifier. For more information on defining General Ledger Account Key Segments, refer to the Oracle General Ledger Implementation Guide.
The default sort order is Project Number column in ascending order. Click on any column in the results section of the report to sort the report in the ascending order of that column. If project number and project name are given, project name takes precedence for retrieving the data.
This report shows the period-to-date summary balances for both the Unearned Revenue and the Unbilled Receivable balances for each individual cost center in a project.
You can click on the Details icon in the summary line, to drill down and view the revenue and invoice transactions in Oracle Projects that comprise the UBR and UER balances.
You can click on a selected project number in the Project Number field to view details of revenue and invoice transactions for all the cost centers in the specific project.
You can access this report in the following ways:
From the Results section of the Unearned Revenue/Unbilled Receivables by Project, Cost Center: Project View report, click on an individual project in the Project Number field.
Use the Project Manager responsibility in the Self Service environment.
The Operating Unit and As of GL Period fields are required. Use the following other parameters to further filter the report:
Project Type
Start and End Project Number
Start and End Project Name
Cost Center Filter: Show: Select one of the following:
All Projects
Project with Multi Cost Center
Projects with Single Cost Center
Projects with Zero Balances: Check the box to retrieve summary amounts for projects having zero UBR or UER account balances.
Note: The default sort order is Project Number, Cost Center columns in the ascending order. Click on any column in the results section of the report to sort the report in the ascending order of that column.
If project number and project name are given, project name takes precedence for retrieving the data.
This report shows the invoice and revenue transactions details of UBR and UER balances in Oracle Projects. You can access this report in the following ways:
From the Results section of the Unbilled Receivable/Unearned Revenue Balance by Project, Cost Center: Project View report, click on the Details icon, or a project number in the Project Number field. If you click on the project number, data for all cost centers in the project is displayed.
Use the Project Manager responsibility in the self service environment.
The Operating Unit and As of GL Period fields are required. Use the following other parameters to further filter the report:
Project Type
Cost Center
Project Number
Project Name
Note: The default sort order is GL Period, Transaction Type, and Transaction Number columns in descending order. Click on any column in the results section of the report to sort the report in the ascending order of that column. If project number and project name are given, project name takes precedence for retrieving the data.