Adjusting Sponsored Events Invalidates Reconciliation (Doc ID 1272671.1)

Last updated on AUGUST 04, 2024

Applies to:

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.

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.