Billing Care Search Opcode Returns All Accounts in Retun Flist
(Doc ID 2684101.1)
Last updated on AUGUST 07, 2023
Applies to:
Oracle Communications Billing and Revenue Management - Version 12.0.0.1.0 and laterInformation in this document applies to any platform.
Symptoms
While doing a particular bill search from the Billing Care (BC), the search opcode has been called from the CM twice. One for retrieving the /bill details and the other one for retrieving the account details of the bill.
The second search opcode is trying to retrieve all accounts in the return flist though only the relevant account is shown in the billing care, and the search is only for a single account from the BC GUI.
op_global_search input flist
# number of field entries allocated 20, used 7
0 PIN_FLD_POID POID [0] 0.0.0.0 /search -1 0
0 PIN_FLD_MAX_ROW INT [0] 26
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 11
1 PIN_FLD_ACCOUNT_OBJ POID [0] NULL poid pointer
1 PIN_FLD_POID POID [0] NULL poid pointer
1 PIN_FLD_NAME STR [0] ""
1 PIN_FLD_DUE DECIMAL [0] 0
1 PIN_FLD_SUBORDS_TOTAL DECIMAL [0] 0
1 PIN_FLD_ACCOUNT_NO STR [0] ""
1 PIN_FLD_CURRENT_TOTAL DECIMAL [0] 0
1 PIN_FLD_BILL_NO STR [0] ""
1 PIN_FLD_BILLINFO_OBJ POID [0] NULL poid pointer
1 PIN_FLD_DUE_T TSTAMP [0] (0) <null>
1 PIN_FLD_START_T TSTAMP [0] (0) <null>
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1 PIN_FLD_BILL_NO STR [0] "b1-1" -------------------------------> Bill no.
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1 PIN_FLD_START_T TSTAMP [0] (0) <null>
0 PIN_FLD_TEMPLATE STR [0] "select X from /bill 1 where lower( 1.F1 ) = V1 and 1.F1 is not null order by 1.F2 desc "
0 PIN_FLD_FLAGS INT [0] 0
op_global_search return flist
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 10
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 2112793 0
1 PIN_FLD_POID POID [0] 0.0.0.1 /bill 4155964 4
1 PIN_FLD_NAME STR [0] "PIN Bill"
1 PIN_FLD_DUE DECIMAL [0] 0
1 PIN_FLD_SUBORDS_TOTAL DECIMAL [0] 0
1 PIN_FLD_CURRENT_TOTAL DECIMAL [0] 0
1 PIN_FLD_BILL_NO STR [0] "B1-1"
1 PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 2111257 3
1 PIN_FLD_DUE_T TSTAMP [0] (1590908400) Sun May 31 00:00:00 2020
1 PIN_FLD_START_T TSTAMP [0] (1585724400) Wed Apr 1 00:00:00 2020
op_global_search input flist
# number of field entries allocated 20, used 5
0 PIN_FLD_POID POID [0] 0.0.0.0 /search -1 0
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 2
1 PIN_FLD_ACCOUNT_NO STR [0] ""
1 PIN_FLD_NAMEINFO ARRAY [1] allocated 20, used 3
2 PIN_FLD_LAST_NAME STR [0] ""
2 PIN_FLD_MIDDLE_NAME STR [0] ""
2 PIN_FLD_FIRST_NAME STR [0] ""
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1 PIN_FLD_POID POID [0] 0.0.0.0 /account -1 0
0 PIN_FLD_TEMPLATE STR [0] "select X from /account where F1 in (V1,'2112793')"
0 PIN_FLD_FLAGS INT [0] 0
op_global_search return flist
# number of field entries allocated 20, used 6
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 3
1 PIN_FLD_ACCOUNT_NO STR [0] "0.0.0.1-71162"
1 PIN_FLD_POID POID [0] 0.0.0.1 /account 71162 21
1 PIN_FLD_NAMEINFO ARRAY [1] allocated 20, used 3
2 PIN_FLD_LAST_NAME STR [0] "..."
2 PIN_FLD_MIDDLE_NAME STR [0] "M"
2 PIN_FLD_FIRST_NAME STR [0] "..."
0 PIN_FLD_RESULTS ARRAY [1] allocated 20, used 3
1 PIN_FLD_ACCOUNT_NO STR [0] "0.0.0.1-72345"
1 PIN_FLD_POID POID [0] 0.0.0.1 /account 72345 21
1 PIN_FLD_NAMEINFO ARRAY [1] allocated 20, used 3
2 PIN_FLD_LAST_NAME STR [0] "..."
2 PIN_FLD_MIDDLE_NAME STR [0] "M"
2 PIN_FLD_FIRST_NAME STR [0] "..."
0 PIN_FLD_RESULTS ARRAY [2] allocated 20, used 3
1 PIN_FLD_ACCOUNT_NO STR [0] "ROOT"
1 PIN_FLD_POID POID [0] 0.0.0.1 /account 1 1
1 PIN_FLD_NAMEINFO ARRAY [1] allocated 20, used 3
2 PIN_FLD_LAST_NAME STR [0] "Administrator"
2 PIN_FLD_MIDDLE_NAME STR [0] ""
2 PIN_FLD_FIRST_NAME STR [0] "System"
0 PIN_FLD_RESULTS ARRAY [3] allocated 20, used 3
1 PIN_FLD_ACCOUNT_NO STR [0] "0.0.0.1-68539"
1 PIN_FLD_POID POID [0] 0.0.0.1 /account 68539 21
1 PIN_FLD_NAMEINFO ARRAY [1] allocated 20, used 3
2 PIN_FLD_LAST_NAME STR [0] "..."
2 PIN_FLD_MIDDLE_NAME STR [0] "M"
2 PIN_FLD_FIRST_NAME STR [0] "..."
0 PIN_FLD_RESULTS ARRAY [4] allocated 20, used 3
1 PIN_FLD_ACCOUNT_NO STR [0] "0.0.0.1-2112793"
1 PIN_FLD_POID POID [0] 0.0.0.1 /account 2112793 21
1 PIN_FLD_NAMEINFO ARRAY [1] allocated 20, used 3
2 PIN_FLD_LAST_NAME STR [0] "ABCDEF"
2 PIN_FLD_MIDDLE_NAME STR [0] "ABCDEF"
2 PIN_FLD_FIRST_NAME STR [0] "ABCDEF"
EXPECTED BEHAVIOR
-----------------------
The search opcode return flist should have only the account, here 2112793, related to the /bill.
STEPS
--------
The issue can be reproduced at will with the following steps:
1. Open the Billing care.
2. Bill an existing account
3. Search the bill no in the billing care search page
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |