Oracle Enterprise Manager - and the administrative "app" named coreapplication - serve as a central entry point for managing and monitoring all BI services. In the Diagnostic tab of the coreapplication we find links to the EM Log Viewer which provides us with a consolidated view of BI server or presentation server logs.
One of the benefits of the Log Viewer is that we can search across different files on different physical machines. For example, you might be looking for an SQL statement containing a specific physical table name.
Unfortunately, the physical SQL is not reachable by the Message field but in the Supplemental Detail field.
To search for text in this field, we have to click the Add Fields button and check the box for the Supplemental Detail field. As a result, we now have another line to enter search phrases.
|Click to enlarge|
have a nice day