Here are some of the frequently asked questions during Projects Revenue Generation.

1. Why is Revenue generated even after Bill Hold is set to Yes for the Event?

The Bill Hold field on the Event Form is used to keep a particular event from being included on an invoice during the Generate Draft Invoices process.  Bill holds do not affect the Generate Draft Revenue process.

2. Why does the Generate Draft Revenue for a Range of Projects process automatically release revenue?

When revenue is generated for a range of projects, revenue items are given a status of Released; when it is generated for a single project, the status assigned is Pending.  Because the status is released for revenue generated for a range, Projects automatically processes this revenue when the Interface Revenue to General Ledger (GL) process is run. If there is a need to manually release revenue, you will have to run the PRC: Generate Draft Revenue for a Single Project. When ready, the revenue can be released manually from the Revenue Review window.

3. Why is revenue automatically released when releasing some invoices?

A:  When you release an invoice which is based on revenue details (such as a Time & Materials (T&M) invoice), Oracle Projects automatically releases the associated revenue.

4. Why is the project level bill rate schedule not recognized when generating draft revenue?

A:  Revenue is generated based on the Bill Rate Schedule saved at the task level.  The Employee Bill Rate Schedule assigned at project level is used only for default purposes when creating new tasks; it is not used for calculations.

5. Is it possible to unrelease revenue?

A: It is only possible to unrelease revenue if none of the following actions have been performed:

    1. Released draft invoices for this draft revenue
    2. Subsequently generated draft revenue
    3. Summarized draft revenue for the project

6. Is it possible to generate partial revenue when a Hard Limit exists on an Agreement?

A: Yes and no.  Projects accrues revenue for an event only if enough funding is available to accrue the full event amount. You can, however, accrue expenditure item revenue up to hard revenue limits by partially accruing the potential revenue.  The expenditure items are marked as partially accrued; they can be fully accrued by adding more funding prior to the next revenue generation run.

7. If transactions are generated for an expenditure type that is not included in the burden schedule used for revenue generation, why is revenue generated for these transactions?

A: Revenue generation is not dependent on whether the expenditure type is included in a burden schedule–it is dependent on whether items are marked billable or not billable. The burden schedule is used to determine the revenue amount by marking up the cost.  If no revenue should be generated, the expenditure items should be flagged as non-billable.  If revenue has already been generated in error, it can be removed by marking the expenditure items as non-billable and recalculating revenue.

8. Is there a way to make the ‘accrue through date’ on draft revenues correspond to the expenditure item date, PA date, or GL date of the expenditure item for which revenue is being generated?

A:  This is not currently possible for several reasons. Firstly, there is not a one-to-one correlation between expenditure items and revenues–many expenditure items are grouped into a single revenue. Secondly, this date is not a system-generated date. The ‘accrue through date’ is a parameter entered by the user when running the generate draft revenue process.

9. Why does the PARGDR PRC: Generate Draft Revenue process delete unreleased/unapproved invoices?

A: This is intended functionality. For work based projects, revenue generation is a pre-requisite for the invoice generation for expenditure items. Therefore, deletion of revenue will delete the underlying invoice as well. There should not be an invoice that exists without the corresponding revenue existing (for expenditures items). Please note that this happens only when you accrue revenue and invoice for expenditures. If the intention is to leave invoices or revenue untouched, they should be approved and released before rerunning the PRC: Generate Draft Revenue (PARGDR) process.

Leave a Reply