How to update custom workflow mailers during clone
We have 2 Workflow mailers running in our production environment. One is standard 'Workflow mailer' and other is designated for business logic to handle special workflows 'Workflow Mailer CUSTOM'.
1. Workflow Mailer CUSTOM
2. Workflow Notification Mailer
But post clone, custom workflow mailers values are not getting updated to target instance values. When I looked into the script, I found that it is being taken care by txkJavaMailerCfg.sql/.sh script. And it checks only for the component name 'Workflow Notification Mailer' in very first statement and updates related records.
select 1 from FND_SVC_COMPONENTS where component_name = ''Workflow Notification Mailer''
Is there template file, which Oracle facilitates the custom changes in workflow mailer setup fo cloning. So that we don't have any values pointing to production, after cloning. Any suggestion would be helpful.