Fusion integration with bics stored procedure problem

Erashed

Summary

Fusion integration with bics stored procedure problem

Content

I have an issue in working with fusion with bics i follow this link :http://www.ateam-oracle.com/integrating-oracle-fusion-sales-cloud-with-oracle-business-intelligence-cloud-service-bics/

but i always face error in the last step

ORA-01403: no data found

my stored procedure execution code is :

declare

  v_row_count number ;

begin

   select count(*) into v_row_count from SALES_CLOUD_PIPELINE_1;

   dbms_output.put_line('Original count: '||v_row_count) ;

   delete SALES_CLOUD_PIPELINE_1;

   commit ;

   select count(*) into v_row_count from SALES_CLOUD_PIPELINE_1;

   dbms_output.put_line('Deleted count: '||v_row_count) ;

   bics_scs_integration

   (

      'https://bi-eerb-test.analytics.em3.oraclecloud.com/analytics-ws/saw.dll?SoapImpl=nQSessionService'

     ,'https://eerb.bi.oraclecloud.com/analytics-ws/saw.dll?SoapImpl=xmlViewService'

      ,'/Shared/Custom/DataSyncTest'

      ,'mohammad.salameh@samirgroup.com'

      ,'SamirGroup@2018'

      ,'SALES_CLOUD_PIPELINE_1'

      ,'Column0:VARCHAR2(100)|Column1:VARCHAR2(100)|Column2:NUMBER|Column3:DATE(100)' 

    );

    select count(*) into v_row_count from SALES_CLOUD_PIPELINE_1;

    dbms_output.put_line('Refreshed count: '||v_row_count) ;

end;

/