Execute below steps to resolve the issue:
1. Logon to Aria Orchestrator Client.
2. Navigate to Library >> SRM >> Configuration.
3. Run Workflow: "Remove Local Sites", provide details of the site which is not visible. The workflow helps to remove the site even it was not visible in Inventory. However, the site, being not visible is already invalid.
4. Run "Configure Local Sites" workflow to add the site and accept the new certificate.
5. Run "Login Remote Sites" to log in to the site.
6. The site becomes visible in Aria Orchestrator Inventory.