Incorrect Result In Collections Center Gui While Searching An Account By Either The First Name Or Last Name (Doc ID 833567.1)

Last updated on JULY 24, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

On Oracle Communications Billing and Revenue Management(BRM), 7.3.1.0.0 version, incorrect results are observed in Collections Center GUI while searching an account by either the first name or last name.

During the search, the query built in the backend is as shown below which is wrong:

CM input flist: opcode PCM_OP_COLLECTIONS_GET_ACCOUNTS,
opflags=0x0
# number of field entries allocated 20, used 4
0 PIN_FLD_POID POID [0] 0.0.0.1 /account -1 0
0 PIN_FLD_THRESHOLD INT [0] 400
0 PIN_FLD_ACCTINFO ARRAY [0] allocated 20, used 1
1 PIN_FLD_NAMEINFO ARRAY [1] allocated 20, used 1
2 PIN_FLD_FIRST_NAME STR [0] "Collections"
0 PIN_FLD_FLAGS INT [0] 0
D Thu Feb 23 15:40:15 2023 XXX-D4 cm:20599
fm_collections_get_billinfos.c:111 1:01HW127829:UnknownProgramName:0:AWT-EventQueue-0:3840:1240986314:0
op_collections_get_billinfos input flist
# number of field entries allocated 20, used 4
0 PIN_FLD_POID POID [0] 0.0.0.1 /account -1 0
0 PIN_FLD_THRESHOLD INT [0] 400
0 PIN_FLD_ACCTINFO ARRAY [0] allocated 20, used 1
1 PIN_FLD_NAMEINFO ARRAY [1] allocated 20, used 1
2 PIN_FLD_FIRST_NAME STR [0] "Collections"
0 PIN_FLD_FLAGS INT [0] 0
D Thu Feb 23 15:40:15 2023 XXX-D4 cm:20599
fm_collections_get_billinfos.c:627 1:01HW127829:UnknownProgramName:0:AWT-EventQueue-0:3840:1240986314:0
fm_collections_get_billinfos search-1 input flist
# number of field entries allocated 20, used 10
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_FLAGS INT [0] 256
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1 PIN_FLD_SCENARIO_OBJ POID [0] NULL poid pointer
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1 PIN_FLD_POID POID [0] NULL poid pointer
0 PIN_FLD_ARGS ARRAY [3] allocated 20, used 1
1 PIN_FLD_AGENT_OBJ POID [0] 0.0.0.0 0 0
0 PIN_FLD_ARGS ARRAY [4] allocated 20, used 1
1 PIN_FLD_ACCOUNT_OBJ POID [0] NULL poid pointer
0 PIN_FLD_ARGS ARRAY [5] allocated 20, used 1
1 PIN_FLD_POID POID [0] NULL poid pointer
0 PIN_FLD_ARGS ARRAY [6] allocated 20, used 1
1 PIN_FLD_NAMEINFO ARRAY [*] allocated 20, used 1
2 PIN_FLD_FIRST_CANON STR [0] "Collections"
0 PIN_FLD_TEMPLATE STR [0] "select X from /billinfo 1,
/collections_scenario 2 , /account
3 where 1.F1 = 2.F2 and 2.F3 = V3 and 1.F4 = 3.F5 and 3.
F6 like V6 "
0 PIN_FLD_RESULTS ARRAY [0] NULL array ptr
D Thu Feb 23 15:40:15 2023 XXX-D4 cm:20599 fm_stub_global_search.c:85
1:01HW127829:UnknownProgramName:0:AWT-EventQueue-0:3840:1240986314:0

Actual Result:

It is noticed that field taken in PIN_FLD_FIRST_CANON is the account's first name "Collections" which is correct. However, the search result does not retrieve the name in the Collection Center GUI.
However, as per the BRM documentation, these canon fields containing the canonical names for any string fields are always stored in lower case.

Expected Result:

The FIRST_CANON_NAME for the account in question should all be in small case: "collections". So that irrespective of which case the the name is typed in the search criteria, the correct query result will be retrieved.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms