Email Notification Is Not Sent To The Approver (Doc ID 314320.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Purchasing - Version 11.5.9 to 11.5.10.4 [Release 11.5]
z*OBSOLETE: Microsoft Windows 2000
Obsolete Linux Intel (64-bit)
HP-UX PA-RISC (32-bit)
IBM AIX on POWER Systems (64-bit)
Oracle Solaris on SPARC (64-bit)
IBM AIX on POWER Systems (32-bit)
Oracle Solaris on SPARC (32-bit)
Linux x86
HP-UX PA-RISC (64-bit)
HP Tru64 UNIX
***Checked for relevance on 02-Jul-2011***

Symptoms

The employee is not receiving the approve confirmation after a Purchase Order or Requisition is finally approved. This person should receive a notification message with a subject like 'Standard Purchase Order  XXXX has been approved'

Changes

Multiple records are retrieved by the query below:

prompt

-- Retrieve Multiple WF ROLES linked to same row in the HR system

select orig_system,orig_system_id,name,display_name from wf_local_roles wfr1 where (wfr1.orig_system <> 'WF_LOCAL_ROLES' and wfr1.orig_system_id <> 0)
and exists ( select 'row found' from wf_local_roles wfr2 where (wfr2.orig_system <> 'WF_LOCAL_ROLES' and wfr2.orig_system_id <> 0) and wfr2.orig_system_id = wfr1.orig_system_id and wfr2.orig_system = wfr1.orig_system and wfr2.name <> wfr1.name)
and orig_system = 'PER'order by orig_system,orig_system_id

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms