The :MAILID implicit input lets you access the electronic mail address of the application user who triggered an event alert. The value for :MAILID comes from the EMAIL_ADDRESS profile option. Before you can use the :MAILID input in your alerts, you must create and set the EMAIL_ADDRESS profile option and perform some additional setup steps.

If the EMAIL_ADDRESS profile option has not been created, or if its value is null, Oracle Alert uses the operating system user ID or the Application username of the user who triggered the event, depending on the value set for the Default User Mail Account option in the Oracle Alert Options form.

   To set up the :MAILID implicit input

1. Navigate to the Oracle Alert Options form. In the More Options tabbed region, set the Default User Mail Account option to the default value you want, either Operating System Login ID or Application Username. See: Defining Other Options for Oracle Alert.

2. If you have multiple organizations defined in your Oracle Alert schema, ensure that you specify the organization against which each alert should run. Navigate to the Alert Details window for your alert, and in the Installations tabbed region, enter the operating unit you want for each Oracle ID. Delete any records in this region that do not have a valid Oracle ID and operating unit. See: Specifying Alert Details.

3. Create two new profile options named RESP_ID and EMAIL_ADDRESS. In the Application Developer responsibility, navigate to the Profiles window. Enter the following information to create the first profile option:

   • Name-RESP_ID

   • Application-Oracle Alert

   • User Profile Name-RESP ID

   • Description-Responsibility ID

     Enter the following information to create the second profile option:

   • Name-EMAIL_ADDRESS

   • Application-Oracle Alert

   • User Profile Name-EMAIL ADDRESS

   • Description-User's email address

     See: Defining New User Profile Options.

4. Set the RESP_ID profile option at responsibility level for each responsibility from which you trigger event alerts. In the System Administrator responsibility, navigate to the System Profile Values window. Query the RESP_ID profile option at responsibility level for the responsibility you want, and set the profile option value to the responsibility ID.

   You can query the FND_RESPONSIBILITY_TL table to find the responsibility ID for a responsibility. For example, to find the responsibility ID for the Alert Manager responsibility, use the following command:

    select responsibility_name, responsibility_id
   		from fnd_responsibility_tl
   		where responsibility_name like '%Alert%';
   

   See: Setting User Profile Options.

5. Set the EMAIL_ADDRESS profile option at user level for each user. In the System Administrator responsibility, navigate to the System Profile Values window. Query the EMAIL_ADDRESS profile option at user level, and set the profile option value to the user's email address.

   See: Setting User Profile Options.