Extra Journals With 0 GLID Is Generated During Billing (Doc ID 557762.1)

Last updated on JUNE 22, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.0.0.0.1 and later
Information in this document applies to any platform.
**Checked for relevance on 1st July 2013**

Symptoms

During billing, a new journal object is created for some accounts. These journals have an amount
in the CR_AR_NET_AMT corresponding to twice DB_AR_DISC_AMT from other journals for the account.

These journal objects have a 0 GLID, it does not represent a genuine charge.

 

The issue can be reproduced at will with the following steps:
1. Create an new account
2. Apply an one off charge, this one off charge should have a PIN_FLD_DISCOUNT amount, and 
PIN_FLD_AMOUNT = 0 (charge is discounted)
3. Find journals associated with this one off charge, by SQL:
SELECT poid_id0,
item_obj_id0,
item_obj_type,
gl_id,
db_ar_net_amt,
db_ar_disc_amt,
cr_ar_net_amt,
cr_ar_disc_amt
FROM journal_t
WHERE account_obj_id0 = [account_poid]
4. Run billing for this account
5. Search for journals for this account, by SQL:
SELECT poid_id0,
item_obj_id0,
item_obj_type,
gl_id,
db_ar_net_amt,
db_ar_disc_amt,
cr_ar_net_amt,
cr_ar_disc_amt
FROM journal_t
WHERE account_obj_id0 = [account_poid]

=> Problem result:
Double amount of discount is put into CR_AR_NET_AMT of the new journal entry.

Changes

In BRM 7.0 environment, this problem occur when "generate_journal_epsilon" parameter is enabled.

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