The Oracle HCM application aggregation is failing with below error.
Exception during aggregation. Reason: openconnector.ConnectorException: Received fatal alert: internal_error
But the test connection is working fine for this application. Anyone is having any solution to fix this error?.
Most probably (not sure) the error Received fatal alert: internal_error during Oracle HCM aggregation indicates a problem with SSL/TLS configuration, API response issues, or server-side restrictions.
To troubleshoot that you can do the following
SSL/TLS Configuration, ensure the server and Oracle HCM support TLS 1.2 or higher and Import Oracle HCM’s SSL certificate into SailPoint’s Java keystore:
Enable debug logs.
Test API Endpoints, by using Postman or cURL to verify Oracle HCM API responses.
Verify the permissions
Adjust Aggregation Settings by reducing batch size and increasing timeout values in the application configuration.
Check Network/Firewall by ensuring no firewall or proxy is blocking API calls (I know you mentioned that the test connection is success but double check again with the application technical owner)
Validate Oracle HCM Endpoint, just confirm with Oracle support that their API endpoint is stable and accessible.
Also as mentioned by @enistri_devo if you can give some logs also so we can check with you.