R12 Invoice And Revenue Mismatch Problem
Last updated on AUGUST 01, 2016
Applies to:Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.
A user has a Work/Work Project open and when they generate the Revenue with an Accrue Through Date of 30/11/2015, it generates a Revenue value of 9,234.52 (which is the total amount of all of the Expenditure Items raised against the Project so far).
When they generate an invoice against the Project with a Bill Through Date of 30/11/2015, the Invoice Amount is 6,654.52.
They have tried generating the invoice using both of these jobs:
PRC: Generate Draft Invoices for a Range of Projects (PAIGEN)
PRC: Generate Draft Invoices for a Single Project (PAIGEN_SINGLE)
The project is a Work/Work Project, so costs are based on transactions raised against the invoice (e.g. Web ADI Journals and AP Invoices), rather than via an Event.
For all of the Expenditure Items:
COST_DISTRIBUTED_FLAG = Y
BILLABLE_FLAG = Y
BILL_HOLD_FLAG = N
When looking at Revenue and Billing Information on the Project, the Next Billing Date is 30/04/2015.
They can't work out why the Invoice Amount is less than the Revenue amount.
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