ORA-01008: Not All Variables Bound Error Running Inbound Telephony Activity Report (Doc ID 1928891.1)

Last updated on JUNE 14, 2017

Applies to:

Oracle Advanced Inbound Telephony - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When running the Inbound Telephony Activity Report with Parameters:

As of Date: 15th Sep 2014
Call Center: All
View by: Call Center
Period: Week
Classification: All
Compare To: Prior Period
Dialed Number: All

Press 'Go' and receive error:

ORA-01008: not all variables bound error running Inbound Telephony Activity Report


ERROR
-----------------------

ORA-01008: not all variables bound . Main query for regionCode(BIX_PMV_AI_TELDET_RPT) is: select rset.*,BIX_PMV_AI_SL_CP BIX_CALC_ITEM1,BIX_PMV_TOTAL1 BIX_CALC_ITEM2,BIX_PMV_AI_ABANRATE_CP BIX_CALC_ITEM9,BIX_PMV_TOTAL5 BIX_CALC_ITEM10,BIX_PMV_AI_AVGWRAP_CP BIX_CALC_ITEM25,BIX_PMV_TOTAL15 BIX_CALC_ITEM26 from (SELECT v.group_name VIEWBY,v.server_group_id VIEWBYID ,0 BIX_PMV_AI_SLGOAL,SUM(to_number(NVL(c_g,0))) BIX_PMV_AI_INCALLHAND_CP,SUM(SUM(to_number(NVL(c_g,0)))) over() BIX_PMV_TOTAL9,(SUM(to_number(NVL(c_g,0))) -SUM(NVL(p_g,0)) )*100/DECODE(SUM(NVL(p_g,0)) ,0,NULL,SUM(NVL(p_g,0)) )BIX_PMV_AI_INCALLHAND_CG,(SUM(SUM(to_number(NVL(c_g,0)))) over() -SUM(SUM(NVL(p_g,0))) over() )*100/DECODE(SUM(SUM(NVL(p_g,0))) over() ,0,NULL,SUM(SUM(NVL(p_g,0))) over() )BIX_PMV_TOTAL10,SUM(NVL(c_e,0)) BIX_ATTRIBUTE_7,SUM(SUM(NVL(c_e,0))) over() BIX_PMV_TOTAL21,(SUM(NVL(c_e,0)) -SUM(NVL(p_e,0)) )*100/DECODE(SUM(NVL(p_e,0)) ,0,NULL,SUM(NVL(p_e,0)) )BIX_ATTRIBUTE_9,(SUM(SUM(NVL(c_e,0))) over() -SUM(SUM(NVL(p_e,0))) over() )*100/DECODE(SUM(SUM(NVL(p_e,0))) over() ,0,NULL,SUM(SUM(NVL(p_e,0))) over() )BIX_PMV_TOTAL22,SUM(NVL(c_l,0)) BIX_PMV_AI_SRCR_CP,SUM(SUM(NVL(c_l,0))) over() BIX_PMV_TOTAL17,(SUM(NVL(c_l,0)) -SUM(NVL(p_l,0)) )*100/DECODE(SUM(NVL(p_l,0)) ,0,NULL,SUM(NVL(p_l,0)) )BIX_PMV_AI_SRCR_CG,(SUM(SUM(NVL(c_l,0))) over() -SUM(SUM(NVL(p_l,0))) over() )*100/DECODE(SUM(SUM(NVL(p_l,0))) over() ,0,NULL,SUM(SUM(NVL(p_l,0))) over() )BIX_PMV_TOTAL18,SUM(NVL(c_m,0)) BIX_PMV_AI_LECR_CP,SUM(SUM(NVL(c_m,0))) over() BIX_PMV_TOTAL19,(SUM(NVL(c_m,0)) -SUM(NVL(p_m,0)) )*100/DECODE(SUM(NVL(p_m,0)) ,0,NULL,SUM(NVL(p_m,0)) )BIX_PMV_AI_LECR_CG,(SUM(SUM(NVL(c_m,0))) over() -SUM(SUM(NVL(p_m,0))) over() )*100/DECODE(SUM(SUM(NVL(p_m,0))) over() ,0,NULL,SUM(SUM(NVL(p_m,0))) over() )BIX_PMV_TOTAL20,SUM(NVL(c_n,0)) BIX_PMV_AI_OPCR_CP,SUM(SUM(NVL(c_n,0))) over() BIX_PMV_TOTAL23,(SUM(NVL(c_n,0)) -SUM(NVL(p_n,0)) )*100/DECODE(SUM(NVL(p_n,0)) ,0,NULL,SUM(NVL(p_n,0)) )BIX_PMV_AI_OPCR_CG,(SUM(SUM(NVL(c_n,0))) over() -SUM(SUM(NVL(p_n,0))) over() )*100/DECODE(SUM(SUM(NVL(p_n,0))) over() ,0,NULL,SUM(SUM(NVL(p_n,0))) over() )BIX_PMV_TOTAL24,SUM(NVL(c_h,0)) BIX_PMV_AI_WEBCALL_CP,SUM(SUM(NVL(c_h,0))) over() BIX_PMV_TOTAL11,(SUM(NVL(c_h,0)) -SUM(NVL(p_h,0)) )*100/DECODE(SUM(NVL(p_h,0)) ,0,NULL,SUM(NVL(p_h,0)) )BIX_PMV_AI_WEBCALL_CG,(SUM(SUM(NVL(c_h,0))) over() -SUM(SUM(NVL(p_h,0))) over() )*100/DECODE(SUM(SUM(NVL(p_h,0))) over() ,0,NULL,SUM(SUM(NVL(p_h,0))) over() )BIX_PMV_TOTAL12,SUM(NVL(c_a, 0))*100/DECODE(sum(NVL(c_d,0)) ,0,NULL,sum(NVL(c_d,0)) ) BIX_PMV_AI_SL_CP,SUM(SUM(NVL(c_a, 0))) over()*100/DECODE(SUM(SUM(NVL(c_d,0))) OVER() ,0,NULL,SUM(SUM(NVL(c_d,0))) over() ) BIX_PMV_TOTAL1, (SUM(NVL(c_a, 0))*100/DECODE(sum(NVL(c_d,0)),0,NULL,sum(NVL(c_d,0)))) -(SUM(NVL(p_a, 0))*100/DECODE(sum(NVL(p_d,0)),0,NULL,sum(NVL(p_d,0)))) BIX_PMV_AI_SL_CG, (SUM(SUM(NVL(c_a, 0))) over()*100/DECODE(SUM(SUM(NVL(c_d,0))) OVER(),0,NULL,SUM(SUM(NVL(c_d,0))) over())) -(SUM(SUM(NVL(p_a, 0))) over()*100/DECODE(SUM(SUM(NVL(p_d,0))) OVER(),0,NULL,SUM(SUM(NVL(p_d,0))) over())) BIX_PMV_TOTAL2,SUM(NVL(p_a, 0))*100/DECODE(sum(NVL(p_d,0)) ,0,NULL,sum(NVL(p_d,0)) ) BIX_CALC_ITEM3,SUM(SUM(NVL(p_a, 0))) over()*100/DECODE(SUM(SUM(NVL(p_d,0))) OVER() ,0,NULL,SUM(SUM(NVL(p_d,0))) over() ) BIX_CALC_ITEM4,SUM(NVL(c_c, 0))/DECODE(sum(NVL(c_g,0)) ,0,NULL,sum(NVL(c_g,0)) ) BIX_PMV_AI_SPANS_CP,SUM(SUM(NVL(c_c, 0))) over()/DECODE(SUM(SUM(NVL(c_g,0))) OVER() ,0,NULL,SUM(SUM(NVL(c_g,0))) over() ) BIX_PMV_TOTAL3,((SUM(NVL(c_c, 0))/DECODE(sum(NVL(c_g,0)),0,NULL,sum(NVL(c_g,0)))) -(SUM(NVL(p_c, 0))/DECODE(sum(NVL(p_g,0)),0,NULL,sum(NVL(p_g,0)))) )*100/DECODE((SUM(NVL(p_c, 0))/DECODE(sum(NVL(p_g,0)),0,NULL,sum(NVL(p_g,0)))) ,0,NULL,(SUM(NVL(p_c, 0))/DECODE(sum(NVL(p_g,0)),0,NULL,sum(NVL(p_g,0)))) )BIX_PMV_AI_SPANS_CG,((SUM(SUM(NVL(c_c, 0))) over()/DECODE(SUM(SUM(NVL(c_g,0))) OVER(),0,NULL,SUM(SUM(NVL(c_g,0))) over())) -(SUM(SUM(NVL(p_c, 0))) over()/DECODE(SUM(SUM(NVL(p_g,0))) OVER(),0,NULL,SUM(SUM(NVL(p_g,0))) over())) )*100/DECODE((SUM(SUM(NVL(p_c, 0))) over()/DECODE(SUM(SUM(NVL(p_g,0))) OVER(),0,NULL,SUM(SUM(NVL(p_g,0))) over())) ,0,NULL,(SUM(SUM(NVL(p_c, 0))) over()/DECODE(SUM(SUM(NVL(p_g,0))) OVER(),0,NULL,SUM(SUM(NVL(p_g,0))) over())) )BIX_PMV_TOTAL4,SUM(NVL(c_e, 0))*100/DECODE(sum(NVL(c_d,0)) ,0,NULL,sum(NVL(c_d,0)) ) BIX_PMV_AI_ABANRATE_CP,SUM(SUM(NVL(c_e, 0))) over()*100/DECODE(SUM(SUM(NVL(c_d,0))) OVER() ,0,NULL,SUM(SUM(NVL(c_d,0))) over() ) BIX_PMV_TOTAL5, (SUM(NVL(c_e, 0))*100/DECODE(sum(NVL(c_d,0)),0,NULL,sum(NVL(c_d,0)))) -(SUM(NVL(p_e, 0))*100/DECODE(sum(NVL(p_d,0)),0,NULL,sum(NVL(p_d,0)))) BIX_PMV_AI_ABANRATE_CG, (SUM(SUM(NVL(c_e, 0))) over()*100/DECODE(SUM(SUM(NVL(c_d,0))) OVER(),0,NULL,SUM(SUM(NVL(c_d,0))) over())) -(SUM(SUM(NVL(p_e, 0))) over()*100/DECODE(SUM(SUM(NVL(p_d,0))) OVER(),0,NULL,SUM(SUM(NVL(p_d,0))) over())) BIX_PMV_TOTAL6,SUM(NVL(p_e, 0))*100/DECODE(sum(NVL(p_d,0)) ,0,NULL,sum(NVL(p_d,0)) ) BIX_CALC_ITEM11,SUM(SUM(NVL(p_e, 0))) over()*100/DECODE(SUM(SUM(NVL(p_d,0))) OVER() ,0,NULL,SUM(SUM(NVL(p_d,0))) over() ) BIX_CALC_ITEM12,SUM(NVL(c_f, 0))*100/DECODE(sum(NVL(c_g,0)) ,0,NULL,sum(NVL(c_g,0)) ) BIX_PMV_AI_TRANRATE_CP,SUM(SUM(NVL(c_f, 0))) over()*100/DECODE(SUM(SUM(NVL(c_g,0))) OVER() ,0,NULL,SUM(SUM(NVL(c_g,0))) over() ) BIX_PMV_TOTAL7, (SUM(NVL(c_f, 0))*100/DECODE(sum(NVL(c_g,0)),0,NULL,sum(NVL(c_g,0)))) -(SUM(NVL(p_f, 0))*100/DECODE(sum(NVL(p_g,0)),0,NULL,sum(NVL(p_g,0)))) BIX_PMV_AI_TRANRATE_CG, (SUM(SUM(NVL(c_f, 0))) over()*100/DECODE(SUM(SUM(NVL(c_g,0))) OVER(),0,NULL,SUM(SUM(NVL(c_g,0))) over())) -(SUM(SUM(NVL(p_f, 0))) over()*100/DECODE(SUM(SUM(NVL(p_g,0))) OVER(),0,NULL,SUM(SUM(NVL(p_g,0))) over())) BIX_PMV_TOTAL8,SUM(NVL(c_k, 0))/DECODE(sum(NVL(c_i,0)) ,0,NULL,sum(NVL(c_i,0)) ) BIX_PMV_AI_AVGTALK_CP,SUM(SUM(NVL(c_k, 0))) over()/DECODE(SUM(SUM(NVL(c_i,0))) OVER() ,0,NULL,SUM(SUM(NVL(c_i,0))) over() ) BIX_PMV_TOTAL13,((SUM(NVL(c_k, 0))/DECODE(sum(NVL(c_i,0)),0,NULL,sum(NVL(c_i,0)))) -(SUM(NVL(p_k, 0))/DECODE(sum(NVL(p_i,0)),0,NULL,sum(NVL(p_i,0)))) )*100/DECODE((SUM(NVL(p_k, 0))/DECODE(sum(NVL(p_i,0)),0,NULL,sum(NVL(p_i,0)))) ,0,NULL,(SUM(NVL(p_k, 0))/DECODE(sum(NVL(p_i,0)),0,NULL,sum(NVL(p_i,0)))) )BIX_PMV_AI_AVGTALK_CG,((SUM(SUM(NVL(c_k, 0))) over()/DECODE(SUM(SUM(NVL(c_i,0))) OVER(),0,NULL,SUM(SUM(NVL(c_i,0))) over())) -(SUM(SUM(NVL(p_k, 0))) over()/DECODE(SUM(SUM(NVL(p_i,0))) OVER(),0,NULL,SUM(SUM(NVL(p_i,0))) over())) )*100/DECODE((SUM(SUM(NVL(p_k, 0))) over()/DECODE(SUM(SUM(NVL(p_i,0))) OVER(),0,NULL,SUM(SUM(NVL(p_i,0))) over())) ,0,NULL,(SUM(SUM(NVL(p_k, 0))) over()/DECODE(SUM(SUM(NVL(p_i,0))) OVER(),0,NULL,SUM(SUM(NVL(p_i,0))) over())) )BIX_PMV_TOTAL14,SUM(NVL(c_j, 0))/DECODE(sum(NVL(c_i,0)) ,0,NULL,sum(NVL(c_i,0)) ) BIX_PMV_AI_AVGWRAP_CP,SUM(SUM(NVL(c_j, 0))) over()/DECODE(SUM(SUM(NVL(c_i,0))) OVER() ,0,NULL,SUM(SUM(NVL(c_i,0))) over() ) BIX_PMV_TOTAL15,((SUM(NVL(c_j, 0))/DECODE(sum(NVL(c_i,0)),0,NULL,sum(NVL(c_i,0)))) -(SUM(NVL(p_j, 0))/DECODE(sum(NVL(p_i,0)),0,NULL,sum(NVL(p_i,0)))) )*100/DECODE((SUM(NVL(p_j, 0))/DECODE(sum(NVL(p_i,0)),0,NULL,sum(NVL(p_i,0)))) ,0,NULL,(SUM(NVL(p_j, 0))/DECODE(sum(NVL(p_i,0)),0,NULL,sum(NVL(p_i,0)))) )BIX_PMV_AI_AVGWRAP_CG,((SUM(SUM(NVL(c_j, 0))) over()/DECODE(SUM(SUM(NVL(c_i,0))) OVER(),0,NULL,SUM(SUM(NVL(c_i,0))) over())) -(SUM(SUM(NVL(p_j, 0))) over()/DECODE(SUM(SUM(NVL(p_i,0))) OVER(),0,NULL,SUM(SUM(NVL(p_i,0))) over())) )*100/DECODE((SUM(SUM(NVL(p_j, 0))) over()/DECODE(SUM(SUM(NVL(p_i,0))) OVER(),0,NULL,SUM(SUM(NVL(p_i,0))) over())) ,0,NULL,(SUM(SUM(NVL(p_j, 0))) over()/DECODE(SUM(SUM(NVL(p_i,0))) OVER(),0,NULL,SUM(SUM(NVL(p_i,0))) over())) )BIX_PMV_TOTAL16,SUM(NVL(p_j, 0))/DECODE(sum(NVL(p_i,0)) ,0,NULL,sum(NVL(p_i,0)) ) BIX_CALC_ITEM27,SUM(SUM(NVL(p_j, 0))) over()/DECODE(SUM(SUM(NVL(p_i,0))) OVER() ,0,NULL,SUM(SUM(NVL(p_i,0))) over() ) BIX_CALC_ITEM28,SUM(NVL(p_a, 0))*100/DECODE(sum(NVL(p_d,0)) ,0,NULL,sum(NVL(p_d,0)) ) BIX_PMV_AI_SL_PP,SUM(NVL(p_c, 0))/DECODE(sum(NVL(p_g,0)) ,0,NULL,sum(NVL(p_g,0)) ) BIX_PMV_AI_SPANS_PP,SUM(NVL(p_e, 0))*100/DECODE(sum(NVL(p_d,0)) ,0,NULL,sum(NVL(p_d,0)) ) BIX_PMV_AI_ABANRATE_PP,SUM(NVL(p_k, 0))/DECODE(sum(NVL(p_i,0)) ,0,NULL,sum(NVL(p_i,0)) ) BIX_PMV_AI_AVGTALK_PP,SUM(NVL(p_g, 0)) BIX_PMV_AI_INCALLHAND_PP FROM(((select fact.server_group_id,NULL c_a ,NULL p_a ,NULL c_b ,NULL p_b ,NULL c_c ,NULL p_c ,sum(decode(fact.time_id,TO_NUMBER(TO_CHAR(:b_bv1,'J')),(CASE WHEN media_item_type in ('TELE_INB','TELE_DIRECT') THEN call_cont_calls_offered_na END),null)) c_d , sum(decode(fact.time_id,TO_NUMBER(TO_CHAR(:b_bv2,'J')),(CASE WHEN media_item_type in ('TELE_INB','TELE_DIRECT') THEN call_cont_calls_offered_na END),null)) p_d ,NULL c_e ,NULL p_e ,NULL c_f ,NULL p_f ,sum(decode(fact.time_id,TO_NUMBER(TO_CHAR(:b_bv1,'J')),(CASE WHEN media_item_type in ('TELE_INB','TELE_DIRECT') THEN call_cont_calls_handled_tot_na END),null)) c_g , sum(decode(fact.time_id,TO_NUMBER(TO_CHAR(:b_bv2,'J')),(CASE WHEN media_item_type in ('TELE_INB','TELE_DIRECT') THEN call_cont_calls_handled_tot_na END),null)) p_g ,NULL c_h ,NULL p_h ,sum(decode(fact.time_id,TO_NUMBER(TO_CHAR(:b_bv1,'J')),call_cont_calls_handled_tot_na,null)) c_i , sum(decode(fact.time_id,TO_NUMBER(TO_CHAR(:b_bv2,'J')),call_cont_calls_handled_tot_na,null)) p_i ,NULL c_j ,NULL p_j ,NULL c_k ,NULL p_k ,NULL c_l ,NULL p_l ,NULL c_m ,NULL p_m ,NULL c_n ,NULL p_n from BIX_AI_CALL_DETAILS_MV fact WHERE time_id IN (TO_NUMBER(TO_CHAR(:b_bv1,'J')),TO_NUMBER(TO_CHAR(:b_bv2,'J'))) and period_type_id=1 and row_type='CDPR' group by fact.server_group_id) UNION ALL (select fact.server_group_id, sum(decode(cal.report_date, :b_bv3,(CASE WHEN media_item_type in ('TELE_INB','TELE_DIRECT') THEN agent_calls_answered_by_goal END), null)) c_a , sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE,(CASE WHEN media_item_type in ('TELE_INB','TELE_DIRECT') THEN agent_calls_answered_by_goal END), null)) p_a , sum(decode(cal.report_date, :b_bv3,(CASE WHEN media_item_type in ('TELE_INB','TELE_DIRECT') THEN agent_calls_handled_total END), null)) c_b , sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE,(CASE WHEN media_item_type in ('TELE_INB','TELE_DIRECT') THEN agent_calls_handled_total END), null)) p_b , sum(decode(cal.report_date, :b_bv3,(CASE WHEN media_item_type in ('TELE_INB','TELE_DIRECT') THEN call_tot_queue_to_answer END), null)) c_c , sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE,(CASE WHEN media_item_type in ('TELE_INB','TELE_DIRECT') THEN call_tot_queue_to_answer END), null)) p_c , sum(decode(cal.report_date, :b_bv3,(CASE WHEN media_item_type in ('TELE_INB','TELE_DIRECT') THEN call_calls_offered_total END), null)) c_d , sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE,(CASE WHEN media_item_type in ('TELE_INB','TELE_DIRECT') THEN call_calls_offered_total END), null)) p_d , sum(decode(cal.report_date, :b_bv3,(CASE WHEN media_item_type in ('TELE_INB','TELE_DIRECT') THEN call_calls_abandoned END), null)) c_e , sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE,(CASE WHEN media_item_type in ('TELE_INB','TELE_DIRECT') THEN call_calls_abandoned END), null)) p_e , sum(decode(cal.report_date, :b_bv3,(CASE WHEN media_item_type in ('TELE_INB','TELE_DIRECT') THEN call_calls_transferred END), null)) c_f , sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE,(CASE WHEN media_item_type in ('TELE_INB','TELE_DIRECT') THEN call_calls_transferred END), null)) p_f , sum(decode(cal.report_date, :b_bv3,(CASE WHEN media_item_type in ('TELE_INB','TELE_DIRECT') THEN call_calls_handled_total END), null)) c_g , sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE,(CASE WHEN media_item_type in ('TELE_INB','TELE_DIRECT') THEN call_calls_handled_total END), null)) p_g , sum(decode(cal.report_date, :b_bv3,(CASE WHEN media_item_type='TELE_WEB_CALLBACK' THEN call_calls_handled_total END), null)) c_h , sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE,(CASE WHEN media_item_type='TELE_WEB_CALLBACK' THEN call_calls_handled_total END), null)) p_h , sum(decode(cal.report_date, :b_bv3,call_calls_handled_total, null)) c_i , sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE,call_calls_handled_total, null)) p_i , sum(decode(cal.report_date, :b_bv3,agent_wrap_time_nac, null)) c_j , sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE,agent_wrap_time_nac, null)) p_j , sum(decode(cal.report_date, :b_bv3,call_talk_time, null)) c_k , sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE,call_talk_time, null)) p_k , sum(decode(cal.report_date, :b_bv3,agent_sr_created, null)) c_l , sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE,agent_sr_created, null)) p_l , sum(decode(cal.report_date, :b_bv3,agent_leads_created, null)) c_m , sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE,agent_leads_created, null)) p_m , sum(decode(cal.report_date, :b_bv3,agent_opportunities_created, null)) c_n , sum(decode(cal.report_date, &BIS_PREVIOUS_ASOF_DATE,agent_opportunities_created, null)) p_n from BIX_AI_CALL_DETAILS_MV fact, fii_time_rpt_struct_v cal where fact.time_id = cal.time_id and row_type='CDPR' and cal.report_date in (:b_bv3,&BIS_PREVIOUS_ASOF_DATE) and bitand(cal.record_type_id, :b_bv4) = cal.record_type_id group by fact.server_group_id ) ) ) oset , IEO_SVR_GROUPS v where oset.server_group_id=v.server_group_id group by v.group_name,v.server_group_id ORDER BY BIX_PMV_AI_INCALLHAND_CP DESC nulls last) rset where ( abs(nvl(BIX_PMV_AI_SL_CP,0)) +abs(nvl(BIX_PMV_AI_SL_CG,0))+abs(nvl(BIX_PMV_AI_SL_PP,0)) + abs(nvl(BIX_PMV_AI_SPANS_CP,0)) +abs(nvl(BIX_PMV_AI_SPANS_CG,0))+abs(nvl(BIX_PMV_AI_SPANS_PP,0)) + abs(nvl(BIX_PMV_AI_ABANRATE_CP,0)) +abs(nvl(BIX_PMV_AI_ABANRATE_CG,0))+abs(nvl(BIX_PMV_AI_ABANRATE_PP,0)) + abs(nvl(BIX_PMV_AI_TRANRATE_CP,0)) +abs(nvl(BIX_PMV_AI_TRANRATE_CG,0)) + abs(nvl(BIX_PMV_AI_INCALLHAND_CP,0)) + abs(nvl(BIX_PMV_AI_INCALLHAND_CG,0))+ abs(nvl(BIX_PMV_AI_INCALLHAND_PP,0)) + abs(nvl(BIX_PMV_AI_AVGTALK_CP,0)) +abs(nvl(BIX_PMV_AI_AVGTALK_CG,0)) +abs(nvl(BIX_PMV_AI_AVGTALK_PP,0)) + abs(nvl(BIX_PMV_AI_AVGWRAP_CP,0)) +abs(nvl(BIX_PMV_AI_AVGWRAP_CG,0)) + abs(nvl(BIX_PMV_AI_SRCR_CP,0))+abs(nvl(BIX_PMV_AI_SRCR_CG,0)) + abs(nvl(BIX_PMV_AI_LECR_CP,0)) + abs(nvl(BIX_PMV_AI_LECR_CG,0)) + abs(nvl(BIX_PMV_AI_OPCR_CP,0)) +abs(nvl(BIX_PMV_AI_OPCR_CG,0)) + abs(nvl(BIX_PMV_AI_WEBCALL_CG,0)) +abs(nvl(BIX_PMV_AI_WEBCALL_CP,0)) ) <> 0
 


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

(R) Inbound Telephony Manager
(N) Inbound Telephony Reports/Inbound Telephony Activity

Run Report

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the report and see the activity actions of the Call Center.

Changes

 

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