Skip to Content

Install and experience this smart process application on Procure to Pay industrial scenario – leveraging the power of HANA and SAP Operational Process Intelligence.


Overview

In this application, you will see how business users can have control on procurement requests with real time visibility into procure-to pay process of procurement department of their company.

Global Procurement Office of a company uses Procure-to-Pay process to manage their purchase requests, accelerate and automate their procurement processes, proactively ensure compliance, and find new ways to cut costs. As procurement is run in shared-service-centers in various locations across the globe involving different parties using SAP and non-SAP systems, it becomes cumbersome to get complete end-to-end visibility into the process. This scenario addresses three major challenges of a procurement operations manager like (a) Getting end-to-end transparency on real-time status across all parties & departments involved (b) Finding where to initiate action today to prevent missing SLAs tomorrow and (c) Getting control to manage KPIs like cycle-time not only for parts of the process.

SAP Operational Process Intelligence, powered by SAP HANA is used to build this smart process application that enables line-of-business users to gain process visibility across their end-to-end business processes, thereby improving the operational decision making to achieve better business outcomes.



Technical Insights
This smart process application is build using HANA Studio and SAP Operational Process Intelligence, to provide visibility into procure-to-pay process in ERP system. The process model was created in Process Observer and SLT was used to replicate the events log and context data from POB and ERP systems onto HANA.

This application, however, bundles the data snapshot of POB and ERP tables required to run the application. In real world, your landscape would look something like the following where SLT would do real-time replication of events from backend system and SAP Operational Process Intelligence provides visibility on those events. You can use any data provisioning software like Data Services, Smart Data Integration etc.

Capture.PNG

ℹ [1] Read SAP Operational Process Intelligence Developer’s Guide to know more about modeling Business Scenario based on POB process.



Setup Instructions

To begin with, download and extract the zip, from here, in your local system.

note.PNGNote: You will SPA Delivery Unit with tgz extension

Before you start with the setup ensure that you fulfil the desired prerequisites

Prerequisite

  1. SAP HANA SPS09 (1.00.090.00) and above
  2. SAP Operational Process Intelligence 1.0 SPS09 PL0 and above
  3. HANA User Privileges to install the Delivery Unit and Activate into HANA System
    HANA User must have these minimum privileges
    1. sap.pi.pv.roles::OPINTDEVELOPER role
    2. MODELING role
    3. Root Package privilege
    4. ROLE ADMIN system privilege
    5. USER ADMIN privilege

Refer SAP HANA and SAP Operational Process Intelligence Installation Guides respectively to setup the system.

Follow these steps to install smart process application into your HANA system.

Steps to Install

  1. Open the HANA Studio
    1. Check if you have the right version on HANA Studio
    2. Check if you have right version of SAP Operational Process Intelligence plugins installed
  2. Open Quick View from  Windows –> Show View –> Others –> Quick View menu option
  3. Click on Import option
  4. In the Import Dialog, select SAP HANA Content/Delivery Unit
  5. Click Next and select the target HANA System where you want to import the application
  6. Select Client option and Browse to the file location where you have extracted the content zip
  7. Select the Delivery Unit (i.e. file with .tgz extension)
  8. Wait for the import simulation.
    Once the objects are ready to import, the Finish button would be activated
  9. Click Finish and observe the Job Log view to know the success/failure of the import

Good!  You have successfully installed the smart process application in your HANA system
… we are now one step behind to experiencing the application.

Configure to Use

  1. Execute the setup procedure with name “SYS_PROCESS_VISIBILITY”.”opint.cross.p2p::SETUP_PROC_OPS

        This procedure is needed to setup the application with appropriate users and privileges required to run it

        note.PNG
        Note: To run the procedure, you need to open the SQL Console of the HANA system and use this command

    call “SYS_PROCESS_VISIBILITY”.“opint.cross.p2p::SETUP_PROC_OPS” (‘<HANA User>’)

Hurray! You have just installed Order-to-Cash Smart Process Application.

User Script
Access the scenario using the link:
https://<hana –server-host>:80<hana-server-instance>/sap/opi/pv/workspace

Username: BOGDAN
Password: Abcd1234

note.PNG

Note: Based on the password policy of your HANA system, you may be subjected to change the password.
Please do so if prompted and henceforth use the changed password.

Note: If you need to refresh the data on the dashboard, then execute this procedure:

call “SYS_PROCESS_VISIBILITY”.“opint.cross.p2p.refresh::REFRESH_PROC_OPS”;


User Guide
Follow the User Guide to experience the scenario that is built using SAP Operational Process Intelligence, powered by HANA. Explore various rich features of the product and learn how to use them for our own benefit.

You can also consider using this as reference content if you have to build similar use case in your organizational unit.

Do write back to me, if you face any issues while setting up the application in your system and share feedback, if any

To report this post you need to login first.

21 Comments

You must be Logged on to comment or reply to a post.

  1. Andreas Kornelsen

    Hello Archana,

    thank you for the post.

    Currently we are trying to use the provided delivery unit but following errors occurs during the import.

    We are using HANA SPS 11 rev. 112.02 with OPInt SPS 11 PL 4

    …[Import][0] Obtain header and object details of delivery unit (id: 4282)

    …[Import][0] Execute deployment (activationMode = TWO_COMMIT_ACTIVATION) of delivery unit (name: CROSS_P2P_SPA, vendor: sap.com, id: 4282)

    …[Activation][8] Activation of at least one object failed

    …[Activation][8] Object: opint.cross.p2p.refresh.REFRESH_PROC_OPS.hdbprocedure ==> Error Code: 40300

    …[Activation][8] Dependent object not found: SqlScript; SYS_PROCESS_VISIBILITY.opint.cross.proc2pay.gen_proc_to_pay::SPVR_PROC_TO_PAY_EVT: symbol not found

    …[Activation][8] Object: opint.cross.p2p.gen_proc_ops.SPVR_POB_FLOW_EVENT_OPT_S3FCLNT300.calculationview ==> Error Code: 40300

    …[Activation][8] Dependent object not found: SqlScript; SYS_PROCESS_VISIBILITY.opint.cross.proc2pay.gen_proc_to_pay::SPVR_PROC_TO_PAY_EVT: symbol not found

    …[Activation][8] Object: opint.cross.p2p.SPVR_ENRICH_PROC_OPS_PROCURE_TO_PAY_SAPIT_CTX.calculationview ==> Error Code: 40117

    …[Activation][8] Repository: Encountered an error in repository runtime extension

    …[Activation][8] Object: opint.cross.p2p.QUALITY_PERCENTAGE_OPTION2.calculationview ==> Error Code: 40117

    …[Activation][8] Repository: Encountered an error in repository runtime extension

    …[Activation][8] Object: opint.cross.p2p.roles.REFRESH_PROC_OPS.hdbrole ==> Error Code: 362

    …[Activation][8] invalid schema name: CEL_DEMO_P2P: line 1 col 24 (at pos 23) at ptime/query/checker/check_priv.cc:270

    …[Import][8] Deployment of delivery unit (id: 4282) failed.

    Do you have any idea how to fix it? The user has the right permissions.

    Thank you,

    Andreas

    (0) 
      1. Andreas Kornelsen

        Hello Archana,

        do you have changed the delivery unit?

        I have tried to download it from the current link, which points to the mdocs folder but it seems to me that the link is broken.

        Could you provide the new link if there is something changed?

        Thank you,

        Andreas

        (0) 
        1. Archana Shukla Post author

          Hello Andreas,

          The link has been replaced in this blog. Refresh and select the “here” link again.
          Let me know if the problem still persists.

          (0) 
          1. Andreas Kornelsen

            Sorry Archana, the link still doesn’t work for me. The following error occurred in SAP Mobile Documents: “Repository not found”. Moreover, I must log in to be able to download it.

            (0) 
              1. Andreas Kornelsen

                The delivery unit is the same, right? We have tried it again and it still doesn’t work. Do you have an idea where to find more information about the error codes. Maybe we have to create some tables beforehand, what is not mentioned in the description?

                (0) 
                1. Archana Shukla Post author

                  Yeah the delivery unit was replaced as the previous one seemed broken. I have verified and it is downloadable. Nothing additional is required as prerequisite. May be I will test again !

                  (0) 
  2. Dirk Laubisch

    Hi Archana,

    thanks for access. We tried to deploy on our OPInt System an got the following deployment error:

    [server][SID][2016.08.25 11:41.29.866][Import][0] Obtain header and object details of delivery unit (id: 4729)

    [server][SID][2016.08.25 11:41.30.519][Import][0] Execute deployment (activationMode = TWO_COMMIT_ACTIVATION) of delivery unit (name: CROSS_P2P_SPA, vendor: sap.com, id: 4729)

    [server][SID][2016.08.25 11:41.49.710][Activation][8] Activation of at least one object failed

    [server][SID][2016.08.25 11:41.49.729][Activation][8] Object: opint.cross.p2p.refresh.REFRESH_PROC_OPS.hdbprocedure ==> Error Code: 40300

    [server][SID][2016.08.25 11:41.49.730][Activation][8] Dependent object not found: SqlScript; SYS_PROCESS_VISIBILITY.opint.cross.proc2pay.gen_proc_to_pay::SPVR_PROC_TO_PAY_EVT: symbol not found

    [server][SID][2016.08.25 11:41.49.767][Activation][8] Object: opint.cross.p2p.gen_proc_ops.SPVR_POB_FLOW_EVENT_OPT_S3FCLNT300.calculationview ==> Error Code: 40300

    [server][SID][2016.08.25 11:41.49.768][Activation][8] Dependent object not found: SqlScript; SYS_PROCESS_VISIBILITY.opint.cross.proc2pay.gen_proc_to_pay::SPVR_PROC_TO_PAY_EVT: symbol not found

    [server][SID][2016.08.25 11:41.49.802][Activation][8] Object: opint.cross.p2p.SPVR_ENRICH_PROC_OPS_PROCURE_TO_PAY_SAPIT_CTX.calculationview ==> Error Code: 40117

    [server][SID][2016.08.25 11:41.49.803][Activation][8] Repository: Encountered an error in repository runtime extension

    [server][SID][2016.08.25 11:41.49.814][Activation][8] Object: opint.cross.p2p.QUALITY_PERCENTAGE_OPTION2.calculationview ==> Error Code: 40117

    [server][SID][2016.08.25 11:41.49.815][Activation][8] Repository: Encountered an error in repository runtime extension

    [server][SID][2016.08.25 11:41.49.845][Activation][8] Object: opint.cross.p2p.roles.REFRESH_PROC_OPS.hdbrole ==> Error Code: 362

    [server][SID][2016.08.25 11:41.49.846][Activation][8] invalid schema name: CEL_DEMO_P2P: line 1 col 24 (at pos 23) at ptime/query/checker/check_priv.cc:270

    [server][SID][2016.08.25 11:41.49.888][Import][8] Deployment of delivery unit (id: 4729) failed.

    Please check the deployment file

    Kind regards

    Dirk

    (0) 
    1. Archana Shukla Post author

      The delivery unit has been imported but activation failed. Please ensure that you are using the required version of HANA and OPInt as mentioned here. If yes, then regenerate the scenario using Business Scenario –> Generate action. That is the quickest way.

      (0) 
  3. Dirk Laubisch

    Hi Archana,

    our activation was successfull and we have access to the “Procurment Ops”. Is it possible to get not only red instances? I called the data refresh procedure, but the script shows errors.

    OPInt Error.jpg

    Kind regards

    Dirk

    (0) 
    1. Archana Shukla Post author

      Please ignore these errors. They are from the editor, because the entire syntax is spliced into multiple line – but actually there is no malfunctioned syntax. Go ahead and run the script. Refresh works.

      Regards,

      Archana

      (0) 
  4. Andreas Kornelsen

    Hello Archana,

    thank you for the helpful answers.We are now able to import the delivery unit.

    After running the .hdbprocedure SETUP_PROC_OPS successfully, there is now the problem to run the procedure REFRESH_PROC_OPS.

    The procedure gives us the following error message:

    Could not execute ‘call “SYS_PROCESS_VISIBILITY”.”opint.cross.p2p.refresh::REFRESH_PROC_OPS”‘

    SAP DBTech JDBC: [328]: invalid name of function or procedure: opint.cross.p2p.refresh::REFRESH_PROC_OPS: line 1 col 31 (at pos 30)

    There seems to be an error in the procedure:

    Can you gives us a hint how to solve it?

    Thank you in advance,

    Andreas

    (0) 
      1. Archana Shukla Post author

        Hello Dirk and Andreas,

        You see those red icons next to the files. This indicate that the artifacts have not been activated successfully – and therefore you do not find them in the SYS_PROCESS_VISIBILITY schema. You need to select the right click option of Regenerate to re-activate the files.

        Regenerate.PNG

        HACK::  If that does not work, then open the procedure by double clicking it. Make the editor dirty by introducing an empty space in the file at start or end. Save and Activate.

        (0) 
    1. Archana Shukla Post author

      Hello Dirk,
      Thanks for bringing this to my notice. There seem to be some issue with the uploaded script. Since you have already imported the delivery unit, please delete the code in POST REFRESH ACTIVITIES section in the refresh script and activate.

      Regards,

      Archana

      (0) 
    1. Archana Shukla Post author

      It shows ‘1 Rows Affected’ which means refresh is not happening. Is it possible for you to schedule a call with me and we can work on it ? I would upload the fresh delivery unit after all these issues. Sorry for all the inconveniences.

      (0) 

Leave a Reply