To effectively monitor SOAP messages at run time during the invocation of Oracle E-Business Suite services by Web service clients, if the runtime logging is enabled for a specific interface or service in the Log & Audit Setup Details page, log messages can be captured in Service Monitor against that instance for the specified service.
When a SOAP request is received, Service Provider generates a unique numeric instance ID based on a database sequence and passes it to Service Monitor. Therefore, each SOAP request in Service Monitor appears with instance ID and the Log icon letting you retrieve the log details.
Click the Log icon in the search result table to view log messages in the Web Service Runtime Logs page.
Attention: Runtime logging for PL/SQL, Concurrent Program, XML Gateway interface types is handled by Oracle SOA Suite; therefore, setting runtime log levels for these services in the Log & Audit Setup Details page will display Oracle SOA Suite logs if the services are deployed in Oracle SOA Suite. Limited runtime log statements from the Oracle E-Business Suite Integrated SOA Gateway code (identified by the package name oracle.apps.fnd.isg) will be displayed for these services.
Runtime logging for Business Service Object interface type is handled by Oracle E-Business Suite Integrated SOA Gateway; therefore Service Monitor shows Oracle E-Business Suite Integrated SOA Gateway logs for these interfaces based on the log level selected in the Log & Audit Setup Detail page.
The Web Service Runtime Logs page contains the following log regions:
Runtime Middle Tier Logs
Runtime Middle tier execution logs are retrieved from Oracle SOA Suite server's file system (File Logging) for Oracle E-Business Suite integration. Logs are compiled in a table for a selected service request.
However, unlike the Adapter logs that are retrieved from the Oracle E-Business Suite table, you can only view the middle tier log details, but you cannot delete this type of logs directly from the Service Monitor user interface.
Adapter Logs
For Web service execution on the Oracle E-Business Suite side, runtime logs are recorded and retrieved from the log table (FND_LOG_MESSAGES) for Oracle E-Business Suite (Database Logging).
These log messages are compiled and listed in the table format for the selected service in a given instance. Each entry in the table includes log sequence, log timestamp, module, severity level, and actual message.
Deleting and Exporting Logs in the Adapter Logs Region
In the Adapter Logs region, after viewing log messages retrieved for a request in a given instance, you can delete them if needed by clicking Delete Log. A warning message appears alerting you that this will permanently delete all adapter logs in the table. Click Yes to confirm the action. An empty log table appears after all adapter log messages have been successfully deleted.
Before deleting the logs, you can save a backup copy by clicking Export. This exports the records listed in the table to Microsoft Excel and you can use it later.
File Logging and Database Logging
In general, log statements can be captured either in the Oracle SOA Suite server's file system (File Logging) or in the Oracle E-Busines Suite database tables (Database Logging). By default, log statements are captured in the database if logging is enabled from the Log & Audit Setup Details page.
Enhancing Performance for Database Logging
In comparison to file logging, database logging reduces performance of design-time operations. Performance can be improved by setting the optional parameter <sid>.ISG_KEEP_ALIVE_DB_CONN=true in isgagent.properties in Oracle E-Buiness Suite.
Enabling File Logging
File logging is enabled by setting the following properties in isgagent.properties in Oracle E-Buiness Suite and isg.properties in Oracle SOA Suite:
Note: Logging mechanism should be the same across Oracle E-Business Suite and Oracle SOA Suite. If file logging is enabled in Oracle E-Business Suite, then it must be enabled in Oracle SOA Suite as well.
<sid>.ISG_GLOBAL_LOG=true
<sid>.ISG_LOGGER=FILE
In Oracle E-Business Suite, log files are created in the path specified in the property <SID>.ISG_TEMP_DIRECTORY_LOCATION in isgagent.properties file.
In Oracle SOA Suite server, log file is created in the path specified in the property <SID>.ISG_TEMP_DIRECTORY_LOCATION in $INST_TOP/soa/isg.properties file.
When file logging is enabled, log statements for design-time and runtime operations are not shown in the Interface Details page and Service Monitor user interfaces.
For information on log severity level and how to configure logs, see Adding a New Logging Configuration.
For information on how to view logs and error messages recorded during service generation and deployment at design time, see Viewing Generate and Deploy Time Logs.
To view log messages in Service Monitor:
Log in to Oracle E-Business Suite as a user who has the Integration Administrator role. Select the Integrated SOA Gateway responsibility.
From the navigation menu, select the Service Monitor link from the Administration section to open the Monitor Search page.
Perform a search to display the search result. See: Searching SOAP messages.
In the search result table, click the Log icon for a desired instance. The Web Service Runtime Logs page is displayed allowing you to view the log details.
In the Adapter Logs region, click Delete Log to delete all the logs listed in the table for a given instance if needed. Click Yes to confirm the action. Click No to return to the Web Service Runtime Logs page.
Click Export to export log list table to Microsoft Excel.