My Oracle Support Banner

UBR (Unbilled Receivables) and UER (Unearned Revenue) Are Incorrect (Doc ID 2905854.1)

Last updated on OCTOBER 29, 2022

Applies to:

Oracle Project Billing - Version 12.2.6 and later
Information in this document applies to any platform.


When an invoice is created, amount is posted to UER (Unearned Revenue).

When revenue is created, posting to UER will net to zero and the remaining amount (if any) will be posted to UBR (Unbilled Receivables).

For example:

UBR             UER
0                 200   ---> Created Invoice for $200
100            -200   ---> Created Revenue for $300
500             0       ---> Created Revenue for $500
----            ----
600             0

However, many times UER (or UBR) is not backed out correctly and a balance will remain while the offset account is overstated:

UBR           UER
0               200  ---> Created Invoice for $200
300           0      ---> Created Revenue for $300
500           0      ---> Created Revenue for $500
----          ----
800           200

Reproduce By Steps (using above example)

  1. Generate invoice for $200 using Generate Draft Invoice
  2. Generate revenue for $300 using Generate Draft Revenue
  3. Generate revenue for $500 using Generate Draft Revenue





To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.