Setting Logging Level of SOA

Oracle provides a comprehensive documentation for the administration of Oracle SOA suite. A detailed description of the SOA logging levels is given at this documentation -

http://docs.oracle.com/cd/E15586_01/integration.1111/e10226/appx_trouble.htm#SOAAG97509

Beauty here is you can set the logging level at fine-grained component level. For instance you may want to the human workflow logging level to a finer level than bpel process manager.

Reset Oracle XE 11g Password

With Oracle XE 11g database you cannot retrieve the password if you have not configured the notification mails. As Oracle XE 11g sends mail for the forgotten password and to find the workspace for an email id.

But there is another way to reset the password in case you have forgot the INTERNAL workspace ADMIN password. Here are the steps to reset the ADMIN password from command line.

1. Goto folder <XE_HOME>\app\oracle\product\11.2.0\server\apex on your windows machine.
2. Open sql plus > sqlplus sys@XE as sysdba
3. Run the script > @apxchpwd.sql and enter new password when prompt comes.

Thats' it! the password has been changed now. Login on http://localhost:8080/apex with new password.

OSB Error : Failed to set the value of context variable "body"

A common error one can get while assigning variables in OSB is  -

Failed to set the value of context variable "body". Value must be an instance of {http://schemas.xmlsoap.org/soap/envelope/}Body.

OSB has some predefined variables like body and it expects that the variable body content should always be enclosed with <soap-env:body>. Inside this element you can assign any value.

If you don't want to be worried about this every time manipulating body variable then you must use "Replace" instead of "Assign". Just select "Replace node contents" and replace will take care of not removing the <soap-env:body> from the variable.