This process calculates revenue for contract projects.
If you select Project Functional Currency and Invoice Transaction Currency as the revenue transaction currency on your multi-currency billing project, the Generate Draft Revenue process derives revenue in the invoice transaction currency using the invoice transaction currency conversion attributes that you define for the customer. If your project has multiple customers, the process generates revenue in the project functional currency for all customers, and derives revenue in the invoice transaction currency for the customer that you specify.
Note: If your project uses cost-to-cost revenue accrual, you must include burdened costs in your cost budget and revenue amounts in your revenue budget. Without these amounts, Oracle Projects cannot successfully generate revenue for your project.
The Date-Effective Funds Consumption option can affect revenue generation. See: Project and Task Attributes, Revenue and Billing Information.
To submit the process for multiple projects, use PRC: Generate Draft Revenue for a Range of Projects. To submit the process for one project, use PRC: Generate Draft Revenue for a Single Project. See Submitting Requests
Accrue Through Date. The process only selects those expenditure items and events dated on or before the date that you enter here. If you leave this parameter blank, the Generate Draft Revenue process uses the current date as the accrue through date.
The PA date is set to the revenue accrue through date if the date falls in a PA period with a status of Open of Future. If the revenue accrue through date falls in a closed period PA period, the PA date is set to the start date of the earliest open or future enterable PA period that follows the revenue accrue through date.
The Generate Draft Revenue process uses PA date to convert the revenue amounts in the billing transaction currency to revenue amounts in the project functional, project, and funding currency if the Rate Date Type conversion attribute is defined as PA/Invoice Date.
Note: When you process revenue for projects using cost-to-cost revenue accrual, the accrue through date used is the PA Date instead of the expenditure item date.
If you select both project functional currency and invoice transaction currency as your revenue transaction currency on multi-currency billing projects, the Generate Draft Revenue process derives revenue in the invoice transaction currency using the invoice transaction currency conversion attributes that you define for a customer.
From Project Number / To Project Number. Enter the range of project numbers that you want to include. You can leave either or both parameters blank. See: Entering a Project Number Range Parameter.
Project Number. (For PRC: Generate Draft Revenue for a Single Project only). Number of the project for which you want to run the process.
Adjusting Revenue Run. The default value is No. When you set the value of this parameter to Yes, the process generates revenue for only those events that have the Adjusting Revenue flag checked. See: Adjusting Revenue.
Project Type: Enter the project type for which you want to submit the process. The process generates draft revenue for all projects that belong to the specified project type.
Project Organization: Enter the project organization for which you want to submit the process. The process generates draft revenue for all projects associated with the project owning organization.
Customer Name: Enter the name of the customer for which you want to submit the process. The process generates draft revenue for all projects that have the specified customer. If you select Project Functional Currency and Invoice Transaction Currency as your revenue transaction currency for a multi-currency billing project with many customers, the process generates revenue in the project functional currency for all customers, and derives revenue in the invoice transaction currency for the customer that you specify.
Agreement Number: Enter the agreement number for which you want to submit the process. The process generates draft revenue for all projects which are funded by the specified agreement number. For multi-agreement projects, processing is done for all agreements even if you select a specific agreement number.
Note: The selected customer restricts the agreement number list. For example, if you select Customer A as a parameter, the agreement number list is restricted to only those agreements with Customer A.
Multi Currency Projects Only: The default value is No. If you set the value to Yes, the process generates draft revenue for multi-currency projects only.
Release Draft Revenue: The default value is Yes. If you set the value to No, the process generates draft revenue in an unreleased status. Otherwise, the process generates draft revenue in a released status.
Note: If you run the PRC: Generate Draft Revenue for a Range of Projects with this parameter set to Yes, the program releases existing unreleased revenue only when generating and releasing revenue for new expenditure items or events. If the program has no new expenditure items or events for which to generate additional revenue, any existing unreleased revenue is ignored.
Include Detail Report: The default value is No. If you set the value to Yes, the process generates a detailed report.
Use the rescheduling parameters to configure a process to run automatically, according to a defined schedule. You can specify rescheduling parameters when you submit the process from the Submit Request window.
The Generate Draft Revenue process creates the following reports:
The Draft Revenue Generation Exception Report. Lists all of the project draft revenues that the process was unable to successfully create during its processing. For each rejected draft revenue, the Draft Revenue Generation Exception Report displays the rejection reason.
The Draft Revenue Generation Exception (Rejected Expenditure Items Detail) Report. Created only when the process is run for all eligible projects or a group of projects. This report shows you all expenditure items that the Generate Draft Revenue process rejected during its processing. For each rejected expenditure item, the report displays the rejection reason.
Note: You can also view the results of the process in the following ways:
You can review rejection reasons from the Expenditure Items window by using the Show Field option in the Folder menu to display Revenue Distr. Rejection. See: Viewing Expenditure Items.
You can review the log file generated by the Generate Draft Revenue process to view exceptions. The log file is generated for both the Single Project and multiple project Generate Revenue processes.
The Draft Revenue Generation Exception Report (Rejected Event Detail). Created only when the process is run for all eligible projects or a group of projects. This report shows you all revenue events that the Generate Draft Revenue process rejected during its processing. For each rejected revenue event, this report displays the rejection reason.
The Draft Revenue Generation Report. Lists each draft revenue that was successfully created by the process. For each draft revenue, this report displays the project for which it was created, its draft revenue number, the number of the draft revenue, if any, that it credits, the customer number, name, and agreement providing the funding, the accrue through date used to generate the revenue, and the total amount of the draft revenue. This report also displays any generation warnings below each draft revenue.
The Draft Revenue Generation Eligibility Report. Created only when the process is run for one project. This report displays the project for which the Generate Draft Revenue process was submitted. If the process cannot create a new draft revenue for the project, the reason for the generation failure appears under the Rejection Reason column heading.
The Draft Revenue Generation Eligibility Report (Unprocessed Expenditure Items Detail). Created only when the process is run for one project. This report displays all of the specified project's expenditure items for which the process could not accrue revenue and shows information to help identify why the item did not accrue revenue. Use this information to check if the expenditure item date is on or before the accrue through date, if the item is costed, if the item is summarized (for cost revenue accrual projects), if the item is billable, and if a rejection reason like 'No labor bill rate' was encountered.
The Draft Revenue Generation Eligibility Report (Unprocessed Events Detail). Created only when the process is run for one project. This report displays all of the specified project's revenue events for which the process could not accrue revenue and shows information to help you identify why the event did not accrue revenue. Use this information to check if the event completion date is on or before the accrue through date.