ORA-01008: Not All Variables Bound Error Running Inbound Telephony Activity Report
(Doc ID 1928891.1)
Last updated on JANUARY 29, 2024
Applies to:
Oracle Advanced Inbound Telephony - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
When running the Inbound Telephony Activity Report with Parameters:
As of Date: <DATE>
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
-----------------------
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
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 |
| Changes |
| Cause |
| Solution |