Thursday, March 31, 2011

How to display carriage return in oa framework web page table.

   I am having a column in a table which has carriage return chr(13) in the value. oracle will take care of this in forms by giving a line break. But OA Framework does not allow it.

I searched for many places in the net and couldnt find a solution. so i tried and found an alternative. Go to that column in the Region of type table and make the item style as raw text. While getting the code from VO object, change the column in the query to Replace(column_name,chr(13),'<br>')
If you have used chr(10) you can also replace it with


So when showing in table, there will be a line break for each chr(13)

Wednesday, March 02, 2011

Error "You cannot change the owner of this service request because there is an active workflow in progress" in E-business Suite

   In Create SR Page, When a SR is created for a particular SR type. the task gets created after that usually[Tasks are defined in Task Template].
But currently it is taking 10 to 15 minutes to automatically create. During this time, if we try to update sr we get error “You cannot change the owner of this service request because there is an active workflow in progress”. 

Solution: Go to Setup Service Requests -> Request Types   
Select the service type you are facing problem and you would see that the workflow contains
"@Duplicate Check and Auto Task Create for Web/EMC created SR"

Clear the workflow field and save. Now the issue will not come