My Oracle Support Banner

Updating Price Assignment Creates a New Price Item Parameter Group Id and Causes Incorrect Billing Amounts (Doc ID 2419267.1)

Last updated on JULY 09, 2018

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

In RMB v2.4.0.1.0 against FW v4.2.0.2, a new price item group id is created when the price assignment is updated and it causes incorrect calculations.

ACTUAL BEHAVIOR
-------------------------
When the rates in the price assignment are updated, a new price item parameter group id is created even if the product parameters are not updated.
This is causing an issue in billing, because the billable charge is still linked to the previous id, so the amount is not calculated as expected.

EXPECTED BEHAVIOR
---------------------------
The update should be reflected in all relevant ends and should not cause any incorrect calculations.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1) Create price assignment with product parameters:
- Add Parameters
- Add Characteristics
- Add Price assignment details

2) Create Billable Charge with parameters:
- Update in Main & Parameters UI
- Note that Priceitem_parm_grp_id in the billable charge and CI_PRICEITEM_PARM_GRP_K table with the parameters updated accordingly and Id shows up in CI_PRICECOMP_TIER

3) Update rate in price assignment
- After save the values, a new id is generated CI_PRICEITEM_PARM_GRP_K table, the order in the parameters was reverted and there is a new id generated.
- The price component tier table (CI_PRICECOMP_TIER) is using now the new id
- Billable charge is still using previous id in Priceitem_parm_grp_id

4) The bill is not generated properly after this change

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot update Rate value as needed.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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