My Oracle Support Banner

R12: Generate Draft Revenue Autoaccounting Error - Uses Wrong Auto Accounting Function (Doc ID 1391119.1)

Last updated on AUGUST 23, 2021

Applies to:

Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.


PRC: Generate Draft Revenue is not using the correct Autoaccounting.

Project has Public Sector checked.

Setup 'Usage Revenue Account' AutoAccounting Function

Function Transactions:

All Usage Revenue - setup but NOT enabled
Private Usage Revenue - NOT Setup or enabled
Public Usage Revenue - setup and enabled.

Create Pre-Approved Usage batch.
Distribute Costs
Run Generate Revenue process.

CCID is generated using the 'All Usage Revenue' Transaction setup instead of
the 'Public Usage Revenue' setup.

Even when the Project is clearly a Public Sector project.

Per the Implementation Guide:

You tell Oracle Projects which AutoAccounting rules to use, under which
circumstances, by assigning rules to transactions. In cases where an
AutoAccounting function consists of several distinct transactions, you
assign rules to each transaction you want to use. These rule assignments
then determine which general ledger account AutoAccounting uses to process
that transaction. Oracle Projects attempts to use the most appropriate
transaction; if you have not enabled that transaction, it tries to use the
fallback transaction.

For example, the Labor Revenue Account function, which Oracle Projects uses
to credit a revenue account for labor revenue, consists of three
Public Labor Revenue
Private Labor Revenue
All Labor Revenue

When Oracle Projects needs to credit a revenue account for labor performed
on a public project, it first checks whether you have enabled the Public
Labor Revenue transaction.
If the transaction is enabled, Oracle Projects uses the AutoAccounting rules
you assigned to the transaction to determine which account to credit.
If you have not enabled the Public Labor Revenue transaction, Oracle
Projects checks the "fallback" transaction All Labor Revenue.

Since the project is a 'Public Sector' project and the Public Usage Revenue
transaction is setup and enabled. This Transaction should be used.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.