This chapter covers the following topics:
Flexfields are used in Oracle Incentive Compensation for classification of transactions, in defining plan elements, and in setting up compensation plans. They are all optional. Use a flexfield when you want to set up a additional input field on a page that is preset with a recognizable name and a specific set of values from which to select. For example, a field can be called Item Number, and be set up with particular values that you enter in Oracle Forms. The built-in flexfields allow a small amount of custom formatting of a page without programming.
Oracle Incentive Compensation uses descriptive flexfields, which provide customizable expansion space on a page. There are three flexfields used in this release of Oracle Incentive Compensation.
| Flexfields | Code |
|---|---|
| CN Commission Headers | CN_COMMISSION_HEADERS_ALL |
| CN Compensation Plans | CN_COMP_PLANS_ALL |
| CN Quotas | CN_QUOTAS_ALL |
The flexfields are enabled in three tables:
CN Commission Headers
Oracle Incentive Compensation contains 100 numbered attributes that can be customized for use with classification of transactions. These attributes are seeded with the application.
CN Compensation Plans
Oracle Incentive Compensation contains 15 numbered attributes that can be customized for use with defining compensation plans. These attributes are seeded with the application. This flexfield appears on the Plan Design page.
CN Quotas
Oracle Incentive Compensation contains 15 numbered attributes that can be customized for use with defining plan elements. These attributes are seeded with the application. This flexfield appears on the Update Plan Element page.
When you display the context fields in the HTML application, the standard display is as Context Value. The field names can be customized by logging into the Oracle Forms as an Application Developer and using the Descriptive Flexfield Segments screen (Flexfield > Descriptive > Segments). Or, you can eliminate the fields by not checking the Displayed box. You can make the flexfield a required value. See the Oracle Applications Flexfields Guide for information about setting up flexfields.