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:

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

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