Updating or Inserting Workflow Rules (Upsert)
This topic describes how to use the Upsert
command
to update workflow rules (if they exist) or insert workflow rules
(if they do not exist) in your Oracle CRM On Demand environment;
that is, a customer test environment or production environment. For
the purposes of the Oracle Migration Tool On Demand client, this
is known as an Upsert operation.
About the Upsert Operation
When you run
the Upsert
command, the existing workflow rules are
updated, new workflow rules are inserted, and rules that are not in
the request are deleted. The order of the rules in the workflow request
must match the order of the rules for the workflow result in the Oracle CRM On Demand application.
The changes following the Upsert operation are applied completely
or not at all.
For more information about the considerations that apply to Upsert operations, see Considerations That Apply to Upsert Operations.
Syntax
The following is the syntax for using the Oracle Migration Tool On Demand client to update workflow rules (if they exist) or to insert new workflow rules (if they do not exist):
migrationtool -u UserID -s ServerURL Upsert WorkflowRuleSet WorkflowRulesXML
where:
UserID is the user sign-in ID that has the appropriate privileges to run the Oracle Migration Tool On Demand client commands.
ServerURL is the URL for the Oracle CRM On Demand server where your company resides.
WorkflowRulesXML is the fully qualified path name of the workflow rules XML file, for example:
C:\My Files\My WorkflowRules.xml
Example of Updating or Inserting Workflow Rules
The following is an example of updating workflow rules (if they exist) or inserting workflow rules (if they do not exist) in your Oracle CRM On Demand server:
migrationtool -u UserID -s ServerURL Upsert WorkflowRuleSet "C:\My Files\My WorkflowRules.xml"