Loading ...
Sorry, an error occurred while loading the content.

RE: [PkOug] Reports are not displaying in Oracle Application Server 10.1.2

Expand Messages
  • Imran Arshad
    There must be a popup blocker enabled on your browser. Muhammad Imran Arshad ... From: PkOug@yahoogroups.com [mailto:PkOug@yahoogroups.com] On Behalf Of Arshad
    Message 1 of 11 , Aug 31, 2007
    • 0 Attachment
    • yasir vohra
      Dear Arshad, Would you please share a little bit detail. I am facing the same problem. I am using IAS 10g. Thanks Yasir ... -- ... Rgrds VOHRA, YASIR SENIOR
      Message 2 of 11 , Sep 2, 2007
      • 0 Attachment
        Dear Arshad,

        Would you please share a little bit detail. I am facing the same problem.

        I am using IAS 10g.

        Thanks

        Yasir

        On 8/31/07, Imran Arshad <mimran@...> wrote:

        There must be a popup blocker enabled on your browser.

         

         

        Muhammad Imran Arshad

         

        -----Original Message-----
        From: PkOug@yahoogroups.com [mailto:PkOug@yahoogroups.com] On Behalf Of Arshad
        Sent:
        Friday, August 31, 2007 1:35 PM
        To: PkOug@yahoogroups.com
        Subject: [PkOug] Reports are not displaying in Oracle Application Server 10.1.2

         

        Asslam-O-Allaikum,

        Dear members i just installed Forms and Reports Serveres and i
        integrate my application forms are running successfuly but when i am
        calling reports then there is no erorr is popup and report displaying
        and but my calling report is in 'Finished Jobs' in Application Server
        report server and when click on VIEW RESULT of calling report then
        that calling report call from cache and show complete result with
        success but at the calling time report from forms report is not
        displaying result or any erorr.

        but calling reports is calling successfuly from Developer

        what should i do please tell me.

        Arshad




        --
        ---------------------------------------------------------------------------------------------------------------------------------
        Rgrds

        VOHRA, YASIR
        SENIOR SOFTWARE ENGINEER
        (Information Technology)
        ALLIANZ EFU HEALTH INSURANCE LTD.

        http://www.allianz-efu.com
        Tel: + 92 21 111- HEALTH Ext: 244
        Technical Skill is the mastery of complexity, while Creativity is the mastery of simplicity
        ----------------------------------------------------------------------------------------------------------------------------------
      • Arshad Jagirani
        Dear Yasir, It is the issue of SSO (Single Sign ON) and NON-SSO users and it is the coding problem with so SSO ans NON-SSO, so show ur coding and i will
        Message 3 of 11 , Sep 3, 2007
        • 0 Attachment
          Dear Yasir,
           
          It is the issue of SSO (Single Sign ON) and NON-SSO users and it is the coding problem with so SSO ans NON-SSO, so show ur coding and i will identifiy ur problem.
           
          Regards
          Arshad

          yasir vohra <vohra.yasir@...> wrote:
          Dear Arshad,

          Would you please share a little bit detail. I am facing the same problem.

          I am using IAS 10g.

          Thanks

          Yasir

          On 8/31/07, Imran Arshad <mimran@.... pk> wrote:
          There must be a popup blocker enabled on your browser.
           
           
          Muhammad Imran Arshad
           
          -----Original Message-----
          From: PkOug@yahoogroups. com [mailto:PkOug@yahoogroups. com] On Behalf Of Arshad
          Sent:
          Friday, August 31, 2007 1:35 PM
          To: PkOug@yahoogroups. com
          Subject: [PkOug] Reports are not displaying in Oracle Application Server 10.1.2
           
          Asslam-O-Allaikum,

          Dear members i just installed Forms and Reports Serveres and i
          integrate my application forms are running successfuly but when i am
          calling reports then there is no erorr is popup and report displaying
          and but my calling report is in 'Finished Jobs' in Application Server
          report server and when click on VIEW RESULT of calling report then
          that calling report call from cache and show complete result with
          success but at the calling time report from forms report is not
          displaying result or any erorr.

          but calling reports is calling successfuly from Developer

          what should i do please tell me.

          Arshad



          --
          ------------ --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- ---------
          Rgrds

          VOHRA, YASIR
          SENIOR SOFTWARE ENGINEER
          (Information Technology)
          ALLIANZ EFU HEALTH INSURANCE LTD.

          http://www.allianz- efu.com
          Tel: + 92 21 111- HEALTH Ext: 244
          Technical Skill is the mastery of complexity, while Creativity is the mastery of simplicity
          ------------ --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- -



          Arshad Jagirani
          Oracle AS, DBA, Developer
          DB2 9.1 Certified & I3 For Oracle Certified
          (+92)-333-7124767


          Boardwalk for $500? In 2007? Ha!
          Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.

        • yasir vohra
          Dear Arshad, Below is the code that i am using to run the report. Looking for your reply. ... PROCEDURE RUN_REPORT_OBJECT_PROC(report_id REPORT_OBJECT,
          Message 4 of 11 , Sep 4, 2007
          • 0 Attachment
            Dear Arshad,

            Below is the code that i am using to run the report. Looking for your reply.
            ---------------------------------------------------------------------------------------------------------------------------------------------

            PROCEDURE RUN_REPORT_OBJECT_PROC(report_id REPORT_OBJECT, reportserver varchar2,

            runformat varchar2) IS

             

            report_message   VARCHAR2(100);

            rep_status       VARCHAR2(100);

            vc_user_name     VARCHAR2(100);

            vc_user_password VARCHAR2(100);

            vc_user_connect  VARCHAR2(100);

            vc_connect       VARCHAR2(300);          

            BEGIN

                    /* get user connect string */                

                    vc_user_name:=get_application_property(username);

                    vc_user_password:=get_application_property(password);

                    vc_user_connect:=get_application_property(connect_string);

                    vc_connect:=vc_user_name||'/'||vc_user_password||'@'||vc_user_connect;

                             

                    /*set Reports properties for run_report_object*/

                    

                    SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_EXECUTION_MODE,BATCH);

                    SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_MODE,ASYNCHRONOUS);

                    SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYPE,CACHE);

                    SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESFORMAT,runformat);

                    SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_SERVER,reportserver);

                    

                    /* P_USER_CONNECT and P_SERVERNAME are custom parameters in the Reports 

                     module. P_ACTION is also a user defined variable in Reports and takes 

                     the web access path to the Report (does not need to be hard coded as 

                     in this sample )*/

             

                   /* Change the hostname, port and cgi virtual directory to the one for 

                   your own machine */ 

                 

                    SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_OTHER,'P_PRE_AUTH_ID=' ||:MED_PRE_AUTH_LOG.PRE_AUTH_ID||' paramform=yes P_USER_CONNECT=' ||vc_connect||' P_SERVERNAME='||reportserver ||' P_ACTION=http://589.650.124.3:81/dev60cgi/rwcgi60.exe?');

                    report_message:= run_report_object(report_id);

                    rep_status := report_object_status(report_message);

              

                   /* Wait for Report to be finished (asynchonous processing possible using

                   timers) */

                

                            WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')LOOP

                                    rep_status := report_object_status(report_message);

                                                                                                

                            END LOOP /* Wait for Report to be finished */;

             

                   /* Change the cgi virtual directory to the one for your own machine */

                           

                    IF rep_status='FINISHED' then

                            web.show_document('/dev60cgi/rwcgi60.exe/getjobid='||report_message ||'?server='||reportserver,'_blank');

                    ELSE

                                    message (rep_status||'  Report output aborted');

                    END IF;

             

             

            END;

            --------------------------------------------------------------------------------------------------------

            Thanks

            Yasir

            On 9/4/07, Arshad Jagirani <arsha801@...> wrote:

            Dear Yasir,
             
            It is the issue of SSO (Single Sign ON) and NON-SSO users and it is the coding problem with so SSO ans NON-SSO, so show ur coding and i will identifiy ur problem.
             
            Regards
            Arshad


            yasir vohra <vohra.yasir@ gmail.com> wrote:
            Dear Arshad,

            Would you please share a little bit detail. I am facing the same problem.

            I am using IAS 10g.

            Thanks

            Yasir

            On 8/31/07, Imran Arshad <mimran@...> wrote:
            There must be a popup blocker enabled on your browser.
             
             
            Muhammad Imran Arshad
             
            -----Original Message-----
            From: PkOug@yahoogroups.com [mailto:PkOug@ yahoogroups.com] On Behalf Of Arshad
            Sent:
            Friday, August 31, 2007 1:35 PM
            To: PkOug@yahoogroups.com
            Subject: [PkOug] Reports are not displaying in Oracle Application Server 10.1.2
             
            Asslam-O-Allaikum,

            Dear members i just installed Forms and Reports Serveres and i
            integrate my application forms are running successfuly but when i am
            calling reports then there is no erorr is popup and report displaying
            and but my calling report is in 'Finished Jobs' in Application Server
            report server and when click on VIEW RESULT of calling report then
            that calling report call from cache and show complete result with
            success but at the calling time report from forms report is not
            displaying result or any erorr.

            but calling reports is calling successfuly from Developer

            what should i do please tell me.

            Arshad



            --
            ---------------------------------------------------------------------------------------------------------------------------------
            Rgrds

            VOHRA, YASIR
            SENIOR SOFTWARE ENGINEER
            (Information Technology)
            ALLIANZ EFU HEALTH INSURANCE LTD.

            http://www.allianz-efu.com
            Tel: + 92 21 111- HEALTH Ext: 244
            Technical Skill is the mastery of complexity, while Creativity is the mastery of simplicity
            ----------------------------------------------------------------------------------------------------------------------------------



            Arshad Jagirani
            Oracle AS, DBA, Developer
            DB2 9.1 Certified & I3 For Oracle Certified
            (+92)-333-7124767


            Boardwalk for $500? In 2007? Ha!
            Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.




            --
            ---------------------------------------------------------------------------------------------------------------------------------
            Rgrds

            VOHRA, YASIR
            SENIOR SOFTWARE ENGINEER
            (Information Technology)
            ALLIANZ EFU HEALTH INSURANCE LTD.

            http://www.allianz-efu.com
            Tel: + 92 21 111- HEALTH Ext: 244
            Technical Skill is the mastery of complexity, while Creativity is the mastery of simplicity
            ----------------------------------------------------------------------------------------------------------------------------------
          • maqbool khan
            Dear Yasir I can solve yr problem of Oracle 10g AS. Kindly give me following detail. 1. Yr report object properties 2. Whether you are using Parameter form
            Message 5 of 11 , Sep 4, 2007
            • 0 Attachment
              Dear Yasir
               
              I can solve yr problem of Oracle 10g AS.
               
              Kindly give me following detail.
               
              1. Yr report object properties
              2. Whether you are using Parameter form with report.
              3. If you are using parameter form, whether it is developed in Form builder or report builder
              4. You are using SSO mode or not
               
              regards


              yasir vohra <vohra.yasir@...> wrote:
              Dear Arshad,

              Below is the code that i am using to run the report. Looking for your reply.
              ------------ --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- ---
              PROCEDURE RUN_REPORT_OBJECT_ PROC(report_ id REPORT_OBJECT, reportserver varchar2,
              runformat varchar2) IS
               
              report_message   VARCHAR2(100) ;
              rep_status       VARCHAR2(100) ;
              vc_user_name     VARCHAR2(100) ;
              vc_user_password VARCHAR2(100) ;
              vc_user_connect  VARCHAR2(100) ;
              vc_connect       VARCHAR2(300) ;          
              BEGIN
                      /* get user connect string */                
                      vc_user_name: =get_application _property( username) ;
                      vc_user_password: =get_application _property( password) ;
                      vc_user_connect: =get_application _property( connect_string) ;
                      vc_connect:= vc_user_name| |'/'||vc_user_password| |'@'||vc_user_connect;
                               
                      /*set Reports properties for run_report_object* /
                      
                      SET_REPORT_OBJECT_ PROPERTY( report_id, REPORT_EXECUTION _MODE,BATCH) ;
                      SET_REPORT_OBJECT_ PROPERTY( report_id, REPORT_COMM_ MODE,ASYNCHRONOU S);
                      SET_REPORT_OBJECT_ PROPERTY( report_id, REPORT_DESTYPE, CACHE);
                      SET_REPORT_OBJECT_ PROPERTY( report_id, REPORT_DESFORMAT ,runformat) ;
                      SET_REPORT_OBJECT_ PROPERTY( report_id, REPORT_SERVER, reportserver) ;
                      
                      /* P_USER_CONNECT and P_SERVERNAME are custom parameters in the Reports 
                       module. P_ACTION is also a user defined variable in Reports and takes 
                       the web access path to the Report (does not need to be hard coded as 
                       in this sample )*/
               
                     /* Change the hostname, port and cgi virtual directory to the one for 
                     your own machine */ 
                   
                      SET_REPORT_OBJECT_ PROPERTY( report_id, REPORT_OTHER,'P_PRE_AUTH_ID=' ||:MED_PRE_AUTH_ LOG.PRE_AUTH_ ID||' paramform=yes P_USER_CONNECT=' ||vc_connect| |' P_SERVERNAME='||reportserver ||' P_ACTION=http://589.650. 124.3:81/ dev60cgi/ rwcgi60.exe?');
                      report_message: = run_report_object( report_id) ;
                      rep_status := report_object_ status(report_ message);
                
                     /* Wait for Report to be finished (asynchonous processing possible using
                     timers) */
                  
                              WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')LOOP
                                      rep_status := report_object_ status(report_ message);
                                                                                                  
                              END LOOP /* Wait for Report to be finished */;
               
                     /* Change the cgi virtual directory to the one for your own machine */
                             
                      IF rep_status='FINISHED' then
                              web.show_document('/dev60cgi/rwcgi60. exe/getjobid='||report_message ||'?server='||reportserver,'_blank');
                      ELSE
                                      message (rep_status| |'  Report output aborted');
                      END IF;
               
               
              END;
              ------------ --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --

              Thanks

              Yasir

              On 9/4/07, Arshad Jagirani <arsha801@yahoo. com> wrote:
              Dear Yasir,
               
              It is the issue of SSO (Single Sign ON) and NON-SSO users and it is the coding problem with so SSO ans NON-SSO, so show ur coding and i will identifiy ur problem.
               
              Regards
              Arshad


              yasir vohra <vohra.yasir@ gmail.com> wrote:
              Dear Arshad,

              Would you please share a little bit detail. I am facing the same problem.

              I am using IAS 10g.

              Thanks

              Yasir

              On 8/31/07, Imran Arshad <mimran@.... pk> wrote:
              There must be a popup blocker enabled on your browser.
               
               
              Muhammad Imran Arshad
               
              -----Original Message-----
              From: PkOug@yahoogroups. com [mailto:PkOug@ yahoogroups. com] On Behalf Of Arshad
              Sent:
              Friday, August 31, 2007 1:35 PM
              To: PkOug@yahoogroups. com
              Subject: [PkOug] Reports are not displaying in Oracle Application Server 10.1.2
               
              Asslam-O-Allaikum,

              Dear members i just installed Forms and Reports Serveres and i
              integrate my application forms are running successfuly but when i am
              calling reports then there is no erorr is popup and report displaying
              and but my calling report is in 'Finished Jobs' in Application Server
              report server and when click on VIEW RESULT of calling report then
              that calling report call from cache and show complete result with
              success but at the calling time report from forms report is not
              displaying result or any erorr.

              but calling reports is calling successfuly from Developer

              what should i do please tell me.

              Arshad



              --
              ------------ --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- ---------
              Rgrds

              VOHRA, YASIR
              SENIOR SOFTWARE ENGINEER
              (Information Technology)
              ALLIANZ EFU HEALTH INSURANCE LTD.

              http://www.allianz- efu.com
              Tel: + 92 21 111- HEALTH Ext: 244
              Technical Skill is the mastery of complexity, while Creativity is the mastery of simplicity
              ------------ --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- -



              Arshad Jagirani
              Oracle AS, DBA, Developer
              DB2 9.1 Certified & I3 For Oracle Certified
              (+92)-333-7124767

              Boardwalk for $500? In 2007? Ha!
              Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.



              --
              ------------ --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- ---------
              Rgrds

              VOHRA, YASIR
              SENIOR SOFTWARE ENGINEER
              (Information Technology)
              ALLIANZ EFU HEALTH INSURANCE LTD.

              http://www.allianz- efu.com
              Tel: + 92 21 111- HEALTH Ext: 244
              Technical Skill is the mastery of complexity, while Creativity is the mastery of simplicity
              ------------ --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- -



              Regards
               
              Maqbool Hussain Khan
              Senior Systems Analyst / DBA
              Fauji Fertilizer Company
              Sadik Abad, Pakistan 
              Ph: 92-068-5786420   Ext. Off. 3454 Res. 5637
              Cell # 0300-8771914


              Yahoo! oneSearch: Finally, mobile search that gives answers, not web links.

            • Imran Arshad
              THERE COULD BE A COUPLE OF PROBLEM CHECK AND IDENTIFY. 1. First of all try to run the demo reports. 2. First check the POPUP blocker on your Brower. 3. Disable
              Message 6 of 11 , Sep 4, 2007
              • 0 Attachment
              • yasir vohra
                Dear Maqbool your required information is here. Looking for your reply. ... SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_EXECUTION_MODE,BATCH);
                Message 7 of 11 , Sep 6, 2007
                • 0 Attachment
                  Dear Maqbool your required information is here. Looking for your reply.

                  On 9/5/07, maqbool khan <maqbl@... > wrote:

                  Dear Yasir
                   
                  I can solve yr problem of Oracle 10g AS.
                   
                  Kindly give me following detail.
                   
                  1. Yr report object properties

                   







                          SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_EXECUTION_MODE,BATCH);
                          SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_MODE,ASYNCHRONOUS);
                          SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYPE,CACHE);
                          SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESFORMAT,runformat);
                          SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_SERVER,reportserver);

                  SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_OTHER,'P_PRE_AUTH_ID=' ||:MED_PRE_AUTH_LOG.PRE_AUTH_ID||' paramform=yes P_USER_CONNECT=' ||vc_connect||' P_SERVERNAME='||reportserver ||' P_ACTION=http://589.650.124.3:81/dev60cgi/rwcgi60.exe?');



                  2. Whether you are using Parameter form with report. YES
                  3. If you are using parameter form, whether it is developed in Form builder or report builder THE PARAMETER FORM IS DEVELOPED IN REPORT BUILDER

                   

                  4. You are using SSO mode or not "WHERE TO FIND THIS?"
                   
                  regards


                  yasir vohra <vohra.yasir@gmail.com> wrote:
                  Dear Arshad,

                  Below is the code that i am using to run the report. Looking for your reply.
                  ---------------------------------------------------------------------------------------------------------------------------------------------
                  PROCEDURE RUN_REPORT_OBJECT_PROC(report_id REPORT_OBJECT, reportserver varchar2,
                  runformat varchar2) IS
                   
                  report_message   VARCHAR2(100);
                  rep_status       VARCHAR2(100);
                  vc_user_name     VARCHAR2(100);
                  vc_user_password VARCHAR2(100);
                  vc_user_connect  VARCHAR2(100);
                  vc_connect       VARCHAR2(300);          
                  BEGIN
                          /* get user connect string */                
                          vc_user_name:=get_application_property(username);
                          vc_user_password:=get_application_property(password);
                          vc_user_connect:=get_application_property(connect_string);
                          vc_connect:=vc_user_name||'/'||vc_user_password||'@'||vc_user_connect;
                                   
                          /*set Reports properties for run_report_object*/
                          
                          SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_EXECUTION_MODE,BATCH);
                          SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_MODE,ASYNCHRONOUS);
                          SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYPE,CACHE);
                          SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESFORMAT,runformat);
                          SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_SERVER,reportserver);
                          
                          /* P_USER_CONNECT and P_SERVERNAME are custom parameters in the Reports 
                           module. P_ACTION is also a user defined variable in Reports and takes 
                           the web access path to the Report (does not need to be hard coded as 
                           in this sample )*/
                   
                         /* Change the hostname, port and cgi virtual directory to the one for 
                         your own machine */ 
                       
                          SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_OTHER,'P_PRE_AUTH_ID=' ||:MED_PRE_AUTH_LOG.PRE_AUTH_ID||' paramform=yes P_USER_CONNECT=' ||vc_connect||' P_SERVERNAME='||reportserver ||' P_ACTION= http://589.650.124.3:81/dev60cgi/rwcgi60.exe?');
                          report_message:= run_report_object(report_id);
                          rep_status := report_object_status(report_message);
                    
                         /* Wait for Report to be finished (asynchonous processing possible using
                         timers) */
                      
                                  WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')LOOP
                                          rep_status := report_object_status(report_message);
                                                                                                      
                                  END LOOP /* Wait for Report to be finished */;
                   
                         /* Change the cgi virtual directory to the one for your own machine */
                                 
                          IF rep_status='FINISHED' then
                                  web.show_document('/dev60cgi/rwcgi60.exe/getjobid='||report_message ||'?server='||reportserver,'_blank');
                          ELSE
                                          message (rep_status||'  Report output aborted');
                          END IF;
                   
                   
                  END;
                  --------------------------------------------------------------------------------------------------------

                  Thanks

                  Yasir

                  On 9/4/07, Arshad Jagirani < arsha801@...> wrote:
                  Dear Yasir,
                   
                  It is the issue of SSO (Single Sign ON) and NON-SSO users and it is the coding problem with so SSO ans NON-SSO, so show ur coding and i will identifiy ur problem.
                   
                  Regards
                  Arshad


                  yasir vohra <vohra.yasir@ gmail.com> wrote:
                  Dear Arshad,

                  Would you please share a little bit detail. I am facing the same problem.

                  I am using IAS 10g.

                  Thanks

                  Yasir

                  On 8/31/07, Imran Arshad <mimran@...> wrote:
                  There must be a popup blocker enabled on your browser.
                   
                   
                  Muhammad Imran Arshad
                   
                  -----Original Message-----
                  From: PkOug@yahoogroups.com [mailto: PkOug@ yahoogroups.com] On Behalf Of Arshad
                  Sent:
                  Friday, August 31, 2007 1:35 PM
                  To: PkOug@yahoogroups.com
                  Subject: [PkOug] Reports are not displaying in Oracle Application Server 10.1.2
                   
                  Asslam-O-Allaikum,

                  Dear members i just installed Forms and Reports Serveres and i
                  integrate my application forms are running successfuly but when i am
                  calling reports then there is no erorr is popup and report displaying
                  and but my calling report is in 'Finished Jobs' in Application Server
                  report server and when click on VIEW RESULT of calling report then
                  that calling report call from cache and show complete result with
                  success but at the calling time report from forms report is not
                  displaying result or any erorr.

                  but calling reports is calling successfuly from Developer

                  what should i do please tell me.

                  Arshad



                  --
                  ---------------------------------------------------------------------------------------------------------------------------------
                  Rgrds

                  VOHRA, YASIR
                  SENIOR SOFTWARE ENGINEER
                  (Information Technology)
                  ALLIANZ EFU HEALTH INSURANCE LTD.

                  http://www.allianz-efu.com
                  Tel: + 92 21 111- HEALTH Ext: 244
                  Technical Skill is the mastery of complexity, while Creativity is the mastery of simplicity
                  ----------------------------------------------------------------------------------------------------------------------------------



                  Arshad Jagirani
                  Oracle AS, DBA, Developer
                  DB2 9.1 Certified & I3 For Oracle Certified
                  (+92)-333-7124767

                  Boardwalk for $500? In 2007? Ha!
                  Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.



                  --
                  ---------------------------------------------------------------------------------------------------------------------------------
                  Rgrds

                  VOHRA, YASIR
                  SENIOR SOFTWARE ENGINEER
                  (Information Technology)
                  ALLIANZ EFU HEALTH INSURANCE LTD.

                  http://www.allianz-efu.com
                  Tel: + 92 21 111- HEALTH Ext: 244
                  Technical Skill is the mastery of complexity, while Creativity is the mastery of simplicity
                  ----------------------------------------------------------------------------------------------------------------------------------



                  Regards
                   
                  Maqbool Hussain Khan
                  Senior Systems Analyst / DBA
                  Fauji Fertilizer Company
                  Sadik Abad, Pakistan 
                  Ph: 92-068-5786420   Ext. Off. 3454 Res. 5637
                  Cell # 0300-8771914


                  Yahoo! oneSearch: Finally, mobile search that gives answers, not web links.

                  Official Website http://www.pkoug.org

                  Group Email: pkoug@...
                  To subscribe: addme_pkoug@...

                  To subscribe to these Special Interest Group (SIG), email at:
                     addme_dba@...  (DBA)
                     addme_ids@...  (Developer)
                     addme_ias@...  (Application Server)
                     addme_java@...   (Java with Oracle)
                     addme_ocs@...   (Content & Collaboration)
                     addme_apps@...   (Oracle Applications)
                     addme_linux@...  (Oracle on Linux)
                     addme_cg@...   (Career Guidance)
                     addme_dwhbi@...   (Data Warehousing & Business Intelligence)
                     addme_jobs@...   (Jobs related to Oracle)

                  Pakistan Oracle Users Group
                  -----------------------------------------------------------------------------------------------------------------------
                  Rgrds

                  VOHRA, YASIR
                  SENIOR SOFTWARE ENGINEER
                  (Information Technology)
                  ALLIANZ EFU HEALTH INSURANCE LTD.

                  http://www.allianz-efu.com
                  Tel: + 92 21 111- HEALTH Ext: 244
                  Technical Skill is the mastery of complexity, while Creativity is the mastery of simplicity
                  ----------------------------------------------------------------------------------------------------------------------------------
                • maqbool khan
                  Mr. yasir Have you created report object in form where are your calling this report Have you enabled SSO in yr config (formsweb.cfg) file maqbool yasir vohra
                  Message 8 of 11 , Sep 7, 2007
                  • 0 Attachment
                    Mr. yasir
                     
                    Have you created report object in form where are your calling this report
                     
                    Have you enabled SSO in yr config (formsweb.cfg) file
                     
                    maqbool

                    yasir vohra <vohra.yasir@...> wrote:

                    Dear Maqbool your required information is here. Looking for your reply.

                    On 9/5/07, maqbool khan <maqbl@yahoo. com > wrote:
                    Dear Yasir
                     
                    I can solve yr problem of Oracle 10g AS.
                     
                    Kindly give me following detail.
                     
                    1. Yr report object properties

                     







                            SET_REPORT_OBJECT_ PROPERTY( report_id, REPORT_EXECUTION _MODE,BATCH) ;
                            SET_REPORT_OBJECT_ PROPERTY( report_id, REPORT_COMM_ MODE,ASYNCHRONOU S);
                            SET_REPORT_OBJECT_ PROPERTY( report_id, REPORT_DESTYPE, CACHE);
                            SET_REPORT_OBJECT_ PROPERTY( report_id, REPORT_DESFORMAT ,runformat) ;
                            SET_REPORT_OBJECT_ PROPERTY( report_id, REPORT_SERVER, reportserver) ;

                    SET_REPORT_OBJECT_ PROPERTY( report_id, REPORT_OTHER,'P_PRE_AUTH_ID=' ||:MED_PRE_AUTH_ LOG.PRE_AUTH_ ID||' paramform=yes P_USER_CONNECT=' ||vc_connect| |' P_SERVERNAME='||reportserver ||' P_ACTION=http://589.650. 124.3:81/ dev60cgi/ rwcgi60.exe?');



                    2. Whether you are using Parameter form with report. YES
                    3. If you are using parameter form, whether it is developed in Form builder or report builder THE PARAMETER FORM IS DEVELOPED IN REPORT BUILDER

                     

                    4. You are using SSO mode or not "WHERE TO FIND THIS?"
                     
                    regards


                    yasir vohra <vohra.yasir@gmail.com> wrote:
                    Dear Arshad,

                    Below is the code that i am using to run the report. Looking for your reply.
                    ------------ --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- ---
                    PROCEDURE RUN_REPORT_OBJECT_ PROC(report_ id REPORT_OBJECT, reportserver varchar2,
                    runformat varchar2) IS
                     
                    report_message   VARCHAR2(100) ;
                    rep_status       VARCHAR2(100) ;
                    vc_user_name     VARCHAR2(100) ;
                    vc_user_password VARCHAR2(100) ;
                    vc_user_connect  VARCHAR2(100) ;
                    vc_connect       VARCHAR2(300) ;          
                    BEGIN
                            /* get user connect string */                
                            vc_user_name: =get_application _property( username) ;
                            vc_user_password: =get_application _property( password) ;
                            vc_user_connect: =get_application _property( connect_string) ;
                            vc_connect:= vc_user_name| |'/'||vc_user_password| |'@'||vc_user_connect;
                                     
                            /*set Reports properties for run_report_object* /
                            
                            SET_REPORT_OBJECT_ PROPERTY( report_id, REPORT_EXECUTION _MODE,BATCH) ;
                            SET_REPORT_OBJECT_ PROPERTY( report_id, REPORT_COMM_ MODE,ASYNCHRONOU S);
                            SET_REPORT_OBJECT_ PROPERTY( report_id, REPORT_DESTYPE, CACHE);
                            SET_REPORT_OBJECT_ PROPERTY( report_id, REPORT_DESFORMAT ,runformat) ;
                            SET_REPORT_OBJECT_ PROPERTY( report_id, REPORT_SERVER, reportserver) ;
                            
                            /* P_USER_CONNECT and P_SERVERNAME are custom parameters in the Reports 
                             module. P_ACTION is also a user defined variable in Reports and takes 
                             the web access path to the Report (does not need to be hard coded as 
                             in this sample )*/
                     
                           /* Change the hostname, port and cgi virtual directory to the one for 
                           your own machine */ 
                         
                            SET_REPORT_OBJECT_ PROPERTY( report_id, REPORT_OTHER,'P_PRE_AUTH_ID=' ||:MED_PRE_AUTH_ LOG.PRE_AUTH_ ID||' paramform=yes P_USER_CONNECT=' ||vc_connect| |' P_SERVERNAME='||reportserver ||' P_ACTION= http://589.650. 124.3:81/ dev60cgi/ rwcgi60.exe?');
                            report_message: = run_report_object( report_id) ;
                            rep_status := report_object_ status(report_ message);
                      
                           /* Wait for Report to be finished (asynchonous processing possible using
                           timers) */
                        
                                    WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')LOOP
                                            rep_status := report_object_ status(report_ message);
                                                                                                        
                                    END LOOP /* Wait for Report to be finished */;
                     
                           /* Change the cgi virtual directory to the one for your own machine */
                                   
                            IF rep_status='FINISHED' then
                                    web.show_document('/dev60cgi/rwcgi60. exe/getjobid='||report_message ||'?server='||reportserver,'_blank');
                            ELSE
                                            message (rep_status| |'  Report output aborted');
                            END IF;
                     
                     
                    END;
                    ------------ --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --

                    Thanks

                    Yasir

                    On 9/4/07, Arshad Jagirani < arsha801@yahoo. com> wrote:
                    Dear Yasir,
                     
                    It is the issue of SSO (Single Sign ON) and NON-SSO users and it is the coding problem with so SSO ans NON-SSO, so show ur coding and i will identifiy ur problem.
                     
                    Regards
                    Arshad


                    yasir vohra <vohra.yasir@ gmail.com> wrote:
                    Dear Arshad,

                    Would you please share a little bit detail. I am facing the same problem.

                    I am using IAS 10g.

                    Thanks

                    Yasir

                    On 8/31/07, Imran Arshad <mimran@.... pk> wrote:
                    There must be a popup blocker enabled on your browser.
                     
                     
                    Muhammad Imran Arshad
                     
                    -----Original Message-----
                    From: PkOug@yahoogroups. com [mailto: PkOug@ yahoogroups. com] On Behalf Of Arshad
                    Sent:
                    Friday, August 31, 2007 1:35 PM
                    To: PkOug@yahoogroups. com
                    Subject: [PkOug] Reports are not displaying in Oracle Application Server 10.1.2
                     
                    Asslam-O-Allaikum,

                    Dear members i just installed Forms and Reports Serveres and i
                    integrate my application forms are running successfuly but when i am
                    calling reports then there is no erorr is popup and report displaying
                    and but my calling report is in 'Finished Jobs' in Application Server
                    report server and when click on VIEW RESULT of calling report then
                    that calling report call from cache and show complete result with
                    success but at the calling time report from forms report is not
                    displaying result or any erorr.

                    but calling reports is calling successfuly from Developer

                    what should i do please tell me.

                    Arshad



                    --
                    ------------ --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- ---------
                    Rgrds

                    VOHRA, YASIR
                    SENIOR SOFTWARE ENGINEER
                    (Information Technology)
                    ALLIANZ EFU HEALTH INSURANCE LTD.

                    http://www.allianz- efu.com
                    Tel: + 92 21 111- HEALTH Ext: 244
                    Technical Skill is the mastery of complexity, while Creativity is the mastery of simplicity
                    ------------ --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- -



                    Arshad Jagirani
                    Oracle AS, DBA, Developer
                    DB2 9.1 Certified & I3 For Oracle Certified
                    (+92)-333-7124767

                    Boardwalk for $500? In 2007? Ha!
                    Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.



                    --
                    ------------ --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- ---------
                    Rgrds

                    VOHRA, YASIR
                    SENIOR SOFTWARE ENGINEER
                    (Information Technology)
                    ALLIANZ EFU HEALTH INSURANCE LTD.

                    http://www.allianz- efu.com
                    Tel: + 92 21 111- HEALTH Ext: 244
                    Technical Skill is the mastery of complexity, while Creativity is the mastery of simplicity
                    ------------ --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- -



                    Regards
                     
                    Maqbool Hussain Khan
                    Senior Systems Analyst / DBA
                    Fauji Fertilizer Company
                    Sadik Abad, Pakistan 
                    Ph: 92-068-5786420   Ext. Off. 3454 Res. 5637
                    Cell # 0300-8771914

                    Yahoo! oneSearch: Finally, mobile search that gives answers, not web links.
                    Official Website http://www.pkoug. org

                    Group Email: pkoug@pkoug. org
                    To subscribe: addme_pkoug@ pkoug.org

                    To subscribe to these Special Interest Group (SIG), email at:
                       addme_dba@pkoug. org  (DBA)
                       addme_ids@pkoug. org  (Developer)
                       addme_ias@pkoug. org  (Application Server)
                       addme_java@pkoug. org   (Java with Oracle)
                       addme_ocs@pkoug. org   (Content & Collaboration)
                       addme_apps@pkoug. org   (Oracle Applications)
                       addme_linux@ pkoug.org  (Oracle on Linux)
                       addme_cg@pkoug. org   (Career Guidance)
                       addme_dwhbi@ pkoug.org   (Data Warehousing & Business Intelligence)
                       addme_jobs@pkoug. org   (Jobs related to Oracle)

                    Pakistan Oracle Users Group
                    ------------ --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------
                    Rgrds

                    VOHRA, YASIR
                    SENIOR SOFTWARE ENGINEER
                    (Information Technology)
                    ALLIANZ EFU HEALTH INSURANCE LTD.

                    http://www.allianz- efu.com
                    Tel: + 92 21 111- HEALTH Ext: 244
                    Technical Skill is the mastery of complexity, while Creativity is the mastery of simplicity
                    ------------ --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- --------- -



                    Regards
                     
                    Maqbool Hussain Khan
                    Senior Systems Analyst / DBA
                    Fauji Fertilizer Company
                    Sadik Abad, Pakistan 
                    Ph: 92-068-5786420   Ext. Off. 3454 Res. 5637
                    Cell # 0300-8771914


                    Building a website is a piece of cake.
                    Yahoo! Small Business gives you all the tools to get online.

                  • Arshad
                    Salam Dear Yasir, Sorry I am late, dear Create this procedur PROCEDURE RUN_REPORT_OBJECT_PROC (report_id REPORT_OBJECT, report_server_name varchar2,
                    Message 9 of 11 , Sep 8, 2007
                    • 0 Attachment
                      Salam Dear Yasir,
                      Sorry I am late,

                      dear Create this procedur
                      PROCEDURE RUN_REPORT_OBJECT_PROC (report_id REPORT_OBJECT,
                      report_server_name varchar2,
                      report_format varchar2,
                      report_destype_name number,
                      report_file_name varchar2,
                      report_otherparam varchar2,
                      reports_servlet varchar2
                      ) IS
                      report_message VARCHAR2(100) :='';
                      rep_status VARCHAR2(100) :='';
                      vjob_id VARCHAR2(4000) :='';
                      hidden_action VARCHAR2(2000) :='';
                      v_report_other VARCHAR2(4000) :='';
                      i number (5);
                      c char;
                      c_old char;
                      c_new char;
                      sso_user VARCHAR2(100);
                      BEGIN
                      -- setting Reports runtime parameters
                      SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_MODE,SYNCHRONOUS);
                      SET_REPORT_OBJECT_PROPERTY
                      (report_id,REPORT_FILENAME,report_file_name);
                      SET_REPORT_OBJECT_PROPERTY
                      (report_id,REPORT_SERVER,report_server_name);
                      SET_REPORT_OBJECT_PROPERTY
                      (report_id,REPORT_DESTYPE,report_destype_name);
                      SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESFORMAT,report_format);
                      -- creating string for pfaction parameter
                      hidden_action := hidden_action ||'&report='
                      ||GET_REPORT_OBJECT_PROPERTY(report_id,REPORT_FILENAME);
                      hidden_action := hidden_action ||'&destype='
                      ||GET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYPE);
                      hidden_action := hidden_action ||'&desformat='
                      ||GET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESFORMAT);
                      -- determine whether single sign-on is used or not. In the case
                      -- of single sign-on add the ssoconn parameter to the
                      -- If run in normal mode, just use userid
                      sso_user := get_application_property(sso_userid);
                      IF (length(sso_user) > 0) THEN
                      -- sso is used
                      hidden_action := hidden_action||'&ssoconn='||:parameter.config;
                      ELSE
                      -- no sso
                      hidden_action := hidden_action ||'&userid=
                      ||get_application_property(username)||'/'
                      ||get_application_property(password)||'@'
                      ||get_application_property(connect_string);
                      END IF;
                      -- report other parameters are passed as key value pairs
                      -- "key1=value1 key2=value2 ..."
                      -- the following loop replaces the delimiting blank with an '&'
                      -- used on the Web.
                      -- c_old is initialized with a dummy value
                      c_old :='@';
                      FOR i IN 1..LENGTH(report_otherparam) LOOP
                      c_new:= substr(report_otherparam,i,1);
                      IF (c_new =' ') THEN
                      c:='&';
                      ELSE
                      c:= c_new;
                      END IF;
                      -- eliminate multiple blanks
                      IF (c_old =' ' and c_new = ' ') THEN
                      null;
                      ELSE
                      v_report_other := v_report_other||c;
                      END IF;
                      -- save current value as old value
                      c_old := c_new;
                      END LOOP;
                      hidden_action := hidden_action ||'&'||v_report_other;
                      -- report_servlet contains the full path to the Reports Servlet
                      -- Example1, Forms and Reports are on the same host
                      -- reports_servlet:='/reports/rwservlet'
                      -- Example2, Forms and Reports are on separate hosts

                      -- reports_servlet:='http://host:port/reports/rwservlet'
                      hidden_action := reports_servlet||
                      '?_hidden_server='||report_server_name||encode(hidden_action);
                      -- Set pfaction to the report
                      SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_OTHER,'pfaction='
                      ||hidden_action||' '||report_otherparam);
                      report_message:= run_report_object(report_id);
                      rep_status := report_object_status(report_message);
                      IF rep_status='FINISHED' THEN
                      vjob_id := substr(report_message,
                      length(report_server_name)+2,length(report_message));
                      WEB.SHOW_DOCUMENT(reports_servlet||'/getjobid'||vjob_id
                      ||'?server='||report_server_name,' _blank');
                      ELSE
                      --handle errors
                      message ('Error');
                      END IF;
                      END;

                      And Dear Crearte this Function For ENCODE hidden_action

                      FUNCTION ENCODE (URL_PARAMS_IN Varchar2) RETURN VARCHAR2 IS
                      v_url VARCHAR2(2000) := URL_PARAMS_IN; -- Url string
                      v_url_temp VARCHAR2(4000) :=''; -- Temp URL string
                      v_a VARCHAR2(10);
                      -- conversion variable
                      v_b VARCHAR2(10);
                      -- conversion variable
                      c CHAR;
                      i NUMBER(10);
                      BEGIN
                      FOR i IN 1..LENGTH(v_url) LOOP
                      c:= substr(v_url,i,1);
                      IF c in (';', '/','?',':','@','+','$',',',' ') THEN
                      v_a := ltrim(to_char(trunc(ascii(substr(v_url,i,1))/16)));
                      IF v_a = '10' THEN v_a := 'A';
                      ELSIF v_a = '11' THEN v_a := 'B';
                      ELSIF v_a = '12' THEN v_a := 'C';
                      ELSIF v_a = '13' THEN v_a := 'D';
                      ELSIF v_a = '14' THEN v_a := 'E';
                      ELSIF v_a = '15' THEN v_a := 'F';
                      END IF;
                      v_b := ltrim(to_char(mod(ascii(substr(v_url,i,1)),16)));
                      IF v_b = '10' THEN v_b := 'A';
                      ELSIF v_b = '11' THEN v_b := 'B';
                      ELSIF v_b = '12' THEN v_b := 'C';
                      ELSIF v_b = '13' THEN v_b := 'D';
                      ELSIF v_b = '14' THEN v_b := 'E';
                      ELSIF v_b = '15' THEN v_b := 'F';
                      END IF;
                      v_url_temp := v_url_temp||'%'||v_a||v_b;
                      ELSE
                      v_url_temp :=v_url_temp||c;
                      END IF;
                      END LOOP;
                      return v_url_temp;
                      END;

                      And dear Yasir nor call Procedure in When_Button_Pressed or on your
                      action.
                      Like this,


                      DECLARE
                      report_id Report_Object;
                      v_report_other VARCHAR2(4000);
                      BEGIN
                      /* Call run_report_object */
                      report_id:= find_report_object('reptest');
                      v_report_other:= 'paramform=yes p_deptno='||:DEPT.DEPTNO;
                      RUN_REPORT_OBJECT_PROC(report_id,
                      :parameter.reportsserver,
                      'HTMLCSS',
                      CACHE,
                      'reptest.rdf',
                      v_report_other,
                      '/reports/rwservlet');
                      END;

                      Dear Yasir,
                      This solution will solve your problem either your Application Server
                      configuration according to SSO or NON-SSO Just pass few parameters
                      to RUN_REPORT_OBJECT_PROC.

                      IF you find an other problem then contact me i will try to solve

                      Regards

                      Arshad Jagirani.


                      PkOug@yahoogroups.com, "yasir vohra" <vohra.yasir@...> wrote:
                      >
                      > Dear Maqbool your required information is here. Looking for your
                      reply.
                      >
                      > On 9/5/07, maqbool khan <maqbl@...> wrote:
                      > >
                      > > Dear Yasir
                      > >
                      > > I can solve yr problem of Oracle 10g AS.
                      > >
                      > > Kindly give me following detail.
                      > >
                      > > 1. Yr report object properties
                      > >
                      >
                      >
                      >
                      >
                      >
                      >
                      >
                      >
                      >
                      > SET_REPORT_OBJECT_PROPERTY
                      (report_id,REPORT_EXECUTION_MODE,BATCH);
                      > SET_REPORT_OBJECT_PROPERTY
                      (report_id,REPORT_COMM_MODE,ASYNCHRONOUS);
                      > SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYPE,CACHE);
                      > SET_REPORT_OBJECT_PROPERTY
                      (report_id,REPORT_DESFORMAT,runformat);
                      > SET_REPORT_OBJECT_PROPERTY
                      (report_id,REPORT_SERVER,reportserver);
                      >
                      > SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_OTHER,'P_PRE_AUTH_ID='
                      > > ||:MED_PRE_AUTH_LOG.PRE_AUTH_ID||' paramform=yes P_USER_CONNECT='
                      > > ||vc_connect||' P_SERVERNAME='||reportserver ||' P_ACTION=
                      > >
                      http://589.650.124.3:81/dev60cgi/rwcgi60.exe?'<http://589.650.124.3:8
                      1/dev60cgi/rwcgi60.exe?%27>
                      > > );
                      > >
                      > >
                      >
                      > 2. Whether you are using Parameter form with report. YES
                      > > 3. If you are using parameter form, whether it is developed in
                      Form
                      > > builder or report builder THE PARAMETER FORM IS DEVELOPED IN
                      REPORT
                      > > BUILDER
                      > >
                      >
                      >
                      >
                      > 4. You are using SSO mode or not "WHERE TO FIND THIS?"
                      > >
                      > > regards
                      > >
                      > >
                      > > *yasir vohra <vohra.yasir@...>* wrote:
                      > >
                      > > Dear Arshad,
                      > >
                      > > Below is the code that i am using to run the report. Looking for
                      your
                      > > reply.
                      > > -----------------------------------------------------------------
                      ---------------------------------------------------------------------
                      -------
                      > >
                      > > PROCEDURE RUN_REPORT_OBJECT_PROC(report_id REPORT_OBJECT,
                      reportserver
                      > > varchar2,
                      > > runformat varchar2) IS
                      > >
                      > > report_message VARCHAR2(100);
                      > > rep_status VARCHAR2(100);
                      > > vc_user_name VARCHAR2(100);
                      > > vc_user_password VARCHAR2(100);
                      > > vc_user_connect VARCHAR2(100);
                      > > vc_connect VARCHAR2(300);
                      > > BEGIN
                      > > /* get user connect string */
                      > > vc_user_name:=get_application_property(username);
                      > > vc_user_password:=get_application_property(password);
                      > > vc_user_connect:=get_application_property
                      (connect_string);
                      > >
                      > >
                      vc_connect:=vc_user_name||'/'||vc_user_password||'@'||vc_user_connect
                      ;
                      > >
                      > > /*set Reports properties for run_report_object*/
                      > >
                      > > SET_REPORT_OBJECT_PROPERTY
                      (report_id,REPORT_EXECUTION_MODE,BATCH);
                      > >
                      > >
                      > > SET_REPORT_OBJECT_PROPERTY
                      (report_id,REPORT_COMM_MODE,ASYNCHRONOUS);
                      > > SET_REPORT_OBJECT_PROPERTY
                      (report_id,REPORT_DESTYPE,CACHE);
                      > > SET_REPORT_OBJECT_PROPERTY
                      (report_id,REPORT_DESFORMAT,runformat);
                      > > SET_REPORT_OBJECT_PROPERTY
                      (report_id,REPORT_SERVER,reportserver);
                      > >
                      > > /* P_USER_CONNECT and P_SERVERNAME are custom parameters
                      in the
                      > > Reports
                      > > module. P_ACTION is also a user defined variable in
                      Reports and
                      > > takes
                      > > the web access path to the Report (does not need to be
                      hard coded
                      > > as
                      > > in this sample )*/
                      > >
                      > > /* Change the hostname, port and cgi virtual directory to
                      the one
                      > > for
                      > > your own machine */
                      > >
                      > > SET_REPORT_OBJECT_PROPERTY
                      (report_id,REPORT_OTHER,'P_PRE_AUTH_ID='
                      > > ||:MED_PRE_AUTH_LOG.PRE_AUTH_ID||' paramform=yes P_USER_CONNECT='
                      > > ||vc_connect||' P_SERVERNAME='||reportserver ||' P_ACTION=
                      > >
                      http://589.650.124.3:81/dev60cgi/rwcgi60.exe?'<http://589.650.124.3:8
                      1/dev60cgi/rwcgi60.exe?%27>);
                      > >
                      > > report_message:= run_report_object(report_id);
                      > > rep_status := report_object_status(report_message);
                      > >
                      > > /* Wait for Report to be finished (asynchonous processing
                      possible
                      > > using
                      > > timers) */
                      > >
                      > > WHILE rep_status in
                      > > ('RUNNING','OPENING_REPORT','ENQUEUED')LOOP
                      > > rep_status :=
                      > > report_object_status(report_message);
                      > >
                      > >
                      > > END LOOP /* Wait for Report to be finished */;
                      > >
                      > > /* Change the cgi virtual directory to the one for your
                      own machine
                      > > */
                      > >
                      > > IF rep_status='FINISHED' then
                      > > web.show_document
                      ('/dev60cgi/rwcgi60.exe/getjobid='||report_message
                      > > ||'?server='||reportserver,'_blank');
                      > > ELSE
                      > > message (rep_status||' Report output
                      aborted');
                      > > END IF;
                      > >
                      > >
                      > > END;
                      > > -----------------------------------------------------------------
                      ---------------------------------------
                      > >
                      > >
                      > > Thanks
                      > >
                      > > Yasir
                      > >
                      > > On 9/4/07, Arshad Jagirani <arsha801@...> wrote:
                      > > >
                      > > > Dear Yasir,
                      > > >
                      > > > It is the issue of SSO (Single Sign ON) and NON-SSO users and
                      it is the
                      > > > coding problem with so SSO ans NON-SSO, so show ur coding and
                      i will
                      > > > identifiy ur problem.
                      > > >
                      > > > Regards
                      > > > Arshad
                      > > >
                      > > > *yasir vohra <vohra.yasir@ gmail.com>* wrote:
                      > > >
                      > > > Dear Arshad,
                      > > >
                      > > > Would you please share a little bit detail. I am facing the
                      same
                      > > > problem.
                      > > >
                      > > > I am using IAS 10g.
                      > > >
                      > > > Thanks
                      > > >
                      > > > Yasir
                      > > >
                      > > > On 8/31/07, Imran Arshad <mimran@...> wrote:
                      > > > >
                      > > > > There must be a *popup blocker* enabled on your browser.
                      > > > >
                      > > > >
                      > > > > Muhammad Imran Arshad
                      > > > >
                      > > > > -----Original Message-----
                      > > > > *From:* PkOug@yahoogroups.com [mailto:PkOug@
                      yahoogroups.com] *On
                      > > > > Behalf Of *Arshad
                      > > > > *Sent:* Friday, August 31, 2007 1:35 PM
                      > > > > *To:* PkOug@yahoogroups.com
                      > > > > *Subject:* [PkOug] Reports are not displaying in Oracle
                      Application
                      > > > > Server 10.1.2
                      > > > >
                      > > > > Asslam-O-Allaikum,
                      > > > >
                      > > > > Dear members i just installed Forms and Reports Serveres and
                      i
                      > > > > integrate my application forms are running successfuly but
                      when i am
                      > > > > calling reports then there is no erorr is popup and report
                      displaying
                      > > > > and but my calling report is in 'Finished Jobs' in
                      Application Server
                      > > > > report server and when click on VIEW RESULT of calling
                      report then
                      > > > > that calling report call from cache and show complete result
                      with
                      > > > > success but at the calling time report from forms report is
                      not
                      > > > > displaying result or any erorr.
                      > > > >
                      > > > > but calling reports is calling successfuly from Developer
                      > > > >
                      > > > > what should i do please tell me.
                      > > > >
                      > > > > Arshad
                      > > > >
                      > > >
                      > > >
                      > > >
                      > > > --
                      > > > ---------------------------------------------------------------
                      ------------------------------------------------------------------
                      > > >
                      > > > Rgrds
                      > > >
                      > > > VOHRA, YASIR
                      > > > SENIOR SOFTWARE ENGINEER
                      > > > (Information Technology)
                      > > > ALLIANZ EFU HEALTH INSURANCE LTD.
                      > > >
                      > > > http://www.allianz-efu.com
                      > > > Tel: + 92 21 111- HEALTH Ext: 244
                      > > > Technical Skill is the mastery of complexity, while Creativity
                      is the
                      > > > mastery of simplicity
                      > > > ---------------------------------------------------------------
                      -------------------------------------------------------------------
                      > > >
                      > > >
                      > > >
                      > > >
                      > > >
                      > > > *Arshad Jagirani*
                      > > > arshadjagirani@...
                      > > > *Oracle AS, DBA, Developer*
                      > > > *DB2 9.1 Certified & I3 For Oracle Certified *
                      > > > *(+92)-333-7124767*
                      > > > ------------------------------
                      > > > Boardwalk for $500? In 2007? Ha!
                      > > > Play Monopoly Here and
                      Now<http://us.rd.yahoo.com/evt=48223/*http://get.games.yahoo.com/prod
                      desc?gamekey=monopolyherenow>(it's updated for today's economy) at
                      Yahoo! Games.
                      > > >
                      > >
                      > >
                      > >
                      > > --
                      > >
                      > > -----------------------------------------------------------------
                      ----------------------------------------------------------------
                      > > Rgrds
                      > >
                      > > VOHRA, YASIR
                      > > SENIOR SOFTWARE ENGINEER
                      > > (Information Technology)
                      > > ALLIANZ EFU HEALTH INSURANCE LTD.
                      > >
                      > > http://www.allianz-efu.com
                      > > Tel: + 92 21 111- HEALTH Ext: 244
                      > > Technical Skill is the mastery of complexity, while Creativity
                      is the
                      > > mastery of simplicity
                      > > -----------------------------------------------------------------
                      -----------------------------------------------------------------
                      > >
                      > >
                      > >
                      > >
                      > >
                      > > *Regards*
                      > >
                      > > *Maqbool Hussain Khan
                      > > Senior Systems Analyst / DBA
                      > > Fauji Fertilizer Company
                      > > Sadik Abad, Pakistan
                      > > Ph: 92-068-5786420 Ext. Off. 3454 Res. 5637*
                      > > *Cell # 0300-8771914*
                      > >
                      > > ------------------------------
                      > > Yahoo! oneSearch: Finally, mobile search that gives
                      answers<http://us.rd.yahoo.com/evt=48252/*http://mobile.yahoo.com/mob
                      ileweb/onesearch?refer=1ONXIC>,
                      > > not web links.
                      > >
                      > > Messages in this topic
                      > >
                      <http://groups.yahoo.com/group/PkOug/message/3583;_ylc=X3oDMTM0bzlubD
                      JyBF9TAzk3MzU5NzE0BGdycElkAzcyNDIyODcEZ3Jwc3BJZAMxNzA1MTE1MzY4BG1zZ0l
                      kAzM2MDkEc2VjA2Z0cgRzbGsDdnRwYwRzdGltZQMxMTg4OTc0MDE5BHRwY0lkAzM1ODM-
                      >(
                      > > 0) Reply (via web post)
                      > >
                      <http://groups.yahoo.com/group/PkOug/post;_ylc=X3oDMTJwbmY3aDc1BF9TAz
                      k3MzU5NzE0BGdycElkAzcyNDIyODcEZ3Jwc3BJZAMxNzA1MTE1MzY4BG1zZ0lkAzM2MDk
                      Ec2VjA2Z0cgRzbGsDcnBseQRzdGltZQMxMTg4OTc0MDE5?
                      act=reply&messageNum=3609>| Start
                      > > a new topic
                      > >
                      <http://groups.yahoo.com/group/PkOug/post;_ylc=X3oDMTJlaW01c2hrBF9TAz
                      k3MzU5NzE0BGdycElkAzcyNDIyODcEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2x
                      rA250cGMEc3RpbWUDMTE4ODk3NDAxOQ-->
                      > >
                      Messages<http://groups.yahoo.com/group/PkOug/messages;_ylc=X3oDMTJlY3
                      E1OGFnBF9TAzk3MzU5NzE0BGdycElkAzcyNDIyODcEZ3Jwc3BJZAMxNzA1MTE1MzY4BHN
                      lYwNmdHIEc2xrA21zZ3MEc3RpbWUDMTE4ODk3NDAxOQ-->|
                      > >
                      Files<http://groups.yahoo.com/group/PkOug/files;_ylc=X3oDMTJmb3V2YXJm
                      BF9TAzk3MzU5NzE0BGdycElkAzcyNDIyODcEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmd
                      HIEc2xrA2ZpbGVzBHN0aW1lAzExODg5NzQwMTk->|
                      > >
                      Photos<http://groups.yahoo.com/group/PkOug/photos;_ylc=X3oDMTJlajk4ZD
                      ZwBF9TAzk3MzU5NzE0BGdycElkAzcyNDIyODcEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwN
                      mdHIEc2xrA3Bob3QEc3RpbWUDMTE4ODk3NDAxOQ-->|
                      > >
                      Links<http://groups.yahoo.com/group/PkOug/links;_ylc=X3oDMTJmdTNuaXMy
                      BF9TAzk3MzU5NzE0BGdycElkAzcyNDIyODcEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmd
                      HIEc2xrA2xpbmtzBHN0aW1lAzExODg5NzQwMTk->|
                      > >
                      Database<http://groups.yahoo.com/group/PkOug/database;_ylc=X3oDMTJjaj
                      J1aGUyBF9TAzk3MzU5NzE0BGdycElkAzcyNDIyODcEZ3Jwc3BJZAMxNzA1MTE1MzY4BHN
                      lYwNmdHIEc2xrA2RiBHN0aW1lAzExODg5NzQwMTk->|
                      > >
                      Polls<http://groups.yahoo.com/group/PkOug/polls;_ylc=X3oDMTJmN2E3YTY3
                      BF9TAzk3MzU5NzE0BGdycElkAzcyNDIyODcEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmd
                      HIEc2xrA3BvbGxzBHN0aW1lAzExODg5NzQwMTk->|
                      > >
                      Calendar<http://groups.yahoo.com/group/PkOug/calendar;_ylc=X3oDMTJkZn
                      J2NWt2BF9TAzk3MzU5NzE0BGdycElkAzcyNDIyODcEZ3Jwc3BJZAMxNzA1MTE1MzY4BHN
                      lYwNmdHIEc2xrA2NhbARzdGltZQMxMTg4OTc0MDE5>
                      > > Official Website http://www.pkoug.org
                      > >
                      > > Group Email: pkoug@...
                      > > To subscribe: addme_pkoug@...
                      > >
                      > > To subscribe to these Special Interest Group (SIG), email at:
                      > > addme_dba@... (DBA)
                      > > addme_ids@... (Developer)
                      > > addme_ias@... (Application Server)
                      > > addme_java@... (Java with Oracle)
                      > > addme_ocs@... (Content & Collaboration)
                      > > addme_apps@... (Oracle Applications)
                      > > addme_linux@... (Oracle on Linux)
                      > > addme_cg@... (Career Guidance)
                      > > addme_dwhbi@... (Data Warehousing & Business Intelligence)
                      > > addme_jobs@... (Jobs related to Oracle)
                      > >
                      > > Pakistan Oracle Users Group
                      > > [image: Yahoo! Groups]
                      <http://groups.yahoo.com/;_ylc=X3oDMTJkczlhbnEyBF9TAzk3NDc2NTkwBGdycE
                      lkAzcyNDIyODcEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA2dmcARzdGltZQM
                      xMTg4OTc0MDE5>
                      > > Change settings via the
                      Web<http://groups.yahoo.com/group/PkOug/join;_ylc=X3oDMTJmcDdmaDhlBF9
                      TAzk3NDc2NTkwBGdycElkAzcyNDIyODcEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIE
                      c2xrA3N0bmdzBHN0aW1lAzExODg5NzQwMTk->(Yahoo! ID required)
                      > > Change settings via email: Switch delivery to Daily Digest<PkOug-
                      digest@yahoogroups.com?subject=Email+Delivery:+Digest>| Switch
                      > > format to Traditional<PkOug-traditional@yahoogroups.com?
                      subject=Change+Delivery+Format:+Traditional>
                      > > Visit Your Group
                      > >
                      <http://groups.yahoo.com/group/PkOug;_ylc=X3oDMTJkbXYzaHJ1BF9TAzk3NDc
                      2NTkwBGdycElkAzcyNDIyODcEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdHIEc2xrA2hw
                      ZgRzdGltZQMxMTg4OTc0MDE5>| Yahoo!
                      > > Groups Terms of Use <http://docs.yahoo.com/info/terms/> |
                      Unsubscribe
                      > > <PkOug-unsubscribe@yahoogroups.com?subject=>
                      > >
                      > -------------------------------------------------------------------
                      ----------------------------------------------------
                      > Rgrds
                      >
                      > VOHRA, YASIR
                      > SENIOR SOFTWARE ENGINEER
                      > (Information Technology)
                      > ALLIANZ EFU HEALTH INSURANCE LTD.
                      >
                      > http://www.allianz-efu.com
                      > Tel: + 92 21 111- HEALTH Ext: 244
                      > Technical Skill is the mastery of complexity, while Creativity is
                      the
                      > mastery of simplicity
                      > -------------------------------------------------------------------
                      ---------------------------------------------------------------
                      >
                    Your message has been successfully submitted and would be delivered to recipients shortly.