Oracle Reports (MOSC)

MOSC Banner

Emailing a Report in Release 12 by passing desname and destype as parameters

edited Mar 27, 2012 9:34PM in Oracle Reports (MOSC) 12 comments

  Hello, 

    We are using  Oracle Apps R12  on a Linux OS.  

  I am replicating a process we do in another system  that uses   Oracle APPS R11.

 

    I have a  Concurrent Program  that  calls a Package Procedure  to  identify  orders.  This procedure will then call a Report defined with PDF style format output.  I also pass an email address and MAIL as destype.      by using this:       

 

req_id := FND_REQUEST.SUBMIT_REQUEST ('HJ', 'XXJY_JLY_ACK_RECPT_PDF', 'XXJY Jewelry Acknowledge Receipt Report - PDF',

sysdate, FALSE,p_sort_by, -- sort byv_from_date, --'2012/02/20 00:00:00', --null, -- from date

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center