Notification Mailer Service Is Up But Suppliers Not Able To Receive Emails After Supplier Registration

(Doc ID 2147505.1)

Last updated on SEPTEMBER 25, 2016

Applies to:

Oracle iSupplier Portal - Version 12.2.4 and later
Information 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

To collect wfstatus:
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

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