Enable Custom Attributes for Crediting and Classification Rules
Your transactions capture custom attributes using descriptive flexfields. You can use the attributes to determine who should receive credit or to classify the transaction. Classification ties a transaction to a specific performance measure on a plan.
Enable a flexfield that uses an LOV to select customer account levels.
-
Create a lookup type and code.
-
Create a value set.
-
Enable the descriptive flexfield segment to be used.
-
Designate and enable the attribute to be used for crediting and classification.
Create a Lookup Type and Code
Create a value set for a list of values for the attribute. In this example, create a lookup type to store specific lookup codes for the list of values.-
In the Setup and Maintenance work area, go to the following:
-
Offering: Sales
-
Functional Area: Incentives
-
Task: Manage Incentive Compensation Lookups
-
-
In the Manage Incentive Compensation Lookups page, create a lookup type by entering these values.
Field
Value
Lookup Type
CUST_ACCT_LVL
Meaning
Customer Account Level
Module
Shared (It can be used everywhere within Incentive Compensation
-
Save.
-
Create lookup codes by entering these values.
Lookup Code
Display Sequence
Enabled
Meaning
PREMIER
1
Selected
Premier
GOLD
2
Selected
Gold
SILVER
3
Selected
Silver
-
Save.
Creating a Value Set
-
In the Setup and Maintenance work area, go to the Manage Incentive Compensation Value Sets task.
-
In the Manage Incentive Compensation Value Sets page, enter these values.
Field
Value
Value Set Code
CUST_ACCT_LVL_LOV
Description
Restrict data to CUST_ACCT_LVL lookup values
Module
Incentive Compensation
Validation Type
Table
Value Data Type
Character
FROM Clause
FND_LOOKUP_VALUES_VL
Value Column Name
LOOKUP_CODE
Description Column Name
MEANING
ID Column Name
LOOKUP_CODE
WHERE Clause
LOOKUP_TYPE = 'CUST_ACCT_LVL'
ORDER BY Clause
DISPLAY_SEQUENCE
-
Save.
Enable the Descriptive Flexfield Segment
-
In the Setup and Maintenance work area, go to the Manage Incentive Descriptive Flexfields task.
-
In the Manage Incentive Descriptive Flexfields page, search for the flexfield code CN.
-
From the result select Base Transaction and Edit.
-
Complete these fields to create a new descriptive flexfield global segment.
Field
Value
Name
Customer Account Level
Code
Customer_Account_Level (default)
API Name
CustomerAccountLevel (default)
Data Type
Character
Table Column
ATTRIBUTE11
Value Set
CUST_ACCT_LVL_LOV
BI Enabled
Selected
-
At the Flexfield Summary page, select the flexfield and click Deploy Flexfield.
Designate and Enable the Attribute to Be Used for Crediting and Classification
-
In the Setup and Maintenance work area, go to the Manage Custom Rule Qualifiers task.
-
In the Manage Custom Rule Qualifiers page, add a new record and enter these values.
Some fields aren't available to be added as custom qualifiers.Field
Value
Rule Type
Credit and Classification rules
Lookup Type
Fixed Choice List
Qualifier Usage
Global
Qualifier Operators
Select Equal to
Note: Only select the qualifier operators (Equal, Like, Between) that you plan to use. Selecting all or Between impacts performance.Name
Customer Account Level
-
Click Save and Done.
Note: After you save your custom rule qualifier, you can edit the qualifiers to add more operators for a specific business unit. -
In the Setup and Maintenance work area, go to the Configure Tables and Columns task.
-
In the Configure Tables and Columns page, make sure you are pointing to the correct business unit.
-
Select the table CN_TP_TRANSACTIONS_ALL.
-
Confirm the check boxes for crediting and classification are enabled for the Customer Account Level attribute.
Tip: The User Name field for the attribute column is blank. If you plan to also use this attribute column in expressions, then give it a name. -
Save.