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

Last updated on JUNE 26, 2024

Applies to:

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

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