Supplier Management

Get Involved. Join the Conversation.

Topic

    Shivani Roy
    How to configure Supplier Registration Approved Email...
    Topic posted October 30, 2019 by Shivani RoyBronze Medal: 1,250+ Points, last edited November 6, 2019, tagged Approvals/Notifications, Business Intelligence, Customization, Supplier Registration, Tip 
    37 Views, 2 Comments
    Title:
    How to configure Supplier Registration Approved Email notification using Business Intelligence Publisher template
    Summary:
    Steps to configure Supplier Registration Approved Email notification using Business Intelligence Publisher template.
    Content:

    Summary: Steps to configure Supplier Registration Approved Email notification using Business Intelligence Publisher template.

    Description:

    Buying organizations can include additional information to be sent to the supplier by configuring the email notifications using BIP.

    E.g: In the Supplier Registration Approved Email notification, if you want to add a paragraph detailing the organizations quality policies and also want to display additional information dependent upon a supplier registration attribute, then follow the below steps:

    Note:

    1. In order to configure the BIP template the user should have the role: BI Administrator.
    2. This feature is opt in controlled. You need to enable feature Configure Supplier Registration Approval Decision Notifications with Business Intelligence Publisher.

    Step 1: Create a copy of the template

    Sign in to Oracle Business Intelligence Publisher. In the Suppliers Business Intelligence Catalog, locate the External Supplier Registration Approved FYI Email Report template, and then click Customize. This creates a copy of the template in your Custom folder.

    image2019-10-31_11-45-39.png?version=1&modificationDate=1572502540680&api=v2

     

    Step 2: Download and install BI publisher word add-in

    If BI publisher add-in is not installed for word you can download it from the below link:

    https://www.oracle.com/technetwork/middleware/bi-publisher/downloads/index.html

     

    Step 3: Download sample data

    Sample data will be required in order to add additional supplier registration attributes to the template. Sample data contains a list of supplier registration attributes along with sample values for these attributes. This when loaded to the template gives you a list of the supplier registration attributes which can be added to the template. Furthermore the sample data is also useful when you want to preview a report for the configuration done.

    To download the sample data follow the below steps:

    Edit the External Supplier Registration Approved Email Data Model available under the Data Models folder.

    screenshot1.png?version=1&modificationDate=1572501032000&api=v2

    Click on the properties from the panel on the left hand side. Download and save the sample.xml

    2.png?version=1&modificationDate=1572501071000&api=v2

    Note: If the sample data does not contain the required attributes, you can edit the sample.xml file using notepad and manually add the required tag and value combination under the correct mapping set.

    To fetch the correct Tag Name and mapping set, open the data model, Click on the Data Sets from the panel on the left hand side and go to Structure tab. XML Tag Names and their mapping sets are listed here.

    datamodel.png?version=1&modificationDate=1572501102161&api=v2

     

     

    Step 4:  Customizing the copy of the seeded template.

    1. Go to Custom folder> Procurement> Suppliers > External Supplier Registration Approved FYI Email Report template. Click on Edit and download the ExtSuppRegNotifApprovalFYIReport.rtf.
    2. Go to BI publisher tab and load sample.xml saved in Step 3.
       3.png?version=1&modificationDate=1572501122090&api=v2
    3. Adding text content: Go to the Insert tab, expand ‘Quick Parts’ to see available pre-existing layouts which can be used to configure the template.
      To add text choose BIP Paragraph of Text from the list.
      4.png?version=1&modificationDate=1572501145000&api=v2
      Add text which is to be displayed in the email.
      5.png?version=1&modificationDate=1572501165000&api=v2
    4. Adding an attribute from the data model to conditionally display content on the BIP report:
      We can also add conditions on any of the supplier attribute to conditionally display content. Example given below shows how to use DFF attribute to conditionally display content on the email. DFF attribute ATTRIBUTE20 is used in the supplier registration to capture the supplier response to the question on the buying organization’s quality policies.
    • To add a condition click on Conditional Region under BI publisher tab.
    • Under General: Select the required attribute from the Data field list. Select the corresponding data type.
    • Under Condition1: Manually enter the value expected to satisfy the condition.
    • Add the required content to be displayed inside the conditional tags <C><EC> as shown below.
      12.png?version=1&modificationDate=1572501190212&api=v2

     

    Step 5:   Viewing a sample report for the customization.

    Note: Temporarily delete the portion highlighted in yellow before viewing a sample. Paste it back after viewing the sample report.

    These tags are references to other folders in the BI and hence will throw error when we try to view a sample report locally.

    Under BI publisher tab click on any of the formats to view a sample report.

    15.png?version=1&modificationDate=1572501214000&api=v2

    Sample report in the pdf format.

    14.PNG?version=1&modificationDate=1572501238878&api=v2

     

    Step 6: Save the template and upload it back into the BI publisher.

    Under Custom folder> Procurement> Suppliers > External Supplier Registration Approved FYI Email Report, note down the layout name and delete the existing template. Click on Upload to upload the configured template. Please note to use the existing name for layout name. For External Supplier Registration Approved FYI Email Report template the layout name is ExtSuppRegNotifApprovedFyi.

    image2019-10-31_11-47-30.png?version=1&modificationDate=1572502650267&api=v2

     

    Once the upload is complete click on View a list on the top right corner and verify that the Default Layout checkbox is checked.

    11.png?version=1&modificationDate=1572501609000&api=v2

     

    Other references:

     

    Comment