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!

Workflow examples

Discussion in 'Oracle Apps Technical' started by RussH, Oct 14, 2010.

  1. RussH

    RussH Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    75
    Location:
    Adelaide, Australia
    Hi All,
    I'm looking for a workflow example, where the workflow calls a procedure that runs some queries a table and returns the results in a workflow notification.

    i.e. what i am planning on doing is to create a workflow that queries the ap_credit_card_trxns_all table, and for transactions that are not coded over a certain timeframe (i.e. 30 days), sends them a workflow notification email, and in that email is a table of the outstanding transactions.

    I've been doing through the workflows within Oracle but haven't found one that does something similiar to what i require.

    Cheers,
    RussH.
     
  2. a_kamalraj

    a_kamalraj Forum Advisor

    Messages:
    121
    Likes Received:
    23
    Trophy Points:
    280
    Do you want the procedure to send email in HTML format with tabular format?