Bookshelf Home | Contents | Index | PDF |
Oracle Migration Tool On Demand Guide > Migrating Cascading Picklists > Migrating Cascading Picklists > Updating or Inserting a Cascading Picklist (Upsert)This topic describes how to update a specific cascading picklist (if it exists), or insert that cascading picklist (if it does not exist) on your Oracle CRM On Demand environment (customer test environment or production). For the purposes of the Oracle Migration Tool On Demand client, this is known as an Upsert operation. This operation is specified using the About the Upsert OperationThe An Upsert operation on a cascading picklist fails if the following conditions occur:
NOTE: Related picklist values override the existing picklist values during an Upsert operation. SyntaxThe following is the syntax for using the Oracle Migration Tool On Demand client to update a specific cascading picklist (if it exists) or insert the cascading picklist (if it does not exist): migrationtool -u UserID -s ServerURL Upsert CascadingPicklist CascadingPicklistXML
The Oracle Migration Tool On Demand client requests your Oracle CRM On Demand password, which can be redirected (using the pipe command) to the client program from standard input; that is, from a file, from the command line, or from another program. Example of Updating or Inserting a Cascading PicklistThe following is an example of updating a specific cascading picklist (if it exists) or inserting that cascading picklist (if it does not exist) in your Oracle CRM On Demand server: migrationtool -u UserID -s ServerURL Upsert CascadingPicklist "C:\My Files\My CascadingPicklist.xml" NOTE: Quotation marks are required only if the path or file name contains spaces. |
Oracle Migration Tool On Demand Guide, Release 38, Rev. A | Copyright © 2019, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |