Oracle Incentive Compensation (OIC) is an Oracle E-Business Suite application that helps enterprises manage their business objectives by controlling the way they compensate their sales forces. OIC is designed to calculate and pay compensation to sales personnel (resources). It provides the flexibility to compensate nonemployees too, such as vendors, suppliers and partners.
The following sections describe the flows in the Oracle Incentive Compensation advanced pack.
This flow creates a pay group with From and To dates in the open compensation period. Associate the sales compensation role with this pay group. This in turn associates the sales compensation resources having this role with the plan.
This section provides information on prerequisites, profile options, and data setups required to execute the Create Pay Group and Associate flow.
Create_Pay_Group_And_Associate_Role_To_It
The following is a prerequisite for executing this flow:
User is logged in with the Compensation Manager responsibility.
Not applicable.
Not applicable.
The following data must be set up:
Page Name | Field Name | Field Value |
---|---|---|
Create Pay Group | Operating Unit | Vision Operations |
This flow creates a payment plan and associates the sales compensation role with this payment plan. This in turn associates the sales compensation resource with this plan.
This section provides information on prerequisites, profile options, and data setups required to execute the Create a Payment Plan and Map Role or Resource flow.
Create_Payment_Plan_And_Map_Role
The following is a prerequisite for executing this flow:
User is logged in with the Plan Administrator responsibility.
Not applicable.
The following predefined data must be used:
Page Name | Field Name | Field Value |
---|---|---|
Create Payment Plan | Payment Group | Standard |
Create Payment Plan | Payment Interval | Period |
The following data must be set up:
Page Name | Field Name | Field Value |
---|---|---|
Create Payment Plan | Operating Unit | Vision Operations |
This flow performs advance configuration for Application Parameters, Collection, Calculation and Payment.
This section provides information on prerequisites, profile options, and data setups required to execute the Perform Advance Configuration flow.
Perform_Advance_Configuration
The following is a prerequisite for executing this flow:
User is logged in with the Incentive Compensation Administrator responsibility.
Not applicable.
The following predefined data must be used:
Page Name | Field Name | Field Value |
---|---|---|
Configure Tables and Columns | Table | CN_COMMISSION_HEADERS |
Generate Collection Packages | Transaction Source | Order Booking Receivables Posting |
Define Collection Sources and Mapping | Transaction Source | Order Booking |
The following data must be set up:
Page Name | Field Name | Field Value |
---|---|---|
Configuration Workbench – Setup Tasks | Operating Unit | Vision Operations |
This flow creates a product that can be used while defining a transaction. Associate this product with a product hierarchy that is displayed in a compensation plan. The flow creates classification rules to classify the product added in a new transaction. This completes the setup of creating a product, associating it with a hierarchy, and defining it in the classification rules et.
This section provides information on prerequisites, profile options, and data setups required to execute the Setup Product and Classification Rules flow.
Setup_Product_And_Classification_Rules
The following is a prerequisite for executing this flow:
User is logged in with the Plan Administrator responsibility.
Not applicable.
The following predefined data must be used:
Page Name | Field Name | Field Value |
---|---|---|
Hierarchies | Hierarchy Type | Products |
Hierarchies | Base Table | CN_REVENUE_CLASSES |
Hierarchies | Primary Key | REVENUE_CLASS_ID |
Hierarchies | Display Column | NAME |
The following data must be set up:
Page Name | Field Name | Field Value |
---|---|---|
Products | Operating Unit | Vision Operations |
Hierarchies | Operating Unit | Vision Operations |
Hierarchies | Name | Product Hierarchy |
Classifications | Operating Unit | Vision Operations |
Classifications | Name | Classification Sales |
This flow creates an input and output expression, and a formula using the expressions, and associates a new rate table with this formula.
This section provides information on prerequisites, profile options, and data setups required to execute the Create Expression and Formula flow.
Create_Expression_And_Formula
The following are the prerequisites for executing this flow:
User is logged in with the Plan Administrator responsibility.
Rate table with rate dimensions exists.
Not applicable.
The following predefined data must be used:
Page Name | Field Name | Field Value |
---|---|---|
Create Expression – Expression Builder | Component | Sales Compensation Elements - Commission Headers - TRANSACTION_AMOUNT |
Create Expression – Expression Builder | Component | Others – Rate Table Result |
Create Formula | Calculation Type | Commission |
Create Formula – Options tab | Process Transaction | Individually |
Create Formula – Options tab | Split Option | No Split |
The following data must be set up:
Page Name | Field Name | Field Value |
---|---|---|
Create Expression | Operating Unit | Vision Operations |
Create Formula | Operating Unit | Vision Operations |
Create Formula – Options tab | Process Transaction | Individually |
Create Formula – Rate Tables tab | Name | Predefined rate table |
This flow creates a plan element and associates a precreated formula with this plan element. This in turn maps the rate table associated with the formula to the plan element.
This section provides information on prerequisites, profile options or data setups required to use the Create Plan Element flow.
Create_Plan_Element
The following are the prerequisites for using this flow:
User is logged in with the Plan Administrator responsibility.
A formula exists.
Not applicable.
The following predefined data must be used:
Page Name | Field Name | Field Value |
---|---|---|
Create Plan Element – General Information | Calculation Type | Commission |
The following data must be set up:
Page Name | Field Name | Field Value |
---|---|---|
Create Plan Element – General Information | Operating Unit | Vision Operations |
This flow creates a compensation plan and associates a plan element with this plan. The flow defines the eligibility by mapping a role to this plan which in turn maps the resources having this role with the plan.
This section provides information on prerequisites, profile options, and data setups required to execute the Create Compensation Plan flow.
Create_Compensation_Plan
The following are the prerequisites for executing this flow:
User is logged in with the Plan Administrator responsibility.
Predefined plan element exists.
Not applicable.
Not applicable.
The following data must be set up:
Page Name | Field Name | Field Value |
---|---|---|
Compensation Plan - Design | Operating Unit | Vision Operations |
Compensation plan along with its components can be exported in an XML file. This XML file can be imported to replicate all the details of a plan, except for role mapping. If the plan has to be imported in the same instance, the name of the plan needs to be changed in the Import Request page. Plan modeling enables users to export multiple plans into a single XML file.
The Manage Plan Scenarios flow lets you manage the compensation plan scenarios.
This section provides information on prerequisites, profile options, and data setups required to execute the Manage Plan Scenarios flow.
Manage_Plan_Scenarios
The following are the prerequisites for executing this flow:
User is logged in with the Plan Administrator responsibility.
Predefined compensation plan element exists.
Not applicable.
Not applicable.
The following data must be set up:
Page Name | Field Name | Field Value |
---|---|---|
Create Scenario | Operating Unit | Vision Operations |
Sales Credit Allocation is an optional method of splitting the sales credit. It automates the credit allocation process by systematically applying a set of consistent rules. This minimizes errors, thereby reducing the time that compensation analysts spend reconciling them. One of the ways for defining these rules is by using Oracle Territory Manager, as performed in this flow.
This section provides information on prerequisites, profile options, and data setups required to execute the Verify Sales Credit Allocation flow.
Verify_Sales_Credit_Allocation
The following are the prerequisites for executing this flow:
User is logged in with the Compensation Manager responsibility.
Configurable descriptive flexfields to capture split percentage and revenue type are defined. This is done using the Application Developer or System Administrator responsibility.
Date effective territories and assignments are defined and the split percentage and revenue type are entered. The engine uses the transaction processed date when matching and assigning sales representatives.
Classification attributes are defined and enabled so that they can be entered while creating transactions.
The following profile options must be set:
Profile Option Name | Profile Option Value | Level |
---|---|---|
OIC: Skip Credit Allocation | No | User |
OIC: Territory Manager Split Percentage Flex Field | ATTRIBUTE1 | Site |
OIC: Territory Manager Revenue Type Flex Field | ATTRIBUTE2 | Site |
OIC: Number of Batch Workers for Credit Allocation | 10 | Site |
The following predefined data must be used:
Window Name | Field Name | Field Value |
---|---|---|
Descriptive Flex-field Segments | Application | CRM Foundation |
Title | Territory Resource FF | |
Context Field Values | JTY_Sales | |
Segments Summary | Column (for row 1) | ATTRIBUTE1 |
Name (for row 1) | Split Percentage | |
Column (for row 2) | ATTRIBUTE2 | |
Name (for row 2) | Revenue Type |
The following data must be set up:
Page Name | Field Name | Field Value |
---|---|---|
Territory Administration | Operating Unit | Vision Operations |
Revenue Type | REVENUE |
In this flow, users can create bulk transactions by importing a .csv file containing all the information required for a transaction.
This section provides information on prerequisites, profile options, and data setups required to execute the Import Transaction flow.
Import_Transaction
The following is the prerequisite for executing the Import Transactions flow:
User is logged in with the Compensation Manager responsibility.
Not applicable.
The following predefined data must be used:
Page Name | Field Name | Field Value |
---|---|---|
Imports Definition | Import Type | Transaction API |
Imports Definition | Column Delimiter | Comma |
Imports Definition | Field Enclosed By | Double Quotation |
Import Header Mapping | Target Fields | EMPLOYEE_NUMBER PROCESSED_DATE REVENUE_TYPE TRANSACTION_AMOUNT ATTRIBUTE1 |
The following data must be set up:
Page Name | Field Name | Field Value |
---|---|---|
Imports Definition | Operating Unit | Vision Operations |
Oracle Incentive Compensation is delivered with two predefined transaction sources which allow the collection of data from Oracle Receivables and Oracle Order Management. This is known as Standard Collection.
The Collect Transactions flow covers collection of data from these sources and verifying the transactions.
This section provides information on prerequisites, profile options, and data setups required to execute the Collect Transaction flow.
Collect_Transaction
The following are the prerequisites for executing this flow:
User is logged in with the Compensation Manager responsibility.
Collection packages are generated.
Not applicable.
The following predefined data must be used:
Page Name | Field Name | Field Value |
---|---|---|
Collect Transactions | Transaction Source | Receivables Posting Order Booking |
Collect Transactions | Transaction Type | Collect Clawbacks Collect Invoices Collect Payments and Givebacks Collect Revenue Adjustments Collect Writeoffs |
The following data must be set up:
Page Name | Field Name | Field Value |
---|---|---|
Collect Transactions | Operating Unit | Vision Operations |
This flow creates a manual transaction for a sales compensation resource with an Item ID as the key attribute. The user can load this transaction and create a calculation batch to calculate commission.
This section provides information on prerequisites, profile options or data setups required to use the Create Transaction and Verify Commission flow.
Create_Transaction_And_Verify_Commission
The following are the prerequisites for using this flow:
User is logged in with the Compensation Manager responsibility.
Sales compensation resource having a complete plan setup exists.
As an Incentive Compensation Administrator, the classification attribute ATTRIBUTE 1 is enabled and renamed as Item ID.
Not applicable.
The following predefined data must be used:
Page Name | Field Name | Field Value |
---|---|---|
Create Transaction | Transaction Type | Manual Transaction |
Calculate Compensation | Type | Commission |
The following data must be set up:
Page Name | Field Name | Field Value |
---|---|---|
Create Transaction | Operating Unit | Vision Operations |
Create Transaction | Item ID | AS72111 |
Load Transactions | Operating Unit | Vision Operations |
Calculate Compensation | Operating Unit | Vision Operations |
This flow creates a payment batch for a pay group that is predefined. In this pay group, the user can identify the sales compensation resources for whom payment needs to be processed, and then approve and pay the payment batch.
This section provides information on prerequisites, profile options, and data setups required to execute the Create and Pay Payment Batch flow.
Create_And_Pay_Payment_Batch
The following are the prerequisites for executing this flow:
User is logged in with the Compensation Manager responsibility.
A predefined pay group having the sales compensation roles or resources mapped to it.
Commission is calculated for the sales compensation resources for the given period.
A period is selected as per the transaction process date.
Not applicable.
Not applicable.
The following data must be set up:
Page Name | Field Name | Field Value |
---|---|---|
Create Payment Batch | Operating Unit | Vision Operations |
Create Payment Batch | Incentive Type | Commission |
This flow covers a complete business flow in Oracle Incentive Compensation – from creation of a sales compensation role and resource, to creation of all plan components and a compensation plan, setting up of product and classification rules, creation of a transaction, calculation of commission, and ending with the payment of this commission.
This section provides information on prerequisites, profile options, and data setups required to execute the Plan, Calculate, And Pay flow.
Plan_Calculate_And_Pay
The following is the prerequisite for executing this flow:
User has the Compensation Manager and Plan Administrator responsibilities
Not applicable.
Not applicable.
Not applicable.