Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Saravanan Thirunavukkarasu
    Print Receivables Transactions: Email Delivery --Override...Answered
    Topic posted January 29, 2019 by Saravanan ThirunavukkarasuGold Medal: 3,500+ Points, last edited February 6, 2019, tagged Financials, OTBI, Receivables, Reports 
    316 Views, 7 Comments
    Title:
    Print Receivables Transactions: Email Delivery --Override email address for non prod instance
    Summary:
    How to override or block emails to customers in non prod instance
    Content:

    For Print Receivables Transactions-Email Delivery , Is it possible to have an override email address for non prod instance or block emails sending from test instance ?.

    Thanks

    Saravanan

    Best Comment

    Felix Beaudoin

    Hey Saravanan!

    There is indeed a way to achieve this. Navigate to the BI Publisher Admin section (/xmlpserver).

    Then, go to Shared Folders -> Financials -> Receivables -> Bill Presentment -> Data Model -> Click Edit on the Data Model.
    Once you are on the data model, in the left-hand side of the screen, click the "Bursting" option. Then, select the first row of the bursting parameters.

    You will see an SQL query in that Bursting parameter. To override, change "PARAMETER1" to whatever email address you want to override.
    To prevent all transactions from emailing, replace "PARAMETER1" by "test@email.com".
    This is very useful for testing and we constantly do this in all our environments.
    Let me know if you have any additional questions.
    Regards,
    Felix

    Comment

     

    • Felix Beaudoin

      Hey Saravanan!

      There is indeed a way to achieve this. Navigate to the BI Publisher Admin section (/xmlpserver).

      Then, go to Shared Folders -> Financials -> Receivables -> Bill Presentment -> Data Model -> Click Edit on the Data Model.
      Once you are on the data model, in the left-hand side of the screen, click the "Bursting" option. Then, select the first row of the bursting parameters.

      You will see an SQL query in that Bursting parameter. To override, change "PARAMETER1" to whatever email address you want to override.
      To prevent all transactions from emailing, replace "PARAMETER1" by "test@email.com".
      This is very useful for testing and we constantly do this in all our environments.
      Let me know if you have any additional questions.
      Regards,
      Felix

      • Juan Miguel Isip

        Hi Felix,

        I found a document in metalink that says

        "How to Set a Global Email Account for all Notifications for Testing Purposes (Test Address) (Doc ID 1473706.1)"

        Would you know this is applicable also to Document Transmissions as well such as Dunning, Credit Memos or Debit Memos?

         


         

         

        • Felix Beaudoin

          Hey Juan!

          Thank you for the input. Unfortunately, BPM and BIP email notifications are completely separate. If we update the BPM test email, it only works on workflows, it does not change Customer or Supplier email addresses that would be used in a data model in BIP. I've found a way for Oracle to completely shut-off the SMTP from the back-end but this requires an SR to be raised. For the time being, we cannot default all Master Data to a Test email but there is an idea in place to have this implemented at some point. Hope this clarifies the situation!
          Regards,
          Felix
          Post a P2T refresh we want to update all email addresses (User, Supplier, Customer) in the refreshed environment to something generic. (Idea #581d0200d8)

    • Saravanan Thirunavukkarasu

      Thanks Felix.. Its great tip. Similar to Receivable invoices, we have many ESS jobs which needs to be blocked. Do we have any option to block at instance level or we need to go individual data model and make changes ?. 

      • Felix Beaudoin

        I haven't found a way so far to block the transmissions at an instance level except for POs. The rest, you need to manually disable.

        • Amarnath Govindu

          Hi Felix,

          How to stop notifications for PO's at instance level?
          Thanks
          • Felix Beaudoin

            Hey Amarnath!

            You can do this in the "Manage Administrator Profile Options".

            Set PO_CONTROL_SUPPLIER_COMMUNICATION as "None" and set profile PO_NOTIFICATION_OVERRIDE_E-MAIL with your email address just in case something gets sent out.

            Cheers,
            Felix