Debugging Database interactions in Oracle ADF can be a daunting task, to make your life easier output the executing SQL statements in the console (dev/test only) with the follow these steps:

JDeveloper> Run/Debug > Edit > Launch Settings > Java Options
Add in -Djbo.debugoutput=console

When you restart the application server you will start to see the executing SQL statements live.