SAP iRPA detecting transaction failure

[ad0601]

Hello experts,

How can I write successful and failed transaction postings in the excel file?

The scenario: The mass business partner registrations and data is stored into the excel sheet row by row all business partners details.

excel row1: Business partner 1 (Name, address, bank details etc.) Status: Successfully uploaded

row2: Business partner 2 Status: Successfully uploaded

row3: Business partner 3 Status: Failed, postal code length is more

row4: Business partner 4 Status: Successfully uploaded

The screens for transaction BP are recorded and working fine. The bot will be scheduled in the unattended mode. If any excel row (or business partner) creation fails then I want to continue to the next BP and write failed transaction reason back to excel sheet against that business partner row.

Is there any activity to do this work?

Regards,

ADP

[alexisgaillot]

Hi ADP,

If I understand correctly your issue, you are doing a loop and each time you are writing inside the excel file, if you have an issue you want to be able to go to the next occurence.

There is no proper activity to cover that directly but there is multiple ways to achieve this.

For example if your workflow stops because of an error message then you need to put this activity inside a try catch. As a result you will end up inside the catch and if this happened you will be able to launch the next occurence.

Another case is that there is no error message but you know that the process didn't achieve what was asked. Then you can use a condition and if it went wrong then you can decide to go to the next occurence.

Regarding the excel file, you can definitely write in the corresponding line of your excel. If you know which line you are processing then when you enter the try catch or the condition then you can write the result using the set cell activity.

[ad0601]

alexisgaillot Thanks for your answers. If after using catch the current record is logging error and workflow proceeds further for next record then it solves my problem.

There is one more question, if I am executing this process in an unttended mode on 5 systems (end users) then do they have to keep their systems ON so as to call respective agents from the factory?

Also, those 5 end users have different SAP credentials (username and pass) then how can I pass respective credentials? Do I have to create 5 seperate triggers?