My Oracle Support Banner

Billing Care Search Opcode Returns All Accounts in Retun Flist (Doc ID 2684101.1)

Last updated on JUNE 26, 2020

Applies to:

Oracle Communications Billing and Revenue Management - Version 12.0.0.1.0 and later
Information 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] "Doe"
2         PIN_FLD_MIDDLE_NAME     STR [0] "M"
2         PIN_FLD_FIRST_NAME      STR [0] "John"
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] "Doe"
2         PIN_FLD_MIDDLE_NAME     STR [0] "M"
2         PIN_FLD_FIRST_NAME      STR [0] "John"
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] "Doe"
2         PIN_FLD_MIDDLE_NAME     STR [0] "M"
2         PIN_FLD_FIRST_NAME      STR [0] "John"
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


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