Why Does The Project Balance By Project Differ with MGT: Revenue, Cost, Budget By WBS Report for UBR/UER?

(Doc ID 375738.1)

Last updated on MARCH 01, 2017

Applies to:

Oracle Project Billing - Version 11.5.10.0 and later
Information in this document applies to any platform.
REPORT:PAXBUBSS.RDF - MGT: Revenue, Cost, Budgets by Work Breakdown Structure

REPORT:PAUBRUER.RDF - PRC: Summarize Unbilled Receivables/Unearned Revenue Balances Process


Goal

When viewing UBR and UER balances in HTML on the Project Balance by Project incorrect data exists.

The balances do not agree with the balances on the report generated by MGT: Revenue, Cost, Budgets by Work Breakdown Structure. 

PRC: Summarize Unbilled Receivables/Unearned Revenue Balances Process was run, but there are still records in the revenue and invoices table with a UBR_UER_PROCESS_FLAG value of 'N'.  These records with the value of 'N' are creating the difference between the HTML report and the MGT reports.

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