My Oracle Support Banner

Balance Group Cache Not Refreshed During Transaction (Doc ID 1969315.1)

Last updated on DECEMBER 14, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.

Goal

On : BRM 7.3.1. version, Balances

Issue:

Balance group cache is not refreshed during a transaction .

Scenario:

  1. From testnap, open a transaction for one account, using PCM_OP_TRANS_OPEN, with flags: PCM_TRANS_OPEN_READWRITE (0x10000)|PCM_TRANS_OPEN_LOCK_DEFAULT(0x400000)
  2. Run PCM_OP_ACT_LOAD_SESSION for the account. This operation will impact the balance in resource-id 1000104 with 2005 for example.
  3. Run PCM_OP_INC_FLDS on the PIN_FLD_RESERVED_AMOUNT field from the balance in resource 1000104. This will impact the reserved amount with 995 for example.
  4. Run another PCM_OP_ACT_LOAD_SESSION for the account, within the same transaction (this time with a PCM_OPFLG_CALC_ONLY flag).

Actual result:

The problem is that rating at step 4 does not take into consideration the modification of the reserved amount field from the account balance, which was performed at step 3 by the inc_flds opcode.
Because the get_balances opcode does not return the impact of the inc_flds opcode, the result of step 4 is incorrect: rating behaves as if the quantity of -995 from the account balance was available, and not reserved, so rating consumes it.

Question:

What can be done in this situation, so that the second load_session operation takes into consideration the correct value of the account balance, including the reserved amount?

Solution

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
Goal
Solution


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