gistfile1.sql

-- Oracle Applications (aka EBS)
-- Trailing blanks problem in Oracle Workflow

-- check:
select case when display_name!=trim(display_name) then '>'||display_name||'<' end xx_disp
  ,case when description!=trim(description) then '>'||description||'<' end xx_desc
, w.*
from wf_activities_tl w -- wf_item_types_tl, wf_activities_tl, wf_messages_tl
where display_name!=trim(display_name)
or description!=trim(description);

-- fix:
Update wf_activities_tl
  set display_name = trim(display_name)
    , description = trim(description)
  where display_name!=trim(display_name)
    or description!=trim(description);


Update wf_item_types_tl
  set display_name = trim(display_name)
    , description = trim(description)
  where display_name!=trim(display_name)
    or description!=trim(description);

Update wf_messages_tl
  set display_name = trim(display_name)
    , description = trim(description)
    , body = trim(body)
    , html_body = trim(html_body)
    , subject = trim(subject)
  where display_name!=trim(display_name)
    or description!=trim(description)
    or body!=trim(body)
    or html_body!=trim(html_body)
    or subject!=trim(subject);