Thanks for your question, and for the compliment.
The 3rd party support is provided for one major reason - to help customers migrate those 3rd party databases to Oracle. Since there's not much demand for migrating sqlite to Oracle Database, that's why you don't see the connectivity supported here.
Attempting to warehouse a SQLite database within our Oracle based warehouse is exactly what I need to be able to do. Our end-user reporting tool uses SQLite to store its reporting layer meta-data (in actually 2 SQLite databases), including user security in the tool and other data points which help us measure usage statistics. However, there are "inter-operability" needs to marry this data with other data in our warehouse.
Any suggestions on what other tools I might be able to use to get a work-flow started to map this out. I understand low demand, but there must be other options. Anyone have any other resources that might be helpful to us?