My Oracle Support Banner

AR_GROSS_AMT Fields Populated for Discount When Ledger Is Running (Doc ID 869823.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version and later
Information in this document applies to any platform.


The expected system behavior when the pin_ledger_report is executed would be for the discount amount to be populated either CR_AR_GROSS_AMT and DB_OFF_GROSS_AMT only, or DB_AR_GROSS_AMT and CR_OFF_GROSS_AMT only in the LEDGER_REPORT_ACCTS_T table.

Steps To Reproduce: 

  1. A normal discount of 5% is tied to a monthly recurring product (with CYCLE_FEE event charged at $50 per month).    
    The discount is tied to a GLID but the recurring event is not tied to a GLID.
  2. An account is created, and the plan is purchased.
  3. The account is billed, and pin_ledger_report ('Billed') is run:    
    $pin_ledger_report -start 08/18/2011 -end 09/19/2011 -type billed -detail -report abc.txt
  4. The amount given by the discount is logged in the LEDGER_REPORT_ACCTS_T table, but with all four fields populated:   

And the ledger report will be generated as below (part of the report is displayed here):

GROSS   monthly.debit    5.0000000   5.0000000   5.0000000   5.0000000
NET     monthly.debit    0.0000000   5.0000000   5.0000000   0.0000000
DISC   5.0000000   0.0000000   monthly.debit    0.0000000   5.0000000
TAX      -- N/A --       0.0000000   0.0000000    -- N/A --       0.0000000   0.0000000


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.