How can I enable email bursting?

Here's how you can enable email bursting for HCM Extracts.

1. Create HCM Extract including columns that define how the report will be burst into separate reports.

2. Include the email address where that the report should be sent to for each separate bursting value.

   Note:

   In this example, PersonNumber and Email are used from PER_EXT_SEC_PERSON_UE.

3. Define a delivery option that points to the BIP report. Set the delivery type to E-Mail in the Delivery Option Details.

4. Set the following additional details:

   • Key: Set it to the bursting column in the report.

   • E-Mail Address: Set it to the Email column in the report.

   • From: Set to either a fixed value or an attribute from the report.

   • Subject: As required.

   • Message Body: As required.

5. In BIP, make a copy of the /Shared Folders/Human Capital Management/Payroll/Data Models/globalReportsDataModel.xdo.

Edit the bursting definition by doing the following:

1. Set the Split By and Delivery By to reference the column used to burst the report. In this example this is: /DATA_DS/G_1/G_2/FILE_FRAGMENT/JRTestEmail/Person/PersonRec/PersonNumber.

2. Set the SQL Query to the following:

   SELECT key key 
   ,TEMPLATE,OUTPUT_FORMAT
   ,OUTPUT_NAME
   ,CALENDAR
   ,'true' SAVE_OUTPUT
   ,DEL_CHANNEL 
   ,PARAMETER1
   ,PARAMETER2
   ,PARAMETER3
   ,PARAMETER4 
   ,PARAMETER5
   ,PARAMETER6 
   ,PARAMETER7 
   ,PARAMETER8 
   ,PARAMETER9 
   ,PARAMETE10 
   ,LOCALE
   ,TIMEZONE
   FROM FUSION.PAY_REP_DELIVERY_DTLS 
   where payroll_action_id=:payrollActionId 
   and ext_delivery_option_id=:deliveryOptionId
    

3. Split By and Deliver By fields are List Of Value (LOV) fields, and show predefined values appearing in the LOVs.

4. Click LOV and the text appears as "-- Enter --". After selecting, you can manually enter the required value in this field.