Debit Item Level Adjustment Has Wrong Amount_deferred Compared To Amount (Doc ID 784028.1)

Last updated on MAY 14, 2009

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.0.0.0.0
This problem can occur on any platform.

Symptoms

-- Problem Statement:
When a debit item level adjustment is made on an account that has a -ve total non-AR item, the
event_bal_impacts_t.amount_deferred value is in -ve rather than debit:

For example, an account deal is canceled and hence has a cycle_forward fee which is in credit:

POID_ID0 ACCOUNT_OBJ_ID0 POID_TYPE DUE ITEM_TOTAL
xxxx xxxx /item/cycle_forward -45.45 -45.45

When the adjustment's event bal impacts is checked, the amount_deferred differs from amount and it
is in credit instead of debit. This causes the tax to be calculated incorrectly when the item is
invoiced.

1. The config_billing_delay is set to 1 in cm/pin.conf.
2. Create a product with cycle_forward event of 45.5 $ charge, with proration settings charge based on usage for purchase and Do not charge for this cycle for cancel. create deal, plan for the same.
3. Create an account on 22nd May 2010 with above plan via customer center, so billing cycle is May 22nd to Jun 22nd. CF change is 45.5 $
4. Move the pvt Jun23rd and running billing by calling make_bill opcode, bill got generated and bill is showing 100.10 $.
5. Now billing cycle is Jun 22nd to Jul 22nd.
6. Move the pvt to Jul 22nd, do open billing ( calling make_bill opcode), a new CF created for the month of Jul 22nd to Aug 22nd with /item/cycle_forward 45.5 $. In Customer center "Bill in progress" is showing 45.5 $
7. Move the pvt to Jul 23rd, from Customer center cancel the deal, then a NEW /item/cycle_forward will create with -45.5.
8. In Customer center "Bill in progress" is showing 0 $, In Balance -> Bill in Progress page, check for /item/cycle_forward -45.5 CF event and do a debit level adjustment of 45.5 $ with "include tax".

SQL> select poid_id0, account_obj_id0, poid_type, item_Total, transfered from item_T where item_Total != 0 and account_obj_id0 = 7607269 and poid_id0 = 7606964;
POID_ID0 ACCOUNT_OBJ_ID0 POID_TYPE ITEM_TOTAL TRANSFERED
------------------------------------------------------------------------------------------ ----------
7606964 7607269 /item/adjustment 45.5 45.5


SQL> select item_obj_id0, item_obj_type, tax_code, amount, amount_deferred from event_bal_impacts_t where item_obj_id0 = 7606964 and resource_id = 840;

ITEM_OBJ_ID0 ITEM_OBJ_TYPE TAX_CODE AMOUNT AMOUNT_DEFERRED
--------------------------------------------------------------------------------
7606964 /item/adjustment user_code 45.5 -45.5


9. Ran the billing, bill created with 50.05 $
10. Move the pvt to Aug 23rd, and done the billing, bill created with -9.1 $ ( tax for 91 $).


Expected results : Aug 23rd bill should show 0 $ bill amount
Actually results: Aug 23rd bill is show -9.1 $ bill amount.

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