1 Reply Latest reply on Oct 30, 2013 3:28 PM by 579492

    Link to a Discoverer Workbook




      I have tried creating link from of discover work in self service page using below link in R12 but i got an error saying that " The page cannot be found

      The page you are looking for might have been removed, had its name changed, or is temporarily unavailable. " 


      Please let me know if any ideas



      Also i have tried with standared function mentioned in note (


      Please let me know if any inputs.


        • 1. Re: Link to a Discoverer Workbook

          Hi Subbu -


          Are you basically trying to launch Discoverer workbook from EBS?

          frist check your profile options are correct:


          ICX: Discoverer Launcher    http://tsterp21.ekkorg.local:8090/discoverer/plus?Connect=[APPS_SECURE]

          ICX: Discoverer Viewer Launcher        http://tsterp21.ekkorg.local:8090/discoverer/viewer?Connect=[APPS_SECURE]


          to get you wrokbook working fine follow below steps(these steps are for 11i, just couple changes for r12):

          The basic process is:


          1. Create the workbook.
          2. Open the workbook in the Discoverer Desktop or Plus edition and go to
          'File->Manage Workbooks->Properties' look for the value for 'Identifier'. Save this value.
          3. Create a form function. Open the Function form and create a new function.
          Define the Form Function.
          The form function definition includes the properties listed in these tabs:
          3.1 Description tab:
          3.1.1 Function Name: BIS_[X] (use something to distinguish it from seeded functions)
          3.1.2 User Function Name: This is the name that will show in the menu
          3.1.3 Description: Add a description of the function if you want.
          3.2 Properties tab:
          3.2.1 Type: Select "SSWA plsql function"
          3.2.2 Maintenance Mode Support: Leave as "None"
          3.2.3 Context Dependence: Leave as "Responsibility"
          3.3 Form tab:
          3.3.1 Form: Leave the field blank.
          3.3.2 Application: Leave the field blank.
          3.3.3 Parameters: workbook=<(workbook identifier from step2) &PARAMETERS=sheetid~worksheet id*param_parameter name One~Parameter One Value*param_parameter name Two~Parameter Two Value*

          Eg; 'workbook=TEST_WORKBOOK&PARAMETERS=sheetid~1*'  would open sheet 1 of the workbook.

          # According to the Applications Administration Edition the workbook name will also work here.
          See Expanation section below for more information on setting up parameters and changes fro Discoverer Viewer.
          3.4 Web HTML tab:
          3.4.1 HTML call : Set as OracleOasis.RunDiscoverer
          3.5 Web Host tab:
          3.5.1 Leave all fields blank.
          3.6 Region tab:
          3.6.1 Leave all fields blank.
          3.7 Save the form.
          4. Open the menu form as sysadmin.
          4.1 Search for the main menu under which you want the link to appear.
          4.2 Add the information you need such as prompt, submenu, description etc.
          4.3 Enter into the Function field the name of the function you created in step 3.
          4.4 Save the menu form.
          A message will appear saying that a concurrent program will run to regenerate the menus.
          You can cancel it if you want and do step 5 below if the menu does not appear after the concurrent program runs.


          5. Use adadmin and recompile the menu information to make the changes appear.
          6. Bounce Apache and Forms.