Missing Essbase Connection in Shared Connections Smart View

Issue: Unable to connect to Essbase Cluster using SmartView
Version: 11.1.2.5.210, Hyp 11.1.2.3.500
Cause: It is the behaviour of the product where APS was added after configuration and it did not update the entries as it does for other products.  I have seen this issue typically for APS and not for any other component.

APS is the service that connects Essbase with Foundation.

Analysis
1. Unable to see Essbase connection in the drop-down for SV
 
2. Cannot find Provider Service component in workspace list of versions


3. Cannot find APS in the Inventory even though it is installed, configured and running. APS entries exist in EPM Registry, it shows running in service panel etc.

Can check it by running
opatch lsinventory -detail -oh <ORACLE_HOME> -jre <JAVA_PATH>


4. Rolled back the existing patch
5. Go to ORACLE_MIDDLEWARE_HOME/oui ex D:/oracle/middleware/EPMSystem11R1/oui/
6. Launch setup.exe
    6.1 Choose correct Oracle Home D:/Oracle/Middleware/EPMSystem11R1
    6.2 Product.xml is automatically selected , click next
    6.3 Select APS only
    6.4 Click next and finish
7. Check inventory again and you can find that APS is now added to the inventory

After this point I am able to make private connections via 13080 port.
Now that I need it via my OHS . I reconfigured OHS so that it adds entries to the APS now.

Apply the Patch which was rolled back

1. Redeploy the Foundation App to reflect the changes (Delete tmp , cache and browser cache if necessary)
2. Restart Foundation and APS

Now the issue is fixed