The generate revenue accounting events process collects revenue distribution lines in Oracle Projects and uses AutoAccounting to determine the default unearned revenue and unbilled receivables accounts. It also calculates the amounts to be distributed to the default unearned revenue and unbilled receivables accounts. Finally, the process creates accounting events in Oracle Subledger Accounting.
The process calculates unbilled receivable and unearned revenue for draft revenue in revenue transaction currency using the following attributes:
Rate type of User
Rate date as the Accrue Through Date
Rate as derived using the proration method outlined in the formulas below. The calculation uses the following formulas and excludes unrealized gains and losses:
Unbilled receivables amount in revenue transaction currency = (Unbilled receivables amount in project functional currency / Total revenue in project functional currency) * Total revenue in revenue transaction currency
Unearned revenue amount in revenue transaction currency = Total revenue amount in revenue transaction currency - Unbilled receivables amount in revenue transaction currency
If the process is able to successfully generate an accounting event, then it updates the status of the revenue distribution line to Accepted.
If the process cannot successfully determine an account or is unable to generate an accounting event, then it updates the status of the revenue distribution line to Rejected.
After the process generates revenue accounting events, you can run the process PRC: Create Accounting to create the draft or final accounting in Oracle Subledger Accounting.
The profile option PA: Interface Unreleased Revenue to GL determines whether this process includes unreleased draft revenue. See: PA: Interface Unreleased Revenue to GL, Oracle Projects Implementation Guide.
To submit the process PRC: Generate Revenue Accounting Events by itself, see: Submitting Requests.
You can submit the process as part of a streamline process. For information about streamline processes, see: Submitting Streamline Processes.
From PA Date. Enter the start date for the PA Date Range for which you want the process to select draft revenues. If you leave this parameter blank, then the process selects all draft revenues having PA Dates before the date you enter in the To PA Date process parameter.
To PA Date. Enter the end date for the PA Date Range for within which you want the process to select draft revenues. If you leave this parameter blank, then he process selects all draft revenues having PA Dates after the date you enter in the From PA Date process parameter.
Project Number. Enter the number of the project for which you want to generate revenue accounting events. If you leave this parameter blank, then the process selects all draft revenue across all projects.
The following reports show you the results of this process:
Generate Revenue Accounting Events Report: Revenue Transactions. Lists the revenue transactions associated with accounting events. For each revenue transactions, this report displays the project number, the revenue credited, the customer name, the customer agreement funding the revenue, the GL accounting date, and the total revenue amount in functional currency.
Generate Revenue Accounting Events Exception Report: Revenue Transactions. Lists any revenue transactions that were rejected during the process. This report lists the project number, draft revenue number, customer name, PA date, and rejection reason for each rejected draft revenue.