R12: Generate Draft Revenue Autoaccounting Error - Uses Wrong Auto Accounting Function
Last updated on MARCH 08, 2017
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
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.
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms