OIC - OIC Integration for User and Role Synchronization Between CORS and Workforce System (WFS)

Working...

Managing user access across systems is a common enterprise requirement. In this implementation, Oracle Integration Cloud (OIC) acts as the middleware between CORS and the Workforce System (WFS) to synchronize users and their roles.

Flow 1: WFS to CORS – User and Role Export

This scheduled OIC integration runs periodically to extract user information from WFS.

Process

1. OIC Scheduler triggers the integration.
2. Lists all available files from the WFS SFTP location.
3. For each file, downloads the content.
4. Writes the files to the OIC Embedded SFTP server.
5. CORS picks up the files using a service account.

Files Transferred:

• List of Users
• User with Roles

This flow ensures CORS always has the latest user and role information from WFS.

Flow 2: CORS to WFS – User Provisioning and Role Management

This integration exposes a REST API that allows CORS to request user provisioning or role assignment/removal in WFS.

Process

1. CORS sends user details and roles through a REST request.
2. OIC validates and transforms the data into the format required by WFS.
3. Creates the appropriate provisioning file.
4. Places the file in the WFS SFTP location for processing.

Supported Actions

• Create User
• Assign Role
• Remove Role

This approach provides a simple file-based integration mechanism while maintaining system decoupling.

Flow 3: CORS to WFS – Provisioning Status Validation

After provisioning requests are submitted, CORS can verify the processing status through another REST service exposed by OIC.

Process

1. CORS sends the User ID and Role information.
2. OIC obtains an authentication token from WFS.
3. Calls WFS APIs to retrieve current users and assigned roles.
4. Compares the requested data with the actual data in WFS.

Response Logic

• Success – User exists and all requested roles are assigned.
• Pending – User exists but roles are not yet assigned.
• Error – User does not exist in WFS.

This validation mechanism provides real-time visibility into provisioning status and helps CORS track completion of access requests.

Benefits

• Automated user and role synchronization.
• Secure file transfer through SFTP.
• REST-based provisioning interface.
• Real-time status validation.
• Reduced manual user administration effort.
• Reliable integration between CORS and WFS using Oracle Integration Cloud.

This blog provides an end-to-end overview of the user provisioning and role synchronization framework implemented using OIC between CORS and Workforce System (WFS).