Procurement - EBS (MOSC)

MOSC Banner

Duplicate Emails Sent by Oracle Alert

edited Jul 24, 2018 6:39AM in Procurement - EBS (MOSC) 4 commentsAnswered

Hello Team,

I have created a APPROVAL alert on PO_REQUISITION_HEADERS_ALL; although, porhall.ROWID=:ROWID and Suppress Duplicates (flag ticked)

SELECT

       to_char(sysdate,'DD/MON/RRRR HH24:MI:SS'),

       porhall.segment1||', '||porlall.line_num,

       porhall.requisition_header_id,

       porlall.requisition_line_id   ,

       oun_hrorgu.name,

       prep_perallpf.first_name

       ||' '

       ||prep_perallpf.last_name,

       dl_hrorgu.name,

       porlall.item_id,

       porlall.item_description,

       porlall.unit_meas_lookup_code,

       porlall.quantity,

       porlall.need_by_date,

       prep_perallpf.email_address,

       porlall.SUGGESTED_BUYER_ID,

       buy_perallpf.first_name

       ||' '

       ||buy_perallpf.last_name,

       buy_perallpf.email_address,

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