My Oracle Support Banner

Bill Search Returning Result For Non Paying Child Instead Of Parent (Doc ID 1058173.1)

Last updated on MARCH 04, 2019

Applies to:

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

Symptoms

In Customer Center, Bill Search by Bill_No returns child account's bill instead of parent's account bill.

Steps to Reproduce :
1)  Open Search Panel and switch to Bills and Invoices in the 'Look For' drop down.
2)  Enter a bill number for a Parent account (which has Non Paying Child) in the Bill Number field and click Search.
3)  The resulting row returned shows a 'Due' amount which appears to be associated with the Non Paying Child account instead of the Parent account. When you highlight the result and click View Bill, the account that is opened is the Non Paying account instead of the Parent.

Note: Looks like Customer Center is just using the first account being returned from BILL_FIND instead of finding the parent of the hierarchy. This will be a problem since bill_no is the same for parent and child accounts in an hierarchy

cm.pinlog snippet:


W Thu Oct 28 04:21:22 2010 <DOMAINNAME> cm:22533
cm_child.c(107):4500
1:CustomerCenter:0:AWT-EventQueue-0:131:1262916383:0
CM input flist: opcode PCM_OP_BILL_FIND, opflags=0x0
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] <IP> -1 0
0 PIN_FLD_ARGS ARRAY [0] allocated 20, used 1
1 PIN_FLD_BILL_NO STR [0] "B1-607"
D Thu Oct 28 04:21:22 2010 <DOMAINNAME> cm:22533 fm_bill_find.c:97
1:CustomerCenter:0:AWT-EventQueue-0:131:1262916383:0
op_bill_find input flist
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] <IP> -1 0
0 PIN_FLD_ARGS ARRAY [0] allocated 20, used 1
1 PIN_FLD_BILL_NO STR [0] "B1-607"
W Thu Oct 28 04:21:22 2010 <DOMAINNAME> m cm:22533
cm_child.c(107):4692 1:<machine>:<program>:0:0:0:0:0
CM output flist: opcode PCM_OP_BILL_FIND
# number of field entries allocated 20, used 4
0 PIN_FLD_POID POID [0] <IP> -1 0
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 4
1 PIN_FLD_POID POID [0] <IP> /bill 311369 3
1 PIN_FLD_ACCOUNT_OBJ POID [0] <IP>1 /account 312201 0
1 PIN_FLD_ACCOUNT_NO STR [0] "<IP>-312201"
1 PIN_FLD_BILL_NO STR [0] "B1-607"
0 PIN_FLD_RESULTS ARRAY [1] allocated 20, used 4
1 PIN_FLD_POID POID [0] <IP> /bill 314840 3
1 PIN_FLD_ACCOUNT_OBJ POID [0]<IP> /account 315096 0
1 PIN_FLD_ACCOUNT_NO STR [0] "<IP>-315096"
1 PIN_FLD_BILL_NO STR [0] "B1-607"
0 PIN_FLD_RESULTS ARRAY [2] allocated 20, used 4
1 PIN_FLD_POID POID [0] <IP> /bill 308774 4
1 PIN_FLD_ACCOUNT_OBJ POID [0] <IP>1 /account 308262 0
1 PIN_FLD_ACCOUNT_NO STR [0] "<IP>-308262"
1 PIN_FLD_BILL_NO STR [0] "B1-607"


Then when you click on the result for the bill, its reading the top row which is a child account. See below snippet of the cm pinlog :


D Thu Oct 28 04:25:44 2010 <DOMAINNAME> cm:22533
cm_child.c(107):4385
1:CustomerCenter:0:AWT-EventQueue-0:4:1262916645:0
  CMAP: op_custom() past op_decode, opcode: PCM_OP_READ_FLDS
W Thu Oct 28 04:25:44 2010 <DOMAINNAME> cm:22533
cm_child.c(107):4500
1:CustomerCenter:0:AWT-EventQueue-0:4:1262916645:0
CM input flist: opcode PCM_OP_READ_FLDS, opflags=0x0
# number of field entries allocated 20, used 8
0 PIN_FLD_POID POID [0] <IP> /account 312201 11
0 PIN_FLD_CURRENCY INT [0] 0
0 PIN_FLD_LOCALE STR [0] NULL str ptr
0 PIN_FLD_CURRENCY_SECONDARY INT [0] 0
0 PIN_FLD_PAYINFO_OBJ POID [0] NULL poid pointer
0 PIN_FLD_GROUP_OBJ POID [0] NULL poid pointer
0 PIN_FLD_BRAND_OBJ POID [0] NULL poid pointer
0 PIN_FLD_BILL_TYPE ENUM [0] 0



Expected behavior :

1)  Due displayed in the result should be a total amount of the bill (sum of parent and child amounts).
2)  When clicking on the result entry, the parent account should be opened in Customer Center



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
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.