Introduction

The Oracle E-Business Suite attachments included within OA Framework region appear as separate links for each document alongside the ‘Attachment(s)’ Label in the ‘Notification Header’ section of the email notification. The user needs to login to the application in order to view/access the attachments. From EBS release 12.2.5 on wards, Mailer supports the E-Business Suite attachments that would be attached directly to the emails.

E-Business Suite attachment types

There are 4 types of E-Business Suite attachments that are supported in the email attachments.

  1. File – To attach the specified file in the email notification
  2. Short Text – To attach the text file of maximum 4000 characters length
  3. Long Text – To attach the text file of larger size. It is stored internally as CLOB
  4. URL – To attach html files that opens the given URL

Defining E-Business Suite Attachments in workflow notifications

The E-Business Suite attachments can be added in the workflow notifications by using the below steps.

  1. Create a special message attribute with internal name of ‘#ATTACHMENTS’ and source type as ‘Document’.
  2. The message attribute value should contain the following fields
    • Entity
    • Primary Key 1 Name
    • Primary Key 1 Value
    • Primary Key 2 Name
    • Primary Key 2 Value
    • Primary Key 3 Name
    • Primary Key 3 Value
    • Primary Key 4 Name
    • Primary Key 4 Value
    • Primary Key 5 Name
    • Primary Key 5 Value
    • Optional fields
      Categories
      Category_name1
    • Category_name2
       
  3. The ‘#ATTACHMENTS’ attribute value should be specified in the format ‘FND:entity=<Entity> &pk1name=<Key Name>&pk1value=<Key Value>&categories=CUSTOM105,MISC.
  4. The value for ‘entity’ can be obtained from DATA_OBJECT_CODE column and primary key names can be obtained from PK1_COLUMN, PK2_COLUMN..etc in FND_DOCUMENT_ENTITIES. The primary key values ‘ pk1value’ can be obtained from PK1_VALUE, PK2_VALUE ..etc columns in FND_ATTACHED_DOCUMENTS.
  5. The Categories field is optional, if its not specified Oracle E-Business Suite Attachments will be displayed for ALL document categories. The category internal and display names can be obtained from the view FND_DOCUMENT_CATEGORIES_VL columns name and user_name. The internal category names separated with commas should be specified for categories field in the attribute value.

Following is the screenshot of email notification with E-Business Suite attachments.