Email Notification Is Not Sent To The Approver
(Doc ID 314320.1)
Last updated on JANUARY 03, 2023
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
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |