R12: Unearned Revenue Is Not Balanced After Running Post Billing Acceptance

(Doc ID 2252906.1)

Last updated on APRIL 12, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Unearned Revenue is not balanced after running Post Billing Acceptance.
This issue occurs when user changes the Account of Unearned Revenue before user runs Post Billing Acceptance in OM.

Reproduce Steps

  1. Create Sales Order which is Post Billing Acceptance and create AR invoice.
    << Account >>
    Receivable : 10.100.10.A1010.0000 $300000
    Unearned Revenue : 10.100.10.L1009.0000 $300000

    The account of Unearned Revenue is created by AutoAccounting.

  2. Change the the account of Unearned Revenue
    Unearned Revenue : 10.100.10.A1000.0000 $300000

  3. Run Post Billing Acceptance for this Sales Order in OM.

  4. Review the Accounts for this AR invoice in AR.
    Receivable : 10.100.10.A1010.0000 $300000
    Revenue : 10.100.10.R1001.0000 $300000
    Unearned Revenue : 10.100.10.L1009.0000 <$300000>
    Unearned Revenue : 10.100.10.A1000.0000 $300000

    Unearned Revenue is not balanced in the Account.

< Example Data >

RA_CUST_TRX_LINE_GL_DIST_ALL
CUST_TRX_LINE_GL_DIST_ID CODE_COMBINATION_ID PERCENT AMOUNT ACCOUNT_CLASS LATEST_REC_FLAG REC_OFFSET_FLAG
2826476 247059 100 300000 REC Y  
2826477 131056 100 300000 UNEARN   Y
2826478 125060 100 300000 REV    
2826479 247064 -100 300000 UNEARN    

 

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