Very handy for debugging runtime issues when developing, the Oracle ADF Business Components layer can output the SQL that it is executing. To do this though, the logging threshold must be set to a specific level…
‘-Djbo.debugoutput=console -Djbo.logging.trace.threshold=5’
Curiously. the SQL statements do not get displayed for any other threshold level.