My Oracle Support Banner

CLM iProcurement: Some Users Do not Receive Email Notifications When MIPR Requisitions Are Approved (Doc ID 2711166.1)

Last updated on SEPTEMBER 15, 2020

Applies to:

Oracle Contract Lifecycle Management for Public Sector - Version 12.2.5 and later
Oracle Workflow - Version 12.2.5 and later
Information in this document applies to any platform.


In Oracle iProcurement with Oracle Contract Lifecycle Management (CLM), Release 12.2.6 and later, some users (not all) are not receiving the MIPR notification emails after the requisitions are approved.
The approval notification "MIPR HCXXXXXXXXXX has been approved" is in the user's worklist and the user can see the notification details, So the issue is only with the notification not being emailed to the user.

The problem does not occur for non-MIPR requests.
The issue also does not occur for amendments that are issued against the MIPR requisitions.

Due to this issue, requesters are not receiving immediate notice that the MIPR requisitions are approved.
As a workaround, the users can actively monitor the worklist for new notifications, but this is time-consuming to continually refresh while awaiting the requisition approval.


The workflow mailer debug script "wfmlrdbg.sql" does show some errors related to attachments.

>> GSC WF_MAILER Component Scheduled Events
Component Id 10006
Component Name Workflow Notification Mailer
Component Status RUNNING
Request Id Job Id Event Name Event Params Event Frequency What Last Date Last Scheduled
10000 104 1440 FND_SVC_COMPONENT.EXECUTE_REQUEST (p_component_request_id => 10000); 19-APR-20 17:04:12

Note Error when getting plsql attachments nid 86803021
Error ORA-06502: PL/SQL: numeric or value error

>> FND Attachments Information
File Attachments
Doc Id File Name Entity name pk1 value pk2 value pk3 value pk4 value pk5 value Folder Path
67412586 XXXXXX_Contract Mod.pdf REQ_HEADERS 58****2
67412587 XXXXXX_PWS.docx REQ_HEADERS 58****2
67412588 XXXXXX_Funding Plan.pdf REQ_HEADERS 58****2
67412589 XXXXXX_IGCE.xlsx REQ_HEADERS 58****2
67410253 /pdaipi/applcsf/inst/PDA***6/logs/appl/conc/1431/out/XXD_POXPRCLM_MPR_XML_86189431_1.PDF< /font> REQ_HEADERS 58****2
Note Error when getting long text attachments nid 86803021
Error ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Note Error when getting short attachments nid 86803021
Error ORA-06502: PL/SQL: numeric or value error
Note Error when getting url attachments nid 86803021
Error ORA-06502: PL/SQL: numeric or value error

Steps To Reproduce

The issue can be reproduced at will with the following steps:
1. The requester user creates a new MIPR requisition and submits for approval.
2. After the final approver has approved the requisition, the notification is sent and the requester can see the notification in the Worklist; however, the notification email is not sent/delivered.
The approver of the MIPR requisition also does not receive the "Approved" email.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.