Please check following steps:
1. Check instructions under
..\Modules/DSI/dvd/documentation/en-US/OneIM_DatabaseSystemsIntegration_Administration.pdf
2. Clear application cache
a. Enable "expert mode" in the SynchronizationEditor (under menu Database | Settings)
b, Clear application cache (take backup first):
"%localappdata%\One Identity\One Identity Manager\Cache"
"%localappdata%\One Identity\One Identity Manager\AssemblyCache"
"%localappdata%\One Identity\One Identity Manager\IntelliCache"
c. Compile DB.
d. Run the sync wizard again.
3. Check the template
While creating a generic db connection, enter "oracle" in the System Category
Check if the oracle template shows up in the template selection.
4. Check if the query is being used internally
Create a generic db connection to oracle target system with a blank template
Go to Target System of the project (Expert mode should be enabled for this first) and select Schema browser
5. Check also Guide online called
administration-guide-for-connecting-to-native-databases-through-database-systems-integration-module