Technology Stack - EBS (MOSC)

MOSC Banner

How to update custom workflow mailers during clone

edited Jul 31, 2015 10:02AM in Technology Stack - EBS (MOSC) 2 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center