Let me provide a comprehensive solution based on your specific situation. I’ve resolved this exact issue for multiple clients post-cloud migration.
Your three core issues explained:
Approval stuck at manager level: The workflow execution reaches the approval step but cannot identify valid approvers because the security group evaluation returns empty results at the moment of execution.
Error showing “Approver not found in security group”: This error is generated when the business process approval step queries the security group and receives zero members. The security group exists and has members, but the query timing is critical.
Security groups checked with no resolution: Manual verification shows correct membership because you’re checking after the security group calculation has completed. The workflow executes immediately after submission, before calculation finishes.
Root cause analysis:
Cloud environments use distributed caching and asynchronous processing for security group calculations. When you migrated, your business process retained the on-premise assumption of immediate security group availability. On-premise systems calculated security groups synchronously, but cloud architecture prioritizes performance through asynchronous calculation.
Your security group uses calculated fields based on cost center assignments, which requires:
- Worker data update propagation (1-2 minutes)
- Cost center relationship calculation (2-3 minutes)
- Security group membership recalculation (3-5 minutes)
Total latency: 6-10 minutes in cloud vs. near-instant on-premise.
Complete resolution:
-
Immediate fix - Add wait step:
- Open your Travel Expense Approval business process
- Before the Manager Approval step, insert a Wait step
- Configure: Wait for 8 minutes (covers calculation latency with buffer)
- This ensures security group membership is calculated before approval evaluation
-
Better long-term solution - Convert security group:
- Navigate to Security > Maintain Security Groups
- Locate your expense approver security group
- Change from “Calculated” to “Explicit Membership”
- Use a scheduled integration to update membership daily based on cost center assignments
- This eliminates calculation delays during workflow execution
-
Optimal solution - Redesign approval logic:
- Modify business process to use supervisory organization directly instead of security groups
- Configure approval step: “Manager in Supervisory Organization”
- This bypasses security group calculation entirely
- Supervisory relationships are maintained in real-time in cloud
-
Validation steps:
- Submit a test expense report
- Monitor business process execution in Process History
- Verify the wait step completes before approval evaluation
- Confirm approver is identified and notification sent
Additional cloud-specific considerations:
Enable business process debug logging temporarily to capture exact timing of security group queries. You’ll see the query executing before group membership is available. Also review your notification configuration - cloud requires explicit email delivery service configuration that differs from on-premise SMTP settings.
Implement option 3 (supervisory organization) for best performance and reliability in cloud environments. This approach aligns with Workday’s cloud architecture recommendations and eliminates the calculated security group dependency entirely.
Your 200 pending expenses can be manually reassigned to the approval step after implementing the fix, or you can create a temporary business process version without the wait step and manually approve the backlog while the corrected process handles new submissions.