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!

Concurrent Request "View Output" in Excel file

Discussion in 'Oracle Apps Technical' started by chester04, Jun 6, 2012.

  1. chester04

    chester04 Active Member

    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    100
    Hi,

    I have an existing package that extract the GL Balances into a *.dat file.
    My requirements is to display the same records from the *.dat file when the user click the "View Output" and display it in excel format.
    Any idea on how I can make this happen?
    I'm thinking to use the same cursor that fetches the data but the problem is, how can show it in the concurrent request "View Output" in excel format.

    Thank you.

    Br,
    Chester
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    In concurrent program definition we can set output format as text / xml like this. I think in that list we can see excel format also. If we set that output format to that we can see output in excel sheet itself.
     
  3. chester04

    chester04 Active Member

    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    100
    In the output format of concurrent program definition, this are the only available option:
    - FO
    - HTML
    - PCL
    - PDF
    - PostScript
    - Text
    - XML
     
  4. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Hi Chester04,

    If your report is not break report ,
    1. select output format => xml
    2. run the concurrent program.
    3. save the output file to local machine.
    4. right click the mouse -> select "open with" option -> excel.

    if it is break report then you need to go xml/bi publisher
     
  5. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Its not possible to get result in excel sheet. If you want to get results in excel sheet then you need to design xml/bi publisher template and then while registering them you can assign output format as excel sheet.
     
  6. K Mohan

    K Mohan Newly Initiated

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    USA
    @kiran

    What do you mean by break report, this is kinda new terminology for me.
    Could you please explain this.

    Thanks,
    Kirti Mohan Sharma
     
  7. K Mohan

    K Mohan Newly Initiated

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    USA
  8. raovk13

    raovk13 Premium Member

    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    100
    I wonder how many go through file format 'PCL'..but good to know..there are ways other than BI option.

    Regards,
     
  9. naveen.lazaus

    naveen.lazaus Active Member

    Messages:
    2
    Likes Received:
    2
    Trophy Points:
    85
    Hi ,

    the data you get from the package, plz store in Temp Table. you need to develop custom code.

    Create Data Template its of XML publisher reporting.when the request completed after running You will Excel ouptut then you click View Output ,you will get Excel Output Format data.