R12 Invoice And Revenue Mismatch Problem (Doc ID 2087810.1)

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.

Goal

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.
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms