Commerce Attributes (Redwood)

Overview

This topic covers administration of commerce attributes using the Redwood interface pages. Refer to Commerce Attributes for administration using the classic interface pages.

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.

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.

Standard Process Attributes

CPQ provides a Standard Process that includes several attributes that were rationalized to remove redundant attributes and to streamline and simplify Commerce integrations. Standard process attributes cannot be deleted or reordered. If required, default values and modify actions can be overridden by administrators to incorporate their customization logic.

Administration Pages

Attributes Tab

Item	Description
1	Access the Deployment Center.
2	Search and filter attributes You can click inside the search field to filter or type in search criteria for attributes. You can also click on pre-defined filters that are provided below the search field. Type Filter - Select Type from the Search filter drop-down and select the type(s) to filter specific attribute types
3	Reorder attributes
4	Synchronize the Charge Array Set This action is only displayed for Transaction Line Attributes
5	Add a new attribute
6	View or edit an attribute
7	The following options are available from the Actions menu: Related References: Use this option to view related Analytics, Data Columns, Functions, Integrations, Library Functions, or Rules Delete an attribute. This option is not available for Standard Process attributes. Manage Template This option is only available for Rich Text attributes

Attribute Drawer

Item	Description
1	Tabs Basic Information Tab: Manage general information for an attribute. Available options vary based on attribute type. Mapping Information Tab: Hide attributes for specific product types or product segments. Modify Tab: Manage modify behavior for applicable attribute types. Document Views Tab: Manage attribute visibility or access for specific workflow steps and profiles.
2	Basic Information Tab Sections: Available sections vary based on attribute type. Layout Usage: Identifies layout references and provides access to JET and mobile layouts (if applicable). Default Value: Manage the default value for the attribute. Currency Precision: Manage how many decimal places are allowed for currency attributes. Validations: Manage validation criteria for attribute values. Menu Definition: Manage options for menu type attributes.
3	Click this icon to manage attribute translations.

Administration

Add or Edit an Attribute

Set Modify Behavior for an Attribute

Reorder Attributes

Delete an Attribute

Add 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.

Navigate to the Attributes tab.

Admin Home > Quotes > Process > Manage Transaction or Manage Transaction Line > Attributes
Select the applicable attribute.
Associate a system variable value with the attribute.
- Text attributes:
  1. Open the Default Value section, then select System Variable from the Default Value menu.
  2. Select the desired variable from the System Variable menu.
- Numeric attributes:
  1. Open the Default Value section, select Function from the Default Value menu, then click Define Function.
  2. Select the system variable you want to display, then click Next.
  3. Enter return <_variable_name>;
  4. Click Save and Close in the editor window.
Click Save and Close in the Edit Attribute drawer.

Notes:

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. View 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>

Enable Group Sequence Numbers

Prevent Posting of Read-Only Fields

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.