Friday, September 28, 2018

Oracle Workflow Notification Translation

Hi,

Update row in below tables for translation.
WF_ACTIVITY_ATTRIBUTES_TL
WF_ITEM_ATTRIBUTES_TL
WF_MESSAGE_ATTRIBUTES_TL

examples :
select *
  from WF_ITEM_ATTRIBUTES_TL
   where Language = 'AR'
     and NAME like '%INVOICE%'
 where
 DISPLAY_NAME = 'Supplier Name'
   and Language = 'AR'
 
select *
  from WF_MESSAGE_ATTRIBUTES_TL
 where MESSAGE_NAME = 'DOCUMENT_APPROVAL_MSG1'
 -- DISPLAY_NAME = 'Supplier Name'
 and Language = 'AR'
   and MESSAGE_TYPE = 'APINVAPR'