Commerce Attributes & Array Sets

Overview

Commerce attributes are the foundation for input fields to collect data such as billing, shipping, parts, pricing, and revenue information. They apply to a Transaction as a whole, or its specific line items, depending on in which Commerce document the attribute is created. Oracle CPQ provides default attributes as well as default attribute sets, for collecting data such as billing, shipping, and pricing information. You can also create custom Commerce attributes.

It is not possible to copy attributes from one document to another.

Notes:

  • Standard Process attributes (introduced in Oracle CPQ 23B) were rationalized to remove redundant attributes and to streamline and simplify Commerce integrations.
  • Standard Process attributes cannot be deleted or reordered, but default values and modify actions can be overridden.

In general, for attributes to appear on documents, they must be included in document views on a layout. However, you can change the access to an attribute, choose to hide or show it, use an attribute that isn't on a layout. For more information, see the topic Accessing, Hiding, and Reading Attributes.

There are several attributes available in Commerce

Attribute Types

The following attributes can be added to Commerce documents. For information about attribute and array sets, refer to Commerce Attribute Sets and Transaction Arrays.

ClosedBoolean

Boolean attributes allow you to define a field as any two choice option. Common uses are to indicate true/false, either/or, valid/invalid or to include/not include.

Boolean attributes are available for main documents and sub-documents.

Editor Properties
Available Tabs: General, Default, Modify, Document Views, Mapping
Required:

If this option is selected, the user will be required to enter a value before proceeding.

True Label Text to appear for 'true' option.
False Label Text to appear for 'false' option.
Exclude from XML:

This selection determines if an attribute is available to include in Email Designer and Document Designer documents. The attribute is available when this option is unselected.
Trigger Auto Update:

If this option is selected, a change of value of this attribute by the user will trigger updates by the system without the user invoking an action.

Note: Administrators should note that transaction level Auto Update Before Formulas will not execute for attributes without auto-update enabled. So if an attribute with Trigger Auto Update enabled has formula that references an attribute without auto-update, the attribute with Trigger Auto Update enabled will not execute the Auto Update Before Formulas when the attribute without auto-update is modified.
Validation: There are three validation options: None, Must be True, Must be False.

ClosedCurrency

The currency attribute is displayed as a floating point number field that will display the number in currency format. The currency displayed is the user's currency. A range check can be defined on currency attributes. Currency is formatted based on the current user's currency preference.

Currency attributes are available for main documents and sub-documents.

Editor Properties
Available Tabs: General, Default, Modify, Document Views, Mapping
Required:

If this option is selected, the user will be required to enter a value before proceeding.

Exclude from XML:

This selection determines if an attribute is available to include in Email Designer and Document Designer documents. The attribute is available when this option is unselected.
Trigger Auto Update:

If this option is selected, a change of value of this attribute by the user will trigger updates by the system without the user invoking an action.

Note: Administrators should note that transaction level Auto Update Before Formulas will not execute for attributes without auto-update enabled. So if an attribute with Trigger Auto Update enabled has formula that references an attribute without auto-update, the attribute with Trigger Auto Update enabled will not execute the Auto Update Before Formulas when the attribute without auto-update is modified.
Decimal Places:

This value determines how many decimal places are allowed for supported currency types.

Groups:

Used to add an attribute to an Attribute Group. Attribute Groups can contain one or more attributes and can be referenced in SUM and AVG aggregation functions in Formulas

For more information, refer to Attribute Groups.
Maximum Field Length:

This value determines the maximum number of characters that can be input into the field. The valid range for this value is 1 through 255.

Validation:

There are five validation options: Check Currency, Check Currency in Range, Check Currency for Maximum, Check Currency for Minimum, Check Currency for Non-negative.

Maximum Value: This field contains the maximum monetary value that can be input into the currency attribute.
Minimum Value: This field contains the minimum monetary value that can be input into the currency attribute. The minimum value must be less than the maximum value.
Deal Negotiation:

When Deal Negotiation is enabled for currency-type Commerce attributes, the Last Price Paid can be selected. Administrators can set the following attributes to specify Last Price Paid criteria: Customer Attribute, Net Price Attribute, Date Attribute, and Duration Attribute.

This option is only available for sub-document attributes.

ClosedCustomer ID

Creates the special customer id field and its attached actions in order to integrate Accounts data.

  • The Customer Id attribute is only available for main documents.
  • Only one Customer Id attribute can be added per main document.
Editor Properties
Available Tabs: General, Default, Modify, Document Views, Mapping
Required:

If this option is selected, the user will be required to enter a value before proceeding.

Exclude from XML:

This selection determines if an attribute is available to include in Email Designer and Document Designer documents. The attribute is available when this option is unselected.
Maximum Field Length:

This value determines the maximum number of characters that can be input into the field. The valid range for this value is 1 through 255.

ClosedDate

Creates an input field and validations for date inputs.The date attribute is displayed as a text box with a date selector tool. This gives the user the option to either enter a date manually or select one from the calendar. An automatic validation runs to ensure that the date complies with the application and user profile information.

Date attributes are available for main documents and sub-documents.

Editor Properties
Available Tabs: General, Default, Modify, Document Views, Mapping
Required:

If this option is selected, the user will be required to enter a value before proceeding.

Exclude from XML:

This selection determines if an attribute is available to include in Email Designer and Document Designer documents. The attribute is available when this option is unselected.
Includes Time:

This checkbox determines if a timestamp is included with the date.

Maximum Field Length:

This value determines the maximum number of characters that can be input into the field. The valid range for this value is 1 through 255.

Validation:

There are three validation options: None, Check for Future Date, Check Date in Range.

Start Date:

This field contains the start date value that can be input into the date attribute.

This field must be specified if Check Date in Range validation is selected.

End Date:

This field contains the end date value that can be input into the date attribute.

This field must be specified if Check Date in Range validation is selected.

ClosedFile Attachment

Creates a file attachment field for additional documents, such as proposals or eSignature documents.

File Attachment attributes are available for main documents and sub-documents.

Editor Properties
Available Tabs: General, Document Views, Mapping
Required:

If this option is selected, the user will be required to enter a value before proceeding.

Exclude from XML:

This selection determines if an attribute is available to include in Email Designer and Document Designer documents. The attribute is available when this option is unselected.
Exclude from PDF Merge:

This checkbox determines if the file uploaded to this attribute can be merged with the PDF proposal.

Allowed Extensions:

This menu selection specifies that only selected extensions will be supported in the file attachment attribute.

ClosedFloat

Creates an input field and validations for floating point numbers.

The Float attribute is available for main documents and sub-documents.

Editor Properties
Available Tabs:

General, Default, Modify, Document Views, Mapping
Required:

If this option is selected, the user will be required to enter a value before proceeding.

Exclude from XML:

This selection determines if an attribute is available to include in Email Designer and Document Designer documents. The attribute is available when this option is unselected.
Trigger Auto Update:

If this option is selected, a change of value of this attribute by the user will trigger updates by the system without the user invoking an action.

Note: Administrators should note that transaction level Auto Update Before Formulas will not execute for attributes without auto-update enabled. So if an attribute with Trigger Auto Update enabled has formula that references an attribute without auto-update, the attribute with Trigger Auto Update enabled will not execute the Auto Update Before Formulas when the attribute without auto-update is modified.
Decimal Places:

This field determines the number of decimal places that will be supported. The maximum number of decimal places that can be supported is 16.

Groups:

Used to add an attribute to an Attribute Group. Attribute Groups can contain one or more attributes and can be referenced in SUM and AVG aggregation functions in Formulas

For more information, refer to Attribute Groups.
Maximum Field Length:

This value determines the maximum number of characters that can be input into the field. The valid range for this value is 1 through 255.

Validation:

There are four validation options: Check Numeric, Check Positive, Check in Range, Check Positive or Zero.
Maximum Value:

This field contains the maximum value that can be input into the float attribute.

Minimum Value:

This field contains the minimum value that can be input into the float attribute. The minimum value must be less than the maximum value.
Conversion Group:

This menu lists available conversion methods.

When a conversion class is associated with a float attribute, users can indicate which units they are using when setting attribute values. Customers can use one of the built in conversion classes or they can create their own. The conversion classes are sets of units of measurement with multipliers that will convert values from one unit type to another. Administrators create two attributes; one for input and another for output. The first attribute, which is associated with a conversion class, is the input attribute. The second attribute is the output attribute. When a user enters a value and selects a unit of measure, the converted value will display in the output attribute.

For more information about , refer to Implement Unit Conversion Use Case.
Conversion Fields:

When a Conversion Group is selected, this menu lists available conversion units

ClosedGroup Sequence Number

The Group Sequence Number (variable name _group_sequence_number) is an extension of the Sequence Number and represents the hierarchy of each specific line item in the line item grid.

  • The Group Sequence Number attribute type is only available for sub-documents.
  • Only one Group Sequence Number attribute can be added per sub-document.
  • For more information, refer to Enabling Group Sequence Number.

End users can view recommended items and child line items with sequence numbers that are counted based on the parent line item's sequence.

Example: A parent line item can have a group sequence number of 1 and then the child items will have group sequence number of 1.1, 1.2, 1.3... and so on. This functionality is enabled when you add the _group_sequence_number attribute to the attribute list and the line item grid instead of _sequence_number.

Line items are automatically re-sequenced if the user enters a value in the group sequence number field. However, if the user enters an invalid value, then the user's input is ignored.

Group Sequence in the Legacy Transaction UI and JET Transaction UI

Editor Properties
Available Tabs: General, Default, Modify, Document Views, Mapping
Required:

If this option is selected, the user will be required to enter a value before proceeding.

Exclude from XML:

This selection determines if an attribute is available to include in Email Designer and Document Designer documents. The attribute is available when this option is unselected.
Maximum Field Length:

This value determines the maximum number of characters that can be input into the field. The valid range for this value is 1 through 255.

ClosedHistory

Creates a text area field which always appends the new input along with the user's name and time. This attribute can not be cleared or edited. This attribute type is not expected to automatically update but rather is updated by other actions.

The History attribute is available for main documents and sub-documents.

Editor Properties
Available Tabs: General, Modify, Document Views, Mapping
Exclude from XML:

This selection determines if an attribute is available to include in Email Designer and Document Designer documents. The attribute is available when this option is unselected.

ClosedInteger

Creates an input field and validations for integer numbers.

The Integer attribute is available for main documents and sub-documents.

Editor Properties
Available Tabs:

General, Default, Modify, Document Views, Mapping
Required:

If this option is selected, the user will be required to enter a value before proceeding.

Array Control Attribute:

Array Control Attributes can be used to set the size of an array set. Enabling this option designates the attribute as an Array Control Attribute. Array Control Attributes can be associated with multiple array sets.
Exclude from XML:

This selection determines if an attribute is available to include in Email Designer and Document Designer documents. The attribute is available when this option is unselected.
Trigger Auto Update:

If this option is selected, a change of value of this attribute by the user will trigger updates by the system without the user invoking an action.

Note: Administrators should note that transaction level Auto Update Before Formulas will not execute for attributes without auto-update enabled. So if an attribute with Trigger Auto Update enabled has formula that references an attribute without auto-update, the attribute with Trigger Auto Update enabled will not execute the Auto Update Before Formulas when the attribute without auto-update is modified.
Groups:

Used to add an attribute to an Attribute Group. Attribute Groups can contain one or more attributes and can be referenced in SUM and AVG aggregation functions in Formulas

For more information, refer to Attribute Groups.
Maximum Field Length:

This value determines the maximum number of characters that can be input into the field. The valid range for this value is 1 through 255.

Validation:

There are four validation options: Check Numeric, Check Positive, Check in Range, Check Positive or Zero.

Commerce integer attributes with range validation will no longer validate 0 if 0 is out of range.
Maximum Value:

This field contains the maximum value that can be input into the float attribute.

Minimum Value:

This field contains the minimum value that can be input into the float attribute. The minimum value must be less than the maximum value.
Enable Price Score:

When Price Score is enabled, administrators can select the Price Score Method and the attributes used in the calculation.

For more information, refer to the Deal Management Price Score topic.

ClosedLanguage

The Language attribute can be created at the Quote/Transaction-level and placed on the Commerce layout. When linked to a Print or Email action, the value of the Language attribute specifies what language the Document Designer template that is linked to the action should be outputted in upon printing. A Language attribute menu now exists on the XSL Views tab of Print and Email actions in order to associate a Language attribute with the action.

The Language attribute type is only available for main documents.

Editor Properties
Available Tabs: General, Default, Modify, Document Views, Mapping
Required:

If this option is selected, the user will be required to enter a value before proceeding.

Exclude from XML:

This selection determines if an attribute is available to include in Email Designer and Document Designer documents. The attribute is available when this option is unselected.
Constrained Menu Option Behavior:

This selection determines is constrained options are hidden or disabled.
Trigger Auto Update:

If this option is selected, a change of value of this attribute by the user will trigger updates by the system without the user invoking an action.

Note: Administrators should note that transaction level Auto Update Before Formulas will not execute for attributes without auto-update enabled. So if an attribute with Trigger Auto Update enabled has formula that references an attribute without auto-update, the attribute with Trigger Auto Update enabled will not execute the Auto Update Before Formulas when the attribute without auto-update is modified.
Menu Entry:

This option allows the administrator to select which languages are listed in the language menu.

ClosedMenu

Creates a menu field which may be multi-select or single select.

The Menu attribute type is available for main documents and sub-documents.

Editor Properties
Available Tabs:

General, Default, Modify, Document Views, Mapping
Required:

If this option is selected, the user will be required to enter a value before proceeding.

Array Control Attribute:

Array Control Attributes can be used to set the size of an array set. Enabling this option designates the attribute as an Array Control Attribute. Array Control Attributes can be associated with multiple array sets.
Exclude from XML:

This selection determines if an attribute is available to include in Email Designer and Document Designer documents. The attribute is available when this option is unselected.
Menu Type: This field is used to specify if the menu attribute is a Single-Select or Multiselect Menu.
Constrained Menu Option Behavior: This selection determines is constrained options are hidden or disabled.
Trigger Auto Update:

If this option is selected, a change of value of this attribute by the user will trigger updates by the system without the user invoking an action.

Note: Administrators should note that transaction level Auto Update Before Formulas will not execute for attributes without auto-update enabled. So if an attribute with Trigger Auto Update enabled has formula that references an attribute without auto-update, the attribute with Trigger Auto Update enabled will not execute the Auto Update Before Formulas when the attribute without auto-update is modified.
Menu Population

This section is used to create options for the menu attribute.

  • To add a menu item, enter the item name in the Menu Entry field, and click Add.
  • To remove a menu item, highlight the item name, and click Delete.

Menu items appear in the order they are listed in the Current Menu Entries list box. To reorder the list, highlight an item, and click the corresponding Up or Down button. The Entry Manager can also be used to manage menu items.

The number of total menu entries per Commerce Process should be less than 65536 in order to prevent issues during granular migration.

ClosedRead-only text or HTML

Creates a read-only field for text or HTML.

The Read-only text or HTML attribute type is available for main documents and sub-documents.

Editor Properties
Available Tabs:

General, Default, Document Views, Mapping

  • The Default tab allows the administrator display Transaction Analytics, BOM Hierarchies, and Visualizations.
Exclude from XML:

This selection determines if an attribute is available to include in Email Designer and Document Designer documents. The attribute is available when this option is unselected.

ClosedRevenue Category

Creates the main document Revenue Category attribute that identifies the category of revenue for the sales transaction (e.g. renewal versus new business). When an administrator adds a new Revenue Category type attribute, the Revenue Category (_revenueCategory_t) is generated. This is a Single Select Menu with "New", "Renew", and "Expansion" menu options.

  • The Revenue Category attribute is only available for main documents.
  • Only one Revenue Category attribute can be added per main document.
  • The Revenue Category attribute Variable Name (_revenue_category_t) is not editable.
Editor Properties
Available Tabs: General, Default, Modify, Document Views, Mapping
Required:

If this option is selected, the user will be required to enter a value before proceeding.

Exclude from XML:

This selection determines if an attribute is available to include in Email Designer and Document Designer documents. The attribute is available when this option is unselected.
Constrained Menu Option Behavior:

This selection determines is constrained options are hidden or disabled.
Trigger Auto Update:

If this option is selected, a change of value of this attribute by the user will trigger updates by the system without the user invoking an action.

Note: Administrators should note that transaction level Auto Update Before Formulas will not execute for attributes without auto-update enabled. So if an attribute with Trigger Auto Update enabled has formula that references an attribute without auto-update, the attribute with Trigger Auto Update enabled will not execute the Auto Update Before Formulas when the attribute without auto-update is modified.
Menu Population

This section is used to manage menu options for the menu attribute. This attribute contains "New", "Renew", and "Expansion" menu options.

You can modify the display text for the menu options and provide translations for the display text.

  • Revenue Category menu item Variable Names for the Revenue Category attribute are not editable.

  • Beginning in CPQ 22A administrators can rename the default menu options. They can also add, edit, and delete custom revenue category menu options.

Menu items appear in the order they are listed in the Current Menu Entries list box. To reorder the list, highlight an item, and click the corresponding Up or Down button. The Entry Manager can also be used to manage menu items.

ClosedRich Text

Creates an attribute that can be populated by the end user on the Commerce document.

The Rich Text attribute is available for main documents and sub-documents.

Editor Properties
Available Tabs:

General, Default, Modify, Document Views, Mapping

  • The Default tab allows the administrator select a template to pre-populate the Rich Text attribute.

The Rich Text Editor is used to edit attributes and associated templates. For more information, refer to Rich Text Editor.
Required:

If this option is selected, the user will be required to enter a value before proceeding.

Exclude from XML:

This selection determines if an attribute is available to include in Email Designer and Document Designer documents. The attribute is available when this option is unselected.
Manage Templates:

Allows the user to create a new template or edit an existing template. Full access users can choose to save a template in the Shared Template folder. This makes the template available for other rich text type attributes within the process. The template can also be saved in a folder created automatically for this attribute. This ensures that the template is available for this attribute only. The name of the folder is the same as the variable name of the attribute.

Number of characters to show:

This option determines how many characters are displayed for the attribute summary

ClosedSecure

Captures the entry in memory, masking its appearance on the page as it is entered.

  • The Secure attribute type is only available for main documents.
  • For more information refer to Secure Attributes.
Editor Properties
Available Tabs: General, Default, Modify, Document Views, Mapping
Required:

If this option is selected, the user will be required to enter a value before proceeding.

Exclude from XML:

This selection determines if an attribute is available to include in Email Designer and Document Designer documents. The attribute is available when this option is unselected.
Maximum Field Length:

This value determines the maximum number of characters that can be input into the field. The valid range for this value is 1 through 255.

ClosedSequence Number

The Sequence Number (variable name _sequence_number) identifies the line number sequence.

  • The Sequence Number attribute type is only available for sub-documents.
  • Only one Sequence Number attribute can be added per sub-document.
Editor Properties
Available Tabs: General, Default, Modify, Document Views, Mapping
Required:

If this option is selected, the user will be required to enter a value before proceeding.

Exclude from XML:

This selection determines if an attribute is available to include in Email Designer and Document Designer documents. The attribute is available when this option is unselected.
Maximum Field Length:

This value determines the maximum number of characters that can be input into the field. The valid range for this value is 1 through 255.

ClosedText

Creates an input field for short strings.

The Text attribute is available for main documents and sub-documents.

Editor Properties
Available Tabs: General, Default, Modify, Document Views, Mapping
Required:

If this option is selected, the user will be required to enter a value before proceeding.

Exclude from XML:

This selection determines if an attribute is available to include in Email Designer and Document Designer documents. The attribute is available when this option is unselected.
Maximum Field Length:

This value determines the maximum number of characters that can be input into the field. The valid range for this value is 1 through 255.

ClosedText Area

Creates a text area field for strings that are greater than 255 characters in length.

The Text Area attribute is available for main documents and sub-documents.

Editor Properties
Available Tabs: General, Default, Modify, Document Views, Mapping
Required:

If this option is selected, the user will be required to enter a value before proceeding.

Exclude from XML:

This selection determines if an attribute is available to include in Email Designer and Document Designer documents. The attribute is available when this option is unselected.

Administration

ClosedAdd Attributes to a Document Watch Video  Video icon

By default, the Document attributes are listed on the Attribute Lists page in the order that they are created. Composite attributes are always listed last.

  1. Login to Oracle CPQ and navigate to the Admin home page.

  2. Navigate to the Attributes List page.

    Admin > Process Definition > Documents > Main or Sub-Document Attributes

  3. Click Add.

  4. Enter the Label and Variable Name of the attribute.

    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.

    Add Main Information for attribute

  1. Choose the Attribute Type from the drop-down.

  2. Click Cancel to return to the Attributes List page without saving changes or click Add to save changes and open the Attribute Editor. The other fields on the Attribute Editor page depend on the attribute type.

    Notes:

    • After creating Document attributes, select one of the attributes to set a tab name for the Commerce Process.
    • Tabs are used to designate separate transactions on the Commerce Manager List page.

ClosedEdit a Document Attribute Watch Video  Video icon

  1. Login to Oracle CPQ and navigate to the Admin home page.

  2. Navigate to the Attributes List page.

    Admin > Process Definition > Documents > Main or Sub-Document

  3. Perform one of the following options: 
    • To edit an individual attribute: Click the attribute name.
    • To edit an attribute set: Click the attribute set name. Then click the attribute you want to edit.

  4. Edit any of the fields displayed in the Attribute Editor.

    To edit the default value, access rights, layout or product mapping, click a tab name and edit the information displayed.

    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.

  5. Click Apply to remain on the current page or click Update to return to the Attributes List page. Click Cancel to return to the Attributes List page without saving changes.

    Document attributes can be edited at any time.
    Edits are not visible until the process is deployed (or re-deployed).

ClosedReorder Commerce Attributes Watch Video  Video icon

Complete the following steps to reorder Commerce attributes

  1. ClosedNavigate to the Document List page.

    1. Click Admin to go to the Admin Home Page.

    2. Click Process Definition in the Commerce and Documents section.

      The Processes page opens.

    3. Select Documents from Navigation drop-down for the applicable process.

    4. Click List.

      The Document List page opens.

  2. Select Attributes from the applicable document Navigation drop-down.

  3. Click List.

    The Attribute List page opens.

  4. Scroll to bottom of page and click Reorder.

    Editable text fields appear in the Order column.

  5. Enter a new order number for the attributes you wish to reorder.

  6. Click one of the following actions:

    • Apply: saves changes and remains on the page.
    • Update: saves changes and returns to the Attribute List page.
    • Back: returns to the Attribute List page without saving changes.

Notes:

  • You can't reorder auto-generated Standard Process attributes.
  • Custom attributes are added after the last auto-generated Standard Process attribute.If multiple custom attributes are added, the custom attributes can be reordered.

ClosedDelete a Document Attribute Watch Video  Video icon

  1. Login to Oracle CPQ and navigate to the Admin home page.

  2. Navigate to the Attributes List page.

    Admin > Process Definition > Documents > Main or Sub-Document Attributes

  3. Select the checkbox next to the desired attribute.
  4. Click Delete.

  5. If you want to delete an entire attribute set, click the <attribute_set_name> and click Delete All.

    Warnings:

    • When an attribute is deleted, it is simultaneously deleted from all document views. It is not possible to recover the deleted data.
    • System attributes cannot be deleted. nor can you delete individual attributes from within an attribute set.

    Notes:

    • You can't delete auto-generated attributes from a Standard Process. Custom attributes created in a Standard Process can be removed.
    • If you delete attributes after deploying, re-map and repopulate your data columns. Otherwise, the Transaction Manager will not work correctly.
    • The remaining attribute(s), if any, will be automatically reordered when the page reloads.

ClosedSet a Default Value for a Commerce Attribute Watch Video  Video icon

  1. ClosedNavigate to the Attribute Editor page.

    1. Click Admin to go to the Admin Home Page.

    2. Click Process Definition in the Commerce and Documents section.

      The Processes page opens.

    3. For the process you are interested in, confirm that Documents is selected in the Navigation drop-down menu, and click List.

      The Document List page opens.

    4. For the main document, confirm that Attributes is selected in the Navigation drop-down menu, and click List.

      The Attribute List page opens.

    1. Click the name of the attribute for which you want to set a default value.

  2. Select the Default tab.

    Note: Defaults are provided for auto-generated Standard Process attributes.

    • To customize a default value, select the Override Standard Default option and then click Apply.
    • To quickly return to the standard default values, simply uncheck the Override Standard Default option, and then click Apply.

  3. Click one of the following radio button options:

    Radio Button Options

    		 Description
    None To not specify a default value, select the None radio button option.
    System Variable To set a default value based on a System attribute, click this radio button option and choose the System attribute you want to auto-populate the field.
    Data To set a static value, click this radio button option and enter a default value.
    Define Function

    To define a dynamic default value, click this radio button option and click Define Function. Use this advanced function editor to create a function that sets the default value into the field.

    Note: BML functions can't be used to populate an RTE attribute, they can only be used to select an existing template that is available for the specified attribute. The "Select a Template" drop-down menu provides a list of available templates.

    Refer to Rich Text Editor for information about shared templates.
    Select a Template This is only an option for Rich Text attributes. If this option is chosen, then the Rich Text attribute is pre-populated with the selected template.

  4. Click Apply to remain on the current page or Update to save changes and return to the Attributes List page.

    Defaults cannot be set for the following types of attributes: Summation, Read-Only Text, HTML File Attachment, Composite.

ClosedSet Modify Behavior for a Commerce Attribute

  1. ClosedNavigate to the Attribute Editor page.

    1. Click Admin to go to the Admin Home Page.

    2. Click Process Definition in the Commerce and Documents section.

      The Processes page opens.

    3. For the process you are interested in, confirm that Documents is selected in the Navigation drop-down menu, and click List.

      The Document List page opens.

    4. For the main document, confirm that Attributes is selected in the Navigation drop-down menu, and click List.

      The Attribute List page opens.

    1. Click the name of the attribute for which you want to set the modify behavior.

  2. Select the Modify tab.

  3. Select the Process Actions, Transaction, or Transaction Line tab.

    Note: Standard modify behavior is provided for auto-generated Standard Process attributes.

    • To customize the modify behavior, select the Override Standard Default option and then click Apply.
    • To quickly return to the standard modify behavior, simply uncheck the Override Standard Default option, and then click Apply.

  4. Click one of the following radio button options:

    Radio Button Options

    		 Description
    Define Function

    To define a dynamic default value, click this radio button option and click Define Function. Use this advanced function editor to create a function that sets the default value into the field.

    Note: BML functions can't be used to populate an RTE attribute, they can only be used to select an existing template that is available for the specified attribute. The "Select a Template" drop-down menu provides a list of available templates.

    Refer to Rich Text Editor for information about shared templates.
    Use Formula Use this option to modify the action based on a formula created using Formula Management.
    Use Specified Value Used to specify a specific value for an attribute's value when the associated modify action is invoked.
    Leave Value Unchanged Used to leave the attribute's value when the associated modify action is invoked.
    Revert to Default When the Revert to Default option is enabled, Oracle CPQ uses the default value set for the attribute itself. This option is useful for picking up the current date and time, one of the many uses you can choose this option for.
    Save from Form Saves values that were entered by the user.

    Click Apply to remain on the current page or Update to save changes and return to the Attributes List page.

    Modify behavior cannot be set for the following types of attributes: Summation, Read-Only Text, HTML File Attachment, Composite.

ClosedView Related Rules Associated with a Commerce Attribute Watch Video  Video icon

  1. ClosedNavigate to the Attribute List page.
    1. Click Admin to go to the Admin Home Page.

    2. Click Process Definition in the Commerce and Documents section.

      The Processes page opens.

    3. For the process you are interested in, confirm that Documents is selected in the Navigation drop-down menu, and click List.

      The Document List page opens.

    4. For the main document, confirm that Attributes is selected in the Navigation drop-down menu, and click List.

      The Attribute List page opens.

  1. For an attribute with List in the Related Rules column, click List.

    The List of Related Rules page opens.

    List of Related Rules page

  2. Open the related rules using one of the following methods.
    • Click Edit Function to open a function editor where the attribute is referenced, with the relevant script.

    • If there is no Edit Function link, click the Label link to view the related rule.

      In this example, click owner_t=createdBy_t ) to open the Function Editor with the relevant script.

ClosedAdd Commerce System Variables to Documents

You can display Commerce System attributes on documents or make them hidden and only use them in document calculations. When Commerce System attributes are mapped to document attributes, the variable values are determined once, at document creation time. To gain access to System attribute values at other times in a document's existence, you can return them in functions associated with Modify Commerce actions.

  1. Create a Document attribute.

    Most Commerce System variables are string types that can be quickly displayed using a text attribute.

  2. To associate a system variable value with the attribute, do one of the following:
    • For Text attributes: After defining the attribute name, variable name and attribute description, click the Default tab and enable the System Variable radio button. Then highlight the system variable you want to display.
    • For Numeric attributes: After defining the attribute name, variable name, attribute description, and any validation fields, click the Default tab and enable the Function radio button. Click Define Function, mark the system variable you want to display, scroll to the bottom of the window and click Next. In the Editor window, enter: return (<_variable_name>);
  3. Click Finish.

XML Example

<current_date><![CDATA[ 05/31/2002 12:54PM ]]></current_date>
<supplier_base_currency><![CDATA[ USD ]]></supplier_base_currency>
<user_currency_pref><![CDATA[ AUD ]]></user_currency_pref>
<currency_conv_rate><![CDATA[ 1.79624 ]]></currency_conv_rate>
You can use Numeric attribute types to store Commerce system variables, as long as the variable value is converted from string type to numeric type.
When Commerce system variables are included in a document, the system variable values are also included in the XML generated for the document. The values appear in XML tags named with the attribute variable names used to store system variable values.

ClosedEnable Group Sequence Numbers

To enable Group Sequence Numbers complete the following steps.

  1. Verify there is a Group Sequence Number sub-document (line) attribute with the variable name _group_sequence_number.

    Group Sequence Number on Attribute List page

    If the 'Group Sequence Number' attribute does not exist, complete the following steps to add the attribute:

    1. Scroll to the bottom of the sub-document Attribute List page and click Add.
    2. Select Group Sequence Number Attribute from the Attribute Type drop-down menu.
    3. Click Add, and then click Update.

  2. Add the Group Sequence Number to the Line item Grid in the Main Document Layout Editor.

    User side Group Sequence Number on Line Item Grid

Notes:

  • For detailed instructions, refer to Line Item Tables in Legacy Desktop Editor and JET Responsive Editor.
  • Group Sequence Number functionality is independent of Sequence Number.
  • Group Sequence Number should not be used in conjunction with Sequence Number.

ClosedFormulas in Reconfiguration Scenarios

The Reconfigure action is split into one parent (Reconfigure) and one sub-action (Reconfigure Inbound). This eliminates the need for conditionals to segregate logic.

  • The parent action (Reconfigure) contains all things common to both Reconfigure actions and its own identifiers: Label, Variable Name, Description, Action Icon, Show Loading Dialog, Layout Path, and Document Views Tab.
  • The sub-action (Reconfigure Inbound) only contains what is specific to it.
  • This allows administrators to execute a formula per attribute on:
    • Outbound paths from a Commerce Transaction.

    The Formula will run immediately after the user clicks the Reconfigure action in Commerce, and before the user enters Configuration.

    • Inbound paths to a Commerce Transaction.

    The Formula runs after the user clicks Save in the Reconfiguration, and before the user returns to the Commerce page.

  • Formula execution is consistent with the existing order of operations for inbound and outbound executions.

ClosedPrevent Posting of Read-Only Fields

An internal property gives Oracle CPQ customers the option to prevent Commerce read-only fields from being posted back to the server after a Commerce action is invoked.

While enabling this property will have nominal impact on performance, it is recommended not to post information back to the server when the data will not have changed since it was last posted.

To enable this property, open a ticket on My Oracle Support.

Notes

  • The Summation attribute was deprecated in Oracle CPQ 2016 R1.
  • You cannot change the type of a Menu attribute if it is already on a layout.
  • User are prevented from creating or adding Quotes from Configuration to Commerce if mandatory items are missing.
  • NULL and blank Integer values are treated as separate values:
    • NULL= 0
    • Blank = ""
  • Using NULL as an attribute value is strongly discouraged.
  • If you use logic that tests for NULL values in rule conditions or BML, confirm that the logic takes this difference into account.
  • Composite, read-only text, and HTML attributes are not editable by the user.
  • Attribute range calculations are validated on the Value Punch-In.
    • Example: If a value was passed in the URL to Configuration, it will be validated and an error message will appear.
    • This affects both Mobile and Desktop.

Custom Variable Name Conventions

Beginning in Oracle CPQ 23D, CPQ will adopt Oracle CX Sales variable naming conventions for custom items. When administrators create new custom entities in a Standard or non-Standard Commerce Process, an “_c” suffix will be appended to the variable name.

  • The new naming convention for custom variable names provides more consistency for integrations with Oracle CX Sales.
  • This update only effects new custom entities, and there is no change to existing custom entities.

Transaction data is stored indefinitely unless archived. This includes file attachments, which are treated the same as transaction data.

Refer to Archiving Transactions for additional information.

Related Topics

Related Topics Link IconSee Also