1. Oracle Migration Tool On Demand Guide
  2. Elements and Sections in the Cascading Picklist XML Output File

Elements and Sections in the Cascading Picklist XML Output File

The following table describes the elements and sections in the cascading picklist XML output file.

Table Elements and Sections in the Cascading Picklist XML File

Description Element or Section

<ObjectName> contains the system name of the record type (object), which never changes.

 
<data:ObjectName>Account</data:ObjectName>

The <ListOfCascadingPicklist> contains all of the cascading picklist definitions for the record type.

 
<data:ListOfCascadingPicklist>
. . .
</data:ListOfCascadingPicklist>

The <CascadingPicklist> section contains all of the details for a cascading picklist.

 
<data:CascadingPicklist>
. . .
</data:CascadingPicklist>

<ParentPicklist> contains the parent picklist.

 
<data:CascadingPicklist>
  <data:ParentPicklist>Organization Relationship
  </data:ParentPicklist>
. . .
</data:CascadingPicklist>

<RelatedPicklist> contains the related picklist.

 
<data:CascadingPicklist>
. . .
  <data:RelatedPicklist>Region</data:RelatedPicklist>
. . .
</data:CascadingPicklist>

<Description> contains the description of the cascading picklist.

 
<data:CascadingPicklist>
. . .
  <data:Description></data:Description>
. . .
</data:CascadingPicklist>

<SharedPicklistFlg> corresponds to the Enable Shared Cascading Picklist check box in the Cascading Picklist Setup page, and is applicable only for record types that support sharing picklist values. If this element is set to true, then the cascading picklist shares the configuration of another cascading picklist on a different record type, and the associations between the parent picklist values and the related picklist values are read-only.

The <SharedPicklistFlg> element can be set to true only if both the parent picklist and the related picklist on the current record type are custom picklist fields that take their values from the picklist fields that are used in a cascading picklist definition on another record type. For more information, see Oracle CRM On Demand Online Help.

 
<data:CascadingPicklist>
. . .
  <data:SharedPicklistFlg>false</data:SharedPicklistFlg>
. . .
</data:CascadingPicklist>

The <ListOfPicklistValueAssociations> section contains all of the associations for the cascading picklist. 

<data:CascadingPicklist>
. . .
  <data:ListOfPicklistValueAssociations>
. . .
  </data:ListOfPicklistValueAssociations>
</data:CascadingPicklist>

The <PicklistValueAssociations> section contains the details of the associations for a single value from the parent picklist:

  • <ParentPicklistValue> contains the parent picklist value.

  • <RelatedPicklistValue> contains a related picklist value. There is one <RelatedPicklistValue> element for each value in the related picklist that is associated with the <ParentPicklistValue>.

 
<data:CascadingPicklist> 
. . .
  <data:ListOfPicklistValueAssociations> 
    <data:PicklistValueAssociations>
      <data:ParentPicklistValue>IHN
      </data:ParentPicklistValue> 
      <data:RelatedPicklistValue>East
      </data:RelatedPicklistValue> 
      <data:RelatedPicklistValue>West
      </data:RelatedPicklistValue> 
    </data:PicklistValueAssociations> 
. . .
  </data:ListOfPicklistValueAssociations>
</data:CascadingPicklist>