When PIN_FLD_SUB_TYPE is Null, PCM_OP_BAL_GET_BALANCES Gets the CURRENT_BAL as 0. (Doc ID 2931710.1)

Last updated on MARCH 09, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
After upgraded Billing and Revenue Management (BRM) 12.0 from Patch Set (PS) 3 to PS6, the field PIN_FLD_SUB_TYPE is being set to null for existing accounts. When opcode PCM_OP_BAL_GET_BALANCES is called, then it returns 0 even if the current balance is non-zero.
After the upgrade, for all existing accounts, the PIN_FLD_SUB_TYPE would be null. However, for the new accounts that are created post PS6, this field will be 0, hence issue does not affect new accounts.


EXPECTED BEHAVIOR
-----------------------
For existing accounts, PIN_FLD_SUB_TYPE should not be set to null after the upgrade, and opcode PCM_OP_BAL_GET_BALANCES should return correct balance amount.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade from PS3 to PS6
2. Call opcode PCM_OP_BAL_GET_BALANCES to get account's balance

Cause

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