Part Custom Fields

Part custom fields can be used to create part filters or supplement the set of base attributes available for parts. Customers can select which standard part fields and part custom fields for the part attribute set.

The Available Fields section displays the count of fields remaining for use. Oracle CPQ supports up to 600 part custom fields. These fields can be hidden or displayed on the search pages.

• Text/Menu: 350 text fields that can be String, Single Select Menu, or Multi-Select Menu data types.

  Oracle CPQ 24D increases the allowable number of menu entries for Part Custom Field Multi-Select Menus from 30 to 100.

• Number: 200 number fields that can be Float or Integer data types.
• Date & Time: 50 date & time data types.

The following image displays the Part Custom Fields page with the remaining Available Fields count.

Complete the following steps to add a new part custom field.

1. Navigate to the Admin Home Page.
2. Click Parts in the Products section. The Parts Administration page opens.
3. Click Customize Part Fields. The Part Custom Fields page opens.
4. Click Add. The Part Custom Field Editor opens.
5. General options:
   1. Enter the Field Name for the part custom field.
   2. Select the Required option if the user must enter a value into this part custom field when creating new parts.

   3. Select the Data Type.

      String, Single Select Menu, Multi Select Menu, Float,

      Note: Additional section will vary dependent on the selected Data Type.

   4. If desired, select a specific Variable Name.

   5. If applicable, set a Default Value that will pre-populate the part custom field.

      • Enter the desired default value for String, Float, or Integer data types.

      • For Date data types, click the Calendar icon to select a default date value,
        and then click Set Time to select a default time value.

        

        Note: The date and time entered in Part Custom Field Editor will use the current user's time zone. The date value retrieved during runtime will be the system time zone, which typically is UTC.

6. Display part custom field on search, BOM, or detail user-side pages.

   

   1. Select the Show Field option to display the part custom field on the applicable user-side page.
   2. Enter a Page Specific Label to display a custom label.

7. Search Behavior if applicable set search behavior for String data types.

   Select one of the following options for the Leading Wildcard and the Trailing Wildcard.

   • Not Allowed - wildcards are not allowed
   • Implicit - Wildcards are implied in the search without specifically adding a wildcard character.

   • Explicit - Wildcards must be specified to be considered in the search.

     Example: If the part is named thisisapart, and you are searching for isa:

     • Not Allowed: Will not include any results.
     • Implicit: Will automatically include the result when both leading and trailing are set to implicit.
     • Explicit: Wildcards must be included to see result, for example, %isa%

8. Search Operator if applicable, select the desired operator for Float or Integer data types.

9. Click Update.
10. Click Deploy to activate the changes on user side.

Complete the following steps to display a part custom field on user-side search, BOM, or detail pages and to set search behavior for applicable data types.

1. Navigate to the Admin Home Page.
2. Click Parts in the Products section. The Parts Administration page opens.
3. Click Customize Part Fields. The Part Custom Fields page opens.
4. Click on the applicable Part Custom Field.

5. Display part custom field on search, BOM, or detail user-side pages.

   

   1. Select the Show Field option to display the part custom field on the applicable user-side page.
   2. Enter a Page Specific Label to display a custom label.

6. Menu Population If applicable, enter menu items for Single Select Menu or Multi Select Menu data types.

   

   Notes:

   • You must create at least one menu entry before you can save menu part custom fields.

   • Oracle CPQ 24D increases the allowable number of menu entries for Part Custom Field Multi-Select Menus from 30 to 100.

   1. Enter a value for Displayed Text.

   2. The Variable Name field populates automatically. Variable names can only contain alpha-numeric characters and underscores. The entry can be changed before saving, but after saving the value is read-only.

   3. Click Add Entry.

   4. The values you entered for Displayed Text and Variable Name appear in the list.

   5. Click Entry Manager to edit the order of the menu options or change the menu display names.

                                - - - or - - -

      Use the Up and Down icons on the right side of the list to edit the order of the menu options.

   6. Set a Default menu value by selecting a menu value and clicking Set.

7. Number of Decimal Places if applicable, select the precision for Float data types.

   

   Precision - Choose the number of decimal places that will be accepted in the part custom field.

8. Validation Fields if applicable, set up validation for Float or Integer data types.

   

   1. Select the Validation Type Check Float in Range or Check for Positive Float.

   2. Enter a Minimum Value.

   3. Enter a Maximum Value.

9. Unit Fields if applicable, set up unit conversion for Float data types.

   Select a Conversion Group and its associated Default Unit for the custom part field.

   

   1. Select a Conversion Group.

   2. Select the associated Default Unit.

   Refer to Unit Conversions for more information.

10. Search Behavior if applicable set search behavior for String data types.

    Select one of the following options for the Leading Wildcard and the Trailing Wildcard.

    • Not Allowed - wildcards are not allowed
    • Implicit - Wildcards are implied in the search without specifically adding a wildcard character.

    • Explicit - Wildcards must be specified to be considered in the search.

      Example: If the part is named thisisapart, and you are searching for isa:

      • Not Allowed: Will not include any results.
      • Implicit: Will automatically include the result when both leading and trailing are set to implicit.
      • Explicit: Wildcards must be included to see result, for example, %isa%

11. Search Operator if applicable, select the desired operator for Float or Integer data types.

12. Click Add.

13. (Optional) Select Filter from the Filter/Normal drop-down menu to create Part Filters.

    For more information, refer to Part Filters.

14. Click Deploy to activate the custom parts fields and filters.

The "Part Custom Field" migration category enables migration of deployed part custom fields. administrators can now migrate part custom fields instead of recreating the same fields on multiple sites. The Migration Center also supports cross dependency for Part Custom Field definitions when migrating a Commerce process with mapped Part Custom Fields.