R12 PAXMGURA MGT: Unbilled Revenue Aging Report Considers Net Zero Expenditure Items As Unbilled (Doc ID 1961523.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.

Symptoms

The PAXMGURA MGT: Unbilled Receivables Aging report is not correct for some projects.

Problem seems to around net zero expenditure items.

Example

MGT: Unbilled Receivables Aging report shows:

Project Number = 2613121
0-30 days = 3108.96
31-60 days = 0.00
61-90 days = 0.00
91+ days = 673.30
Total = 3,782.26

Values should be $3108.96, $0, $0, $0.

This 3,108.96 would match the amount in the Funding Inquiry form

Net revenue = 61,920.73
Invoiced Amount = 58,811.77
Difference = 3,108.96

Per PA_PROJECTS_ALL
UNBILLED_RECEIVABLE_DR UNEARNED_REVENUE_CR
3,108.96 0


Also, when running the report with different number of days in bucket parameters, the totals are different.
Effective date parameter was blank; only parameters were project number and the different length buckets.
Would expect the report to report the same total each time, with the total being split differently into the different buckets. In this case, each report had a different total.


Project Name Project Number 0-3 days 4-6 days 7-9 days 10+ days Total
----------------- ----------------- --------------- --------------- --------------- --------------- ---------------
3-3-3
XXXXXXXXXX 7613172 0.00 0.00 0.00 180,820.48 180,820.48

15-15-15
Project Name Project Number 0-15 days 16-30 days 31-45 days 46+ days Total
----------------- ----------------- --------------- --------------- --------------- --------------- ---------------
XXXXXXXXXX 7613172 0.00 9,080.23 98,419.85 63,607.21 171,107.29

30-30-30
Project Name Project Number 0-30 days 31-60 days 61-90 days 91+ days Total
----------------- ----------------- --------------- --------------- --------------- --------------- ---------------
XXXXXXXXXX 7613172 9,080.23 162,675.94 1,041.43 0.00 172,797.60

35-30-30
Project Name Project Number 0-35 days 36-65 days 66-95 days 96+ days Total
----------------- ----------------- --------------- --------------- --------------- --------------- ---------------
XXXXXXXXXX 7613172 51,528.83 121,036.52 0.00 0.00 172,565.35

60-1-1
Project Name Project Number 0-60 days 61-61 days 62-62 days 63+ days Total
----------------- ----------------- --------------- --------------- --------------- --------------- ---------------
XXXXXXXXXX 7613172 175,963.64 0.00 0.00 439.32 176,402.96

Cause

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