Summary Revenue Amounts

Oracle Fusion Cloud Project Billing calculates summary revenue during revenue generation. Summarized revenue amounts enable you to identify problems with actual revenue for a contract, contract line, or the projects associated with a contract line.

After you identify problems at the summary level, review the details to determine if there are individual transactions for which revenue was incorrectly calculated.

View the actual cost and revenue for a contract, contract line, or associated project, and compare it to the following amounts and values to review profitability:

  • Actual margin

  • Actual margin percentage

  • Budget variance

  • Budget variance percentage

  • Forecast variance

  • Forecast variance percentage

Summary Revenue Amounts

The following table lists the formulas that calculate the summary revenue amounts for a contract, contract line, or associated project.

Value

Formula

Actual margin

actual margin = (actual project revenue - actual cost)

Actual margin percentage

actual margin percentage = (actual margin * 100) / actual project revenue

Budget variance

budget variance = (actual project revenue - budget revenue)

Budget variance percentage

budget variance percentage = (budget variance * 100 / budget revenue)

Forecast variance

forecast variance = (actual project revenue - forecast revenue)

Forecast variance percentage

forecast variance percentage = (forecast variance * 100) / forecast revenue

Impact of Legal Entities and Multiple Contract Line Associations

Oracle Fusion Project Billing summarizes actual revenue by contract, using the ledger currency and accounting calendar from the primary ledger of the legal entity that owns the contract. Budget revenue, forecast revenue, and actual cost are summarized by project and task, using the ledger currency and accounting calendar from the primary ledger of the legal entity that owns the project.

For intercompany contracts only, the contract and associated project legal entities are not required to be identical, so the contract and project ledger currencies and accounting periods can be different. Therefore, actual contract revenue only is displayed for intercompany contracts. When a project or task is associated with multiple contract lines in the search results, actual project revenue, actual cost, budget revenue, and forecast revenue for that project or task is repeated for each contract line. This multiple reporting causes the totals (other than actual contract revenue) to be stated incorrectly. In this situation, review revenue and profitability by project in the Project Work Area or Project Manager dashboard.