Provider canot be found. It may not be properly installed

Issue: Error while creating HFM application
Error stack: HYPHFMhfmADOConnection.cpp . Provider cannot be found. It may not be properly installed.



Cause: Oracle clients did not get installed properly even though it showed green status on install

Solution:
Register oraOLEDDB11.dll
Regsvr32 <ORACLE_CLIENTS_HOME>\BIN\oraOLEDDB11.dll

Regsvr32 E:\Oracle\Middleware\db32\product\ora_32\BIN\oraOLEDDB11.dll