Adjusting Sponsored Events Invalidates Reconciliation (Doc ID 1272671.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.2.1.0.0 and later
Information in this document applies to any platform.
Checked for relevance on 21-Mar-2013

Symptoms

When crediting/adjusting a sponsored charge, what account and balance group should bear the impact? In other words, if Sponsor pays for Sponsoree through sponsorship, which account should be impacted when the event is adjusted? The system does a little bit to both parties, and that leaves things inconsistent.

Steps to Reproduce

NOTE: These steps assume using Customer Center to create accounts with neither services nor products. Plans are purchased in a separate step.

o Using Pricing Center to create a CF sponsorable and proratable product, and a deal , a plan to include this product
o Using Customer Center to create an account. Refer to this as "Sponsor" account.
o Configure a sponsor group for this account that sponsors the CF product.
o Create another account. Refer to this as "Sponsoree" account
o Add Sponsoree to the Sponsor's sponsor group.
o Using Sponsoree, purchase a plan with the sponsorable product.
o Verify the charge went to Sponsor as expected.
o Adjust the CF event by completing the following:
   * Open Sponsoree account in Customer Center.
   * Open the Event Browser (Edit - Event Browser) for the Sponsoree account.
   * Search for events.
   * Select and mark the event.
   * View marked events.
   * Edit - Adjust Acct. Receivable
   * May clean out your log file
   * Select "Adjust for the full amount"
   * Click "OK"

The event is now adjusted. Check Customer Center, everything looks right.  For example, the Sponsor account has been credited, and the Sponsoree still has zero balance (assuming that is where it started from).

If, however, check the database and logs, one will observe something quite different. One should be able to reconcile events to items to balance groups (and even bills). But this is not the case.

-- SQL1: See balance impacts for the sponsored charge and its adjustment.

select account_obj_id0, item_obj_id0, bal_grp_obj_id0, amount
from event_bal_impacts_t
where account_obj_id0=<account_poid>;


Give the sponsor or the sponsoree account poid here.

For example,
For the Sponsor account:

SQL> select account_obj_id0, item_obj_id0, bal_grp_obj_id0, amount from event_bal_impacts_t where account_obj_id0=281905;

ACCOUNT_OBJ_ID0 ITEM_OBJ_ID0 BAL_GRP_OBJ_ID0 AMOUNT
--------------- ------------ --------------- ----------
281905          281682       279729          10


For the Sponsoree account:

SQL> select account_obj_id0, item_obj_id0, bal_grp_obj_id0, amount from event_bal_impacts_t where account_obj_id0=282033;

ACCOUNT_OBJ_ID0 ITEM_OBJ_ID0 BAL_GRP_OBJ_ID0 AMOUNT
--------------- ------------ --------------- ----------
282033          280945       279665          -10


The charge event's balance went to the sponsor account, but the adjustment event balance went to the sponsoree account, different bal_grp_obj.

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