Notification Mailer Service Is Up But Suppliers Not Able To Receive Emails After Supplier Registration
(Doc ID 2147505.1)
Last updated on FEBRUARY 25, 2019
Applies to:
Oracle iSupplier Portal - Version 12.2.4 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.4 version, Supplier User Issues
ACTUAL BEHAVIOR
---------------
Suppliers are not getting email notification when buyer submits the prospective supplier registration request.
EXPECTED BEHAVIOR
-----------------------
Suppliers should receive emails after submitting the registration request
Following errors are shown in wfstatus of registration request
Get the SUPPLIER_REG_ID from below query:
Select * from pos_supplier_registrations where supplier_name like '%Supplier_name%'
Get the wf_item_type and wf_item_key from the following query:
Select item_type, item_key from wf_items where item_key like '%APPROVED%&SUPPLIER_REG_ID%';
Approval notification to supplier #MAIL WF_ERROR
[WF_ERROR] ERROR_MESSAGE=3835: Error '-20002 - ORA-20002: 2018: Unable to generate the notification XML. Caused by: 2020: Error when
getting notification content. Caused by: ORA-20002: 3240: Error '-6550 - ORA-06550: line 1, column 23:
PLS-00302: component 'GET_APPRV_SUPPLIER_BODY' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
' in 'PLSQLCLOB' API 'pos_spm_wf_pkg1.GET_APPRV_SUPPLIER_BODY'
STEPS TO REPRODUCE THE ISSUE
------------------------------------------------------
1. Login to Supplier Management Administrator
2. Buyer Uses Register Supplier
3. Enter the information and submit
4. Supplier does not get any email
The similar issue also happens when supplier uses Prospective Supplier Registration requests
Changes
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 |
| References |