Multiple Bills With Same Bill_no Correlated To Item_no Duplicated Item After Upgrade to BRM 12 PS8 (Doc ID 3023835.1)

Last updated on MAY 21, 2024

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
After upgrade Billing and Revenue Management (BRM) 7.5 to 12 Patch Set (PS) 8, the use observes multiple bills with the same bill_no correlated to the item_no duplicated item. 
This is related to bill_now for accounts sent from Service-oriented architecture (SOA) simultaneously. 

From the log, the procedure fm_utils_get_tids is returning the same values for the two bill items
====INVOKE 1====
D 2024-02-14 19:25:30.979 cm_aia:2777642.-148656384 fm_bill_utils_billing.c:1159 2::JCAAdapter:0:[ACTIVE] ExecuteThread: '155' for queue: 'weblogic.kernel.Default (self-tuning)':16001:1707960329:25:pcm_soa_pre:::
procedure input
# number of field entries allocated 20, used 6
0 PIN_FLD_POID POID [0] 0.0.0.1 /procedure -1 0
0 PIN_FLD_PROC_NAME STR [0] "update_data_sequence"
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 2
1 PIN_FLD_POID POID [0] 0.0.0.1 /data/sequence 301 457403416
1 PIN_FLD_ARG_TYPE ENUM [0] 0
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 2
1 PIN_FLD_COUNT INT [0] 1
1 PIN_FLD_ARG_TYPE ENUM [0] 0
0 PIN_FLD_ARGS ARRAY [3] allocated 20, used 2
1 PIN_FLD_HEADER_NUM INT [0] 0
1 PIN_FLD_ARG_TYPE ENUM [0] 1
0 PIN_FLD_ARGS ARRAY [4] allocated 20, used 2
1 PIN_FLD_HEADER_STR STR [0] NULL str ptr
1 PIN_FLD_ARG_TYPE ENUM [0] 1

D 2024-02-14 19:25:31.005 cm_aia:2777642.-148656384 fm_bill_utils_billing.c:1162 2::JCAAdapter:0:[ACTIVE] ExecuteThread: '155' for queue: 'weblogic.kernel.Default (self-tuning)':16001:1707960329:25:pcm_soa_pre:::
fm_utils_get_tids procedure output
# number of field entries allocated 20, used 3
0 PIN_FLD_POID POID [0] 0.0.0.1 /procedure -1 0
0 PIN_FLD_ARGS ARRAY [3] allocated 20, used 2
1 PIN_FLD_HEADER_NUM INT [0] 624489965
1 PIN_FLD_ARG_TYPE ENUM [0] 1
0 PIN_FLD_ARGS ARRAY [4] allocated 20, used 2
1 PIN_FLD_HEADER_STR STR [0] ":-:B1"
1 PIN_FLD_ARG_TYPE ENUM [0] 1

=== INVOKE 2 =====
D 2024-02-14 19:25:30.980 cm_aia:2777612.-148656384 fm_bill_utils_billing.c:1159 2:JCAAdapter:0:[ACTIVE] ExecuteThread: '71' for queue: 'weblogic.kernel.Default (self-tuning)':16001:1707960329:4:pcm_soa_pre:::
fm_utils_get_tids procedure input
# number of field entries allocated 20, used 6
0 PIN_FLD_POID POID [0] 0.0.0.1 /procedure -1 0
0 PIN_FLD_PROC_NAME STR [0] "update_data_sequence"
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 2
1 PIN_FLD_POID POID [0] 0.0.0.1 /data/sequence 301 457403416
1 PIN_FLD_ARG_TYPE ENUM [0] 0
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 2
1 PIN_FLD_COUNT INT [0] 1
1 PIN_FLD_ARG_TYPE ENUM [0] 0
0 PIN_FLD_ARGS ARRAY [3] allocated 20, used 2
1 PIN_FLD_HEADER_NUM INT [0] 0
1 PIN_FLD_ARG_TYPE ENUM [0] 1
0 PIN_FLD_ARGS ARRAY [4] allocated 20, used 2
1 PIN_FLD_HEADER_STR STR [0] NULL str ptr
1 PIN_FLD_ARG_TYPE ENUM [0] 1

D 2024-02-14 19:25:31.005 cm_aia:2777612.-148656384 fm_bill_utils_billing.c:1162 2::JCAAdapter:0:[ACTIVE] ExecuteThread: '71' for queue: 'weblogic.kernel.Default (self-tuning)':16001:1707960329:4:pcm_soa_pre:::
fm_utils_get_tids procedure output
# number of field entries allocated 20, used 3
0 PIN_FLD_POID POID [0] 0.0.0.1 /procedure -1 0
0 PIN_FLD_ARGS ARRAY [3] allocated 20, used 2
1 PIN_FLD_HEADER_NUM INT [0] 624489965
1 PIN_FLD_ARG_TYPE ENUM [0] 1
0 PIN_FLD_ARGS ARRAY [4] allocated 20, used 2
1 PIN_FLD_HEADER_STR STR [0] ":-:B1"
1 PIN_FLD_ARG_TYPE ENUM [0] 1

Cause

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