You can see the details about Oracle application testing with UFT at this link:
https://admhelp.microfocus.com/uft/en/14.03/UFT_Help/Content/Addins_Guide/z_Sxn_AddinOracle.htm
For web based Oracle testing, you would need the Web addin in addition to the Oracle addin. Also, if it contains Java objects, you would need the Java addin. In the link above, if you look at the PreRequisites section, you will see the information-
Add-in Dependencies
The Web Add-in must be loaded. The Web Add-in supports Web-based forms.
The Java Add-in must be loaded if your Oracle test or business component includes Java test objects.