Smart Process Application on Procure to Pay
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.
ℹ [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: You will SPA Delivery Unit with tgz extension
Before you start with the setup ensure that you fulfil the desired prerequisites
Prerequisite
- SAP HANA SPS09 (1.00.090.00) and above
- SAP Operational Process Intelligence 1.0 SPS09 PL0 and above
- HANA User Privileges to install the Delivery Unit and Activate into HANA System
HANA User must have these minimum privileges- sap.pi.pv.roles::OPINTDEVELOPER role
- MODELING role
- Root Package privilege
- ROLE ADMIN system privilege
- 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
- Open the HANA Studio
- Check if you have the right version on HANA Studio
- Check if you have right version of SAP Operational Process Intelligence plugins installed
- Open Quick View from Windows –> Show View –> Others –> Quick View menu option
- Click on Import option
- In the Import Dialog, select SAP HANA Content/Delivery Unit
- Click Next and select the target HANA System where you want to import the application
- Select Client option and Browse to the file location where you have extracted the content zip
- Select the Delivery Unit (i.e. file with .tgz extension)
- Wait for the import simulation.
Once the objects are ready to import, the Finish button would be activated - 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
- 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: 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: 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
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
Hello Andreas,
Please try again !
Download the Delivery Unit again and import.
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
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.
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.
Can you try again.
Sorry for this inconvenience.
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?
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 !
Hi Archana,
the access of the shared folder is expired. Is it possible to get access?
I tried this link:
I got this error:
Kind regards
Dirk
Please try accessing now.
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
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.
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.
Kind regards
Dirk
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
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
Hi,
i think the procedure is not in SYS_PROCESS_VISIBILTY. How can we add the program and why it is missing?
Kind regards
Dirk
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.
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.
Hi,
activation is not possible. I cannot found the namespace. Maybe it is an old one.
Kind regards
Dirk
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
Hi,
done. But nothing changed. All instances are still red. Which task is open?
Kind regards
Dirk
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.