Problem With Turning On Epsilon For Detection Of Rounding (Doc ID 760512.1)

Last updated on SEPTEMBER 19, 2013

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.3.0.0.0 [Release 7.3.0]
Information in this document applies to any platform.
This problem can occur on any platform.
**Checked for relevance on 19th Sept 2013**

Symptoms

For a product with purchase event with the amount of 600 charge,do a payment of 400 for the account.

Question  --  why in the journal, it is showing 400 for the rounding difference ( GLID 1512) ?

-- Steps To Reproduce:
1. Created a dummy plan for /service/ip and created a account with this plan. Billing cycle is
March 20th to April 20th
2. Created a deal having purchase event with the amount of 600 and purchase the deal via testnap with below input flist

#PCM_OP_SUBSCRIPTION_PURCHASE_DEAL
# number of field entries allocated 20, used 3
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 1992313 0
0 PIN_FLD_PROGRAM_NAME STR [0] "testnap"
0 PIN_FLD_DEAL_INFO SUBSTRUCT [0] allocated 20, used 7
1 PIN_FLD_PRODUCTS ARRAY [0] allocated 23, used 23
2 PIN_FLD_PURCHASE_END_T TSTAMP [0] (0) <null>
2 PIN_FLD_PURCHASE_START_T TSTAMP [0] (0) <null>
2 PIN_FLD_USAGE_END_DETAILS INT [0] 0
2 PIN_FLD_USAGE_START_UNIT INT [0] 0
2 PIN_FLD_CYCLE_END_DETAILS INT [0] 0
2 PIN_FLD_QUANTITY DECIMAL [0] 1
2 PIN_FLD_PURCHASE_END_DETAILS INT [0] 0
2 PIN_FLD_CYCLE_START_UNIT INT [0] 0
2 PIN_FLD_USAGE_START_DETAILS INT [0] 1
2 PIN_FLD_CYCLE_START_DETAILS INT [0] 1
2 PIN_FLD_PURCHASE_START_DETAILS INT [0] 1
2 PIN_FLD_PURCHASE_START_UNIT INT [0] 0
2 PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.1 /product 1983797 0
2 PIN_FLD_DESCR STR [0] "product_epsilon_packet"
2 PIN_FLD_USAGE_DISCOUNT DECIMAL [0] 0
2 PIN_FLD_CYCLE_DISCOUNT DECIMAL [0] 0
2 PIN_FLD_PURCHASE_DISCOUNT DECIMAL [0] 0
2 PIN_FLD_STATUS ENUM [0] 1
2 PIN_FLD_STATUS_FLAGS INT [0] 0
2 PIN_FLD_USAGE_END_T TSTAMP [0] (0) <null>
2 PIN_FLD_USAGE_START_T TSTAMP [0] (0) <null>
2 PIN_FLD_CYCLE_END_T TSTAMP [0] (0) <null>
2 PIN_FLD_CYCLE_START_T TSTAMP [0] (0) <null>
1 PIN_FLD_NAME STR [0] "Deal_epsilon_packet"
1 PIN_FLD_POID POID [0] 0.0.0.1 /deal 1985333 0
1 PIN_FLD_END_T TSTAMP [0] (0) <null>
1 PIN_FLD_FLAGS INT [0] 0
1 PIN_FLD_START_T TSTAMP [0] (0) <null>
1 PIN_FLD_DESCR STR [0] ""


3. Made payment of 400 via testnap. Input flist is as per below

PCM_OP_PYMT_COLLECT
# number of field entries allocated 20, used 4
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 1 0
0 PIN_FLD_PROGRAM_NAME STR [0] "testnap"
0 PIN_FLD_DESCR STR [0] "pym via testnap"
0 PIN_FLD_CHARGES ARRAY [1] allocated 20, used 8
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 1992313 0
1 PIN_FLD_AMOUNT DECIMAL [0] 400
1 PIN_FLD_COMMAND ENUM [0] 0
1 PIN_FLD_PAYMENT SUBSTRUCT [0] allocated 20, used 1
2 PIN_FLD_DESCR STR [0] "Collector ID: C00285000011"
1 PIN_FLD_ACTG_TYPE ENUM [0] 2
1 PIN_FLD_PAY_TYPE ENUM [0] 10011
1 PIN_FLD_CURRENCY INT [0] 978

4. Moved pin_virtual_time the date to the next billing day
5. Execute pin_bill_day
6. Execute pin_ledger_report -mode run_report -start 03/20/2008 -end 04/21/2008 -type billed
-report dv1.txt
7. The payment made to this account is reflected in 1512 gl account.

General Ledger Data
___________________

Type : billed
Posting Start : Thu Mar 20 00:00:00 2008
Posting End : Mon Apr 21 00:00:00 2008



1512 (EUR) DEBIT ACCOUNT DEBIT CREDIT CREDIT
ACCOUNT DEBIT CREDIT
______________________________________________
GROSS rounding.debit 0.0000 400.0000
rounding.credit 400.0000 0.0000
NET rounding.debit 0.0000 400.0000
rounding.credit 400.0000 0.0000
DISC rounding.credit 0.0000 0.0000
rounding.debit 0.0000 0.0000
TAX rounding.debit 0.0000 0.0000
rounding.credit 0.0000 0.0000



8. Checked the item_t object.It shows DELTA_DUE as 0

> robj - 0.0.0.1 /item/misc 1992569
# number of field entries allocated 35, used 34
0 PIN_FLD_POID POID [0] 0.0.0.1 /item/misc 1992569 2
0 PIN_FLD_CREATED_T TSTAMP [0] (1206025950) Thu Mar 20 08:12:30 2008
0 PIN_FLD_MOD_T TSTAMP [0] (1208718036) Sun Apr 20 12:00:36 2008
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 1992313 0
...
0 PIN_FLD_DELTA_DUE DECIMAL [0] 0
0 PIN_FLD_DISPUTED DECIMAL [0] 0
0 PIN_FLD_DUE DECIMAL [0] 100
...
0 PIN_FLD_ITEM_NO STR [0] "B1-18,1"
0 PIN_FLD_ITEM_TOTAL DECIMAL [0] 500
0 PIN_FLD_NAME STR [0] "Usage"
0 PIN_FLD_OPENED_T TSTAMP [0] (1208718036) Sun Apr 20 12:00:36 2008
0 PIN_FLD_RECVD DECIMAL [0] -400
...



Actual result:
In GL report, 1512 GL id (rounding difference) shows 400.

Expected result:
In GL report, 1512 GL id shouldn't show since DELTA_DUE is 0 in /item.


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