Some Attachments Missing in Email Notifications

(Doc ID 2328337.1)

Last updated on NOVEMBER 14, 2017

Applies to:

Oracle Fusion Enterprise Contracts Management Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

The Email Notifications sent from the Application inconsistently have attachments.

Users expect all attachments to be included in email approval notifications.

 
The issue can be reproduced at will with the following steps:
 
The user performs the following steps to add an Attachment to a Contract:

1. Logged onto Fusion Applications.
2. Create  a contract 856 and added nine attachments +primary contract = ten attachments.
    a. Select the Documents Tab.
    b. Under the Contract Documents section, Select Type = File, and Category = Contract.
    c. Select the Browse Button
    d. Search for a File on my Desktop, select the file and select the Open button.
    e. File is then Attached to the Contract.
3. Only nine attachments were in the email opened in Thunderbird.

 The SOA table storage of attachments was confirmed by the queries below

SELECT /*Bug 27002649 */ correlation_id
FROM OKC_K_HEADERS_ALL_B
WHERE contract_number ='1035'; // replace <contract number>

SELECT /*Bug 27002649 */ uri,name,attachmentsize
FROM crm_fusion_soainfra.wfattachment
WHERE correlationid ='b7bedb90-0a54-4a4b-bdc4-36d7e39ade56'

 

 

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