1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

discoverer report

Discussion in 'Oracle Discoverer' started by Bharat, Apr 28, 2012.

  1. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi,

    Can I know how to move discoverer report or workbook to application level. We have given parameter as 'workbook=XXX_ITEM_REPORT' and added to Order management menu, and when I click on that its not opening that workbook, and just getting " no page found " page. Please help me on this.
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi all,

    Can anyone help me on this issue. How to move discoverer workbook or report to application level. I have tried by passing parameter as 'workbook=XXX_ITEM_REPORT' and added to Order management menu. But its not opening the page and showing error as "no page found".
     
  3. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Try this...You have developed your workbook
    Step 1: Login to Application Developer>Function
    Enter Function , User Function Name, Description(Optional) in Description Tab
    Step 2: In the Properties Tab
    Select Type =“SSWA plsql function”
    Maintenance Mode Support – None
    Context Dependence – Responsibility
    Step 3: In Form Tab Parameters
    Enter the Workbook name created previously
    workbook=TEST_WORKBOOKBharat
    Step 4: In Web HTML Tab
    Enter HTML Call = OracleOasis.RunDiscoverer
    step 5: Add the Function in Any existing or new Menu…..
    Save
    VIEW OUTPUT

    Navigate to Responsibility which contain this Menu.
    Click the worksheet name that you want to display
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ramji bhai,

    That works fine thanks bhai. I have missed web HTML tab to enter OracleOasis.RunDiscoverer option.
     
  5. hpmherzeg

    hpmherzeg Starter

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    Thanks for writing in such an encouraging post. I had a glimpse of it and couldn’t stop reading till I finished. I have already bookmarked you.
    --------------------------------------------------------------
    Sarajevo apartment