My Oracle Support Banner

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

Last updated on OCTOBER 29, 2019

Applies to:

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


On : BRM 7.3.1. version, Balances


Balance group cache is not refreshed during a transaction .


  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.


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?


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

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