I was using the BizTalk Oracle adapter to call a package, and it did not get triggered. I enabled all instrumentation and logging, and still no result. Here is adapter’s screen shot
Solution
Inside Oracle – create an alias for the table (called a synonym in Oracle terminology)
create synonym MESSAGING_CONTROL for ops$profai.MESSAGING_CONTROL
Instead of the fully qualified name, replace it with the Oracle synonym created in the above step
Polling statement: SELECT SOURCE_LOCATION,MESSAGE_TYPE FROM MESSAGING_CONTROL