This recipe uses the Robotic Process Automation (RPA) feature to automate the group creation and assigning users in Oracle ERP Cloud worklist.

Managing user access and group assignments is a critical and repetitive task for IT administrators. With multiple users and groups to be managed, manually creating these associations in an ERP system can become inefficient and error-prone. This recipe leverages the Oracle Integration 3 - integration capabilities to process data from external sources (in this case, a CSV file on a File Server) and utilizes RPA to automate the creation of user groups and the assignment of users to these groups within the Oracle ERP Cloud system.

The CSV file serves as the source of truth for the groups and users that need to be managed. Each row in the CSV contains information about a specific group and the users that should be assigned to that group. The Process File and Call Robot integration reads the CSV file, sends the converted JSON payload to the robot, interacts with the ERP system to create the groups and assign users accordingly, reducing manual intervention and ensuring that the user and group data is accurately reflected in the Oracle ERP Cloud system.

This approach ensures that the process is consistent, error-free, and scalable, and can be easily adapted to different environments and ERP systems, provided they support the necessary integration protocols.

This recipe contains the following robot and integration:

1. Robot - Create Groups and Add Users: This robot takes the array of groups and multiple users in each group as a JSON payload. The robot logs into the provided Oracle ERP Cloud account, navigates to multiple ERP screens (as recorded in the robot), loops over the group, creates group and assigns all users inside the group.
2. Process File and Call Robot: The scheduled integration flow that reads the data file from File Server, creates the payload from robot and starts the robot flow.

To use the recipe, you must install the recipe and configure the connection and other resources within it.