All AR_GROSS_AMT Fields Are Populated For Discount When Ledger Is Run (Doc ID 869823.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Goal

The expected system behavior when the pin_ledger_report is executed would be for the discount amount to populate 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:   
    CR_AR_GROSS_AMT, DB_AR_GROSS_AMT, CR_OFF_GROSS_AMT, DB_OFF_GROSS_AMT


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


        DEBIT ACCOUNT      DEBIT       CREDIT    CREDIT ACCOUNT     DEBIT       CREDIT 
_______________________________________________________________________________________ 
GROSS   monthly.debit    5.0000000   5.0000000   monthly.credit   5.0000000   5.0000000
NET     monthly.debit    0.0000000   5.0000000   monthly.credit   5.0000000   0.0000000
DISC    monthly.credit   5.0000000   0.0000000   monthly.debit    0.0000000   5.0000000
TAX      -- N/A --       0.0000000   0.0000000    -- N/A --       0.0000000   0.0000000

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