Fm_bill_check_wholesale_billinfo Error Returned When Running Pin_Trial_Bill_Accts
(Doc ID 2742857.1)
Last updated on JANUARY 11, 2021
Applies to:
Oracle Communications Billing and Revenue Management - Version 12.0.0.2.0 and laterInformation in this document applies to any platform.
Symptoms
During execution of pin_trial_bill_accts utility with date range with this command: pin_trial_bill_accts -start -end -verbose, the following errors are logged in cm.pinlog and dm_oracle.pinlog:
ERROR
-----------------------
cm.pinlog:
CM FM->DM input flist: opcode=PCM_OP_READ_FLDS, flags=0x0, errno=PIN_ERR_NOT_FOUND:3
# number of field entries allocated 20, used 4
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_BUSINESS_PROFILE_OBJ POID [0] NULL poid pointer
0 PIN_FLD_PAY_TYPE ENUM [0] 0
0 PIN_FLD_AR_BILLINFO_OBJ POID [0] NULL poid pointer
E Tue Dec 1 17:09:33 2020 <HOSTNAME> cm:20021 fm_bill_utils_bill.c:6771 2:<HOSTNAME>:pin_trial_bill_accts:19967:-269485248:1123:1606864013:7:root.0.0.0.1:::
fm_bill_check_wholesale_billinfo error with accessing PIN_FLD_BUSINESS_PROFILE_OBJ object for BillInfo passed
<location=PIN_ERRLOC_DM:4 class="UNKNOWN":0 errno=PIN_ERR_NOT_FOUND:3>
<field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>
E Tue Dec 1 17:09:33 2020 <HOSTNAME> cm:20021 fm_bill_utils_bill.c:6824 2:<HOSTNAME>:pin_trial_bill_accts:19967:-269485248:1123:1606864013:7:root.0.0.0.1:::
Error in fm_bill_check_wholesale_billinfo
<location=PIN_ERRLOC_DM:4 class="UNKNOWN":0 errno=PIN_ERR_NOT_FOUND:3>
<field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>
E Tue Dec 1 17:09:33 2020 <HOSTNAME> cm:20021 fm_inv_make_invoice.c:892 2:<HOSTNAME>:pin_trial_bill_accts:19967:-269485248:1123:1606864013:7:root.0.0.0.1:::
Error calling fm_utils_trans_open() function
<location=PIN_ERRLOC_DM:4 class="UNKNOWN":0 errno=PIN_ERR_NOT_FOUND:3>
<field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>
E Tue Dec 1 17:09:33 2020 <HOSTNAME> cm:20021 fm_inv_make_invoice.c:1764 2:<HOSTNAME>:pin_trial_bill_accts:19967:-269485248:1123:1606864013:7:root.0.0.0.1:::
Error in fm_inv_make_invoice
<location=PIN_ERRLOC_DM:4 class="UNKNOWN":0 errno=PIN_ERR_NOT_FOUND:3>
<field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>
E Tue Dec 1 17:09:33 2020 <HOSTNAME> cm:20021 fm_inv_make_invoice.c:590 2:<HOSTNAME>:pin_trial_bill_accts:19967:-269485248:1123:1606864013:7:root.0.0.0.1:::
op_inv_make_invoice: error
<location=PIN_ERRLOC_DM:4 class="UNKNOWN":0 errno=PIN_ERR_NOT_FOUND:3>
<field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>
E Tue Dec 1 17:09:33 2020 <HOSTNAME> cm:20021 cm_utils.c(155):6362 2:<HOSTNAME>:pin_trial_bill_accts:19967:-269485248:1123:1606864013:7:root.0.0.0.1:::
CM CM->FM input flist: opcode=PCM_OP_INV_MAKE_INVOICE, flags=0x80, errno=PIN_ERR_NOT_FOUND:3
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /bill 44676638 0
0 PIN_FLD_INV_FLAGS INT [0] 64
E Tue Dec 1 17:09:33 2020 <HOSTNAME> cm:20021 fm_bill_make_trial_bill.c:850 2:<HOSTNAME>:pin_trial_bill_accts:19967:-269485248:1123:1606864013:7:root.0.0.0.1:::
PCM_OP_INV_MAKE_INVOICE error
<location=PIN_ERRLOC_DM:4 class="UNKNOWN":0 errno=PIN_ERR_NOT_FOUND:3>
<field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>
dm_oracle.pinlog:
E Tue Dec 1 13:19:34 2020 <HOSTNAME> dm:91281 dm_ops.c(276):12664 2:<HOSTNAME>:pin_trial_bill_accts:123939:-465638592:1123:1606850356:5:root.0.0.0.1:::
ERROR RFLDS: map_poid_to_table_info poid=("/event/notification/billing/end", 18446744073709551615) table=event_t failed, err=4(PIN_ERR_BAD_ARG)
E Tue Dec 1 13:19:34 2020 <HOSTNAME> dm:91281 dm_ops.c(276):4285 2:<HOSTNAME>:pin_trial_bill_accts:123939:-465638592:1123:1606850356:5:root.0.0.0.1:::
ERROR RFLDS: op_rflds_prep_top_level_flds(18446744073709551615) failed, err=4(PIN_ERR_BAD_ARG)
E Tue Dec 1 13:19:34 2020 <HOSTNAME> dm:91281 dm_subr.c(178):2184 2:<HOSTNAME>:pin_trial_bill_accts:123939:-465638592:1123:1606850356:5:root.0.0.0.1:::
ORACLE error: do_sql_select: PINStmtExecute: code 936, op 0
=ORA-00936: missing expression
The issue is not replicating and the trial invoice is created successfully without issue when rerun with the failed account.
The <Note 2665273.1> does not help to resolve the issue.
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 |