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!

Oracle Apps XML Reports in Excel

Discussion in 'General' started by kiran.marla, Nov 22, 2010.

  1. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Finance department usually work extensively with Microsoft Excel ... and even though we are implementing Oracle, the question of publishing in Excel usually pops up sooner or later. In general, the answer is: yes, it is possible by creating an XML Publisher template (see How to create XML Publisher templates from Standard Reports). But recently I found out that Excel 2003 imports XML files directly, whereas the structure of the report keeps maintained. There are a few steps to follow to achieve this.

    1. Create new Viewer Option
    Navigate to System Administrator > Install > Viewer Options. Add a new entry.

    File Format: XML
    Mime Type: application/vnd.ms-excel
    Description: XML in Microsoft Excel
    Allow Native Client Encoding: Yes

    2. Set Profile Options
    Query profile options: Viewer% on the appropriate levels (site, user, ...)

    Set profile Viewer: Text to Browser
    Set profile Viewer: Application for XML to XML in Microsoft Excel

    Then proceed with your Concurrent executables, program etc..
    Change the Output Format from Text to XML and save the record (ignore the warning).
    Add it to system adminstrator > requests > set.

    Run the request from respective module....
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Hi Kiran, Thanks very much for this very useful info. I have promoted your post to an article. :D
     
  3. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Welcome Sadik.