AGP and Commissions Received Bot

Summary:

This bot will download a report from SAP-C, called AGP Transactions and Details, as well as Commissions Received. These reports have many rows and take time to download. The bot will select the input criteria (date/country), download the reports, place the reports into a macro enabled excel file, execute macro, and then upload to DropBox for process owner access.

Process Owners: Zia Virani

Bot Owner(s): Dan Hogfelt

Developers: Dan Hogfelt

Relevant Systems:

• SAP-C
• Excel

Runbook:

The runbook should provide information to support the bot in the case that any issue occurs.

If Bot Fails: Should Receive an email saying that bot failed. In this case, go to the production orchestrator and download the recording which will show the screenshots as the bot failed. Use these screenshots to perform a root cause analysis. A screenshot may also be provided at the time of the error, depending on what error occurred.

Password Incorrect/Expiration: If the password is incorrect, password will need to be reset by following the below :

If SAP-C Password is incorrect: Contact Kevin Fong for assistance.

DevOps Epic: 

Automation Hub Link: