My Oracle Support Banner

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:

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


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.

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.

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


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.