Payables and Cash Management - EBS (MOSC)

MOSC Banner

Invoice Receipts Holds Alert - Email Problem

edited Feb 11, 2010 8:58AM in Payables and Cash Management - EBS (MOSC) 1 commentAnswered
Our Invoice Receipts Holds Alert quit working after we upgraded from 11.5.9 to 11.5.10.  Now the alert will not send unless you hardcode an email address into the To: Field.  Also, all the other fields are blank such as  &Vendor, &Requestor, &Amount, &Inv, etc.  Below is our code.  Any idea what is wrong?

SELECT
hrea1.email_address
,hrea1.FIRST_NAME||' '||hrea1.middle_name||' '||hrea1.last_name requestor_name
,hrea.FIRST_NAME||' '||hrea.middle_name||' '||hrea.last_name buyer_name
,u.location_code
,h.ORGANIZATION_code
,to_char(substr(rpad(pol.line_num,20,' '),1,15)) line_num

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