Skip to main content
Question

How to debug sql triggered from IFS Cloud using Oracle sql developer

  • October 24, 2025
  • 1 reply
  • 47 views

Forum|alt.badge.img+1

How to debug sql triggered from IFS Cloud using Oracle sql developer ?

1 reply

Mehmetkilivan
Do Gooder (Customer)
Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • October 24, 2025

I don’t think you can directly debug SQL from IFS Cloud in SQL Developer, since most queries are executed through the middleware layer.
However, you could try enabling SQL trace or monitoring active sessions in the Oracle database to capture the statements being executed by IFS.
Using DBMS_MONITOR or querying v$session and v$sql could help you identify which SQLs are triggered from your user context.