Trial Billing Errors Out Due To Missing ARA_SUMMARY_PROC Stored Procedure (Doc ID 558428.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 20-May-2010***
***Checked for relevance on 20-Feb-2012***
***Checked for relevance on 06-Aug-2013***
***Checked for relevance on 14-Jul-2015***

Symptoms

When attempting to run trial billing (pin_trial_bill_accts) with option -split, the application errors out in dm_oracle with the following error in dm_oracle.pinlog:

D Wed Jun 24 00:04:21 2020 myhost dm:14421 dm_if_oracle.c(104):4044 1:myhost:testnap:15200:1:1123:1201123257:1
   Start of opcode PCM_OP_EXEC_SPROC
D Wed Jun 24 00:04:21 2020 myhost dm:14421 ../dm_oracle_stmt_cache.c:324 1:myhost:testnap:15200:1:1123:1201123257:1
   PINStmtPrepare: SQL Statement = call ARA_SUMMARY_PROC ( :1, :2, :3, :4, :5, :6, :7, :8 )
E Wed Jun 24 00:04:21 2020 myhost dm:14421 dm_subr.c(112):2911 1:myhost:testnap:15200:1:1123:1201123257:1
   ORACLE error: do_proc_execute : PINStmtExecute: code 6576, op 0
   =ORA-06576: not a valid function or procedure name
E Wed Jun 24 00:04:21 2020 myhost dm:14421 dm_ops.c(144):8541
1:myhost:testnap:15200:1:1123:1201123257:1
   op_exec_sproc : do_exec_sproc returned error for the procedure ("ARA_SUMMARY_PROC")



The ARA_SUMMARY_PROC is not present in USER_OBJECTS in the database.

cm.pinlog has the following error:

W Wed Jun 24 00:44:49 2020 myhost cm:15408 cm_utils.c(111):1616
1:myhost:testnap:15405:1:1123:1201125685:1
   CM DM->FM opcode PCM_OP_EXEC_SPROC, opflags=0x0
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /procedure -1 0
0 PIN_FLD_ERR_BUF ERR [0]
   <location=PIN_ERRLOC_DM:4 class=UNKNOWN:0 errno=PIN_ERR_STORAGE:43>
   <field num=opsflds:0,0 recid=0 reserved=6576 reserved2=0 time(sec:usec)=0:0>
   <facility=0 msg_id=0 version=0>
D Wed Jun 24 00:44:49 2020 myhost cm:15408 fm_bill_get_ara_summary.c:165
1:myhost:testnap:15405:1:1123:1201125685:1
   output flist in fm_bill_get_ara_summary
# number of field entries allocated 20, used 0
E Wed Jun 24 00:44:49 2020 myhost cm:15408 fm_bill_get_ara_summary.c:88
1:myhost:testnap:15405:1:1123:1201125685:1
   error in fm_bill_get_ara_summary
   <location=PIN_ERRLOC_DM:4 class=UNKNOWN:0 errno=PIN_ERR_STORAGE:43>
   <field num=opsflds:0,0 recid=0 reserved=6576 reserved2=0 time(sec:usec)=0:0>
   <facility=0 msg_id=0 version=0>
E Wed Jun 24 00:44:49 2020 myhost cm:15408 fm_bill_make_bill_utils.c:2628
1:myhost:testnap:15405:1:1123:1201125685:1
   fm_bill_get_ara_data
   <location=PIN_ERRLOC_DM:4 class=UNKNOWN:0 errno=PIN_ERR_STORAGE:43>
   <field num=opsflds:0,0 recid=0 reserved=6576 reserved2=0 time(sec:usec)=0:0>
   <facility=0 msg_id=0 version=0>


This happens in both vanilla 7.3 install and 6.2sp4->7.0->7.3 upgraded.

-- Steps To Reproduce:
1. Enable the following entry in /apps/pin_trial_bill/pin.conf:       

- pin_mta enable_ara 1

2. Run the following command:       

pin_trial_bill_accts -start 01/01/20 -end 01/01/21 -split

     or, call PCM_OP_BILL_MAKE_TRIAL_BILL opcode with the following input flist: 

0 PIN_FLD_POID POID [0] 0.0.0.1 /account 49628 0 
0 PIN_FLD_PROGRAM_NAME STR [0] "pin_trial_bill_accts"
0 PIN_FLD_START_T TSTAMP [0] (1577854800)
0 PIN_FLD_END_T TSTAMP [0] (1609477200)
0 PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 52188
0 PIN_FLD_CHECK_SPLIT_FLAGS INT [0] 1
0 PIN_FLD_PREINVOICE_MODE INT [0] 0

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms