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!

Error in email output of a concurrent program

Discussion in 'Oracle Apps Technical' started by jagadekara, May 19, 2015.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi All,

    Also I am not able to see the package code for UTL_SMTP and UTL_MAIL and UTL_FILE packages
     
  3. Bharat

    Bharat Community Moderator Forum Guru

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

    These packages reside in SYS Owner. I think they were not granted to APPS Schema. Try using SYS.UTL_SMTP like this to open them and see.
     
  4. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi Bharat,

    Yes, those packages reside in SYS owner only. But How to see the code?

    In SQL Developer we normally apply filter. So I tried by giving SYS.UTL_SMTP. But it's not showing any code.
     
  5. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi All,

    I resolved this error. But it's sending xml tags in .txt format to email. But I need correct output in .csv format. Because the main report output type is Excel. So How to do this?

    Any Idea?
     
  6. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    We need to create template using that xml data. Have you created Template for that report ?
     
  7. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    I already have rtf template. So I gave fnd_request.add_layout in that procedure.
    But still not getting. Also it is completed warning when I add fnd_request.add_layout