FAQ: Revenue in GL vs PPM
This article covers Frequently Asked Questions on Revenue in General Ledger versus Project Portfolio Management (PPM).
- Oracle's General Ledger includes Assets, Liabilities, Equity, Revenue and Expenses.
- With the exception for Sponsored Projects, Revenue is posted on the General Ledger usually at the Project level.
- Task is not a field in the General Ledger.
- Task is only in PPM, which is a subledger to the General Ledger, which means that data in PPM flows into General Ledger.
- PPM is designed to track costs (expenses) and have budgets for performance management tracking.
Q: How do you see external revenue on a Project in General Ledger?
- Run the General Ledger Transaction Details report via Business Analytics Hub (BAH) > General Ledger Panorama > tab General Ledger Transaction Details
- Enter your periods in scope and chart string parameters.
- Review Revenue Accounts per your discretion.
- To include all Revenue Accounts:
- In the Account(s) field, click on the drop down > search > Remove All Column Values from the selected right pain and include all Accounts that start with 4 (Revenue Accounts start with 4).
Q: What type of revenue can be seen in PPM?
- Overall, PPM's inherent functionality is to track costs (expenses).
- The scenarios where revenue can be seen in PPM.
- Approved recharges post internal revenue (recharge cost recovery) in PPM as negative project costs because it offsets the recharge expense in Project Costs.
- PPM generates external revenue on contracts.
- Program Income is reflected in PPM Project Costs as negative costs.
Q: What is internal revenue (cost recovery)? And why is it in PPM?
- Internal revenue (which is actually cost recovery) is referring to revenue (recovery) a UCSD department receives from another UCSD department for providing services/products.
- This is in PPM transacted under Recharge Accounts that are prefixed with 77 instead of inherent Expense Accounts which are prefixed with 5.
- The net impact of recharges on UC system will always be zero because one UCSD department will incur an expense for receiving a service/product and another UCSD department will incur the equivalent cost recovery (internal revenue) for being the service provider.
- Since PPM module for Oracle is used for tracking costs/expenses, recharges are monitored under the Expense hierarchy.
Q: Can all revenue on Projects be seen at the task level?
- No, revenue that is in PPM Project Costs can be seen at the Task level.
- All other revenue transactions are seen in the General Ledger at the Project level.
- External revenue on contracts can be seen at the Task level.
Q: Will external revenue on a contract be on Manage Project costs or Project Cost Reports?
Q: Where in PPM can external revenue from a contract be seen?
- Go to Contract Management > Contracts > Enter Contract number
- Click on the Contract > Select Lines tab > Associated Projects tab, see screenshot below
Q: Will revenue generated in ISIS be in PPM?
A: No, All revenue generated in ISIS will post to the General Ledger at the Project level and would not be shown in PPM.