Oracle Incentive Compensation Command Center

This chapter covers the following topics:

Incentive Compensation Command Center

Incentive Compensation Command Center Overview

Oracle Incentive Compensation Center is built on the Enterprise Command Center Framework. With it, sales plan administrators and sales compensation managers can gain strategic insight through facilitated analysis of large amounts of transaction data. With the command center metrics, you can make better decisions to unlock strategic benefits to the sales force. You can navigate directly to the underlying application to take quick corrective action.

Use the Oracle Incentive Compensation Command Center to:

Using Incentive Command Center Dashboards

A typical process flow includes the following steps in Oracle Incentive Compensation (OIC) processing:

  1. Collect, load, and calculate transactions

  2. Review outcome of recent jobs

  3. Review quality of calculated earnings

  4. Process payments

  5. Validate payments

  6. Assess readiness to pay

Use the following dashboards to manage process flows:

Note: You must complete the Incentive Compensation Command Center configuration and setup after the installation and common configurations are completed as described in My Oracle Support Knowledge Document 2495053.1, Installing Oracle Enterprise Command Center Framework, Release 12.2. For additional ECC Overview information, see Overview of Enterprise Command Centers, Oracle E-Business Suite User's Guide.

Searching Enterprise Command Center Dashboards

Use the sidebar to search for and refine (filter) the data on a dashboard. You can select a value or record from the Available Refinements component, or you can use the Search field to find a keyword, a value, or a specific record. When you submit a search, or select an available refinement, the search term or refinement is added to the Selected Refinements list, and all of the dashboard data is refined. You can add multiple refinements and remove any of them at any time. Use Saved Search to create and save your search. You can edit, delete, or refer to this saved search. You can also use data sets to further refine your search.

Use an asterisk (*) or a percent sign (%) to perform a partial keyword or record search that matches any string of zero or more characters. You can also use a question mark (?) to perform a partial search that matches any single character.

Additional Information: For more information about searching for and refining data in enterprise command centers, see Search in Highlights of an Enterprise Command Center, Oracle E-Business Suite User's Guide.

Recent Jobs Dashboard

See Incentive Compensation Command Center Overview.

Incentive compensation is accomplished through a series of jobs. You kick off jobs for collection, for load, for calculation, and for creating paysheets. The Recent Jobs dashboard brings together information from the concurrent manager and from jobs across all phases in a single dashboard.

As a compensation analysts or manager, use the Recent Jobs dashboard to:

You can analyze data using various metrics, charts, graphs, and tables.

Access the Recent Jobs dashboard using the following navigation:

(N): Compensation Manager (responsibility) > Quality Management > Recent Jobs

The following table describes the dashboard:

Recent Jobs Dashboard

the picture is described in the document text

Component Description
Recent Job Alerts (summary bar) The Jobs with Errors metric displays the number of jobs that failed. Click the metric to view details of jobs and programs.
Job Status (tag cloud) This tag cloud displays the job status by number of records.
Program Name (tag cloud) This tag cloud displays the program name by number of records.
Job Analysis (charts) This tab displays the following charts.
  • By Phase:

    Job (Count) by Phase and Job Status (tab): This chart show the number of jobs that completed normally, in error, and with warning for each phase (collect, calculate, and pay).

  • By Job Name (tab):

    Job (Count) by Job Status, Job Name: This stacked bar chart shows the number of jobs that completed normally, in error, or with warning by job name.

  • By Date (tab):

    Job (Count) by Request Date, Job Status By Date: This bar chart displays the number of jobs that completed normally, in error, and with warning by request date.

Recent Job Results (table) This results table displays details of recent jobs such as the job name, the job status, and the job type.
To perform the following actions, click the row-level Actions icon and select an action.
  • Request Log: To review failed jobs, click this link to navigate to the concurrent program log page of Oracle Incentive Compensation.

  • Calculate Log: To view log details, click this link to navigate to the Log page of Oracle Incentive Compensation.

  • Validate Transaction: Click this link to navigate to the Quality by Phase dashboard with filters based on the concurrent program details. If it is a load program, then the filters are based on the API table data. If it is a payrun program, then the filters are payrun related.

Quality by Phase Dashboard

See Incentive Compensation Command Center Overview.

Incentive Compensation processing is sequential. In assessing the completeness and accuracy of calculated earnings, collection must be validated prior to load and load must be validated prior to calculation. In other words, the quality of each phase is based on the success of its prior phases. The Quality by Phase dashboard links together transactional information from all phases of processing (collect, calculate, and pay) into a single dashboard so that quality of the processing can be assessed.

As a compensation analyst or manager, use the Quality by Phase dashboard to:

Lifecycle Phases

To determine how a transaction is processed in Incentive Compensation and to show its status in a single glance, the Incentive Compensation Command Center uses lifecycle phases. In the Available Refinements list, select Interface Processing and then the Lifecycle Status refinement to know the status of transactions.

Lifecycle Phases

the picture is described in the document text

The lifecycle phases include:

  1. Collect

  2. Calculate

  3. Pay

  4. The fourth phase is the single lifecycle status, which is the sum of all the three phases (Collect + Calculate + Pay).

The following examples explain the various statuses of transactions.

Note: Implementers can use the information provided in How Lifecycle Statuses and Phases are Derived, Oracle Incentive Compensation Implementation Guide to understand transaction processing.

You can analyze data using various metrics, charts, graphs, and tables.

Access the Quality by Phase dashboard using the following navigation:

(N): Compensation Manager (responsibility) > Quality Management > Quality by Phase

Quality by Phase Dashboard

the picture is described in the document text

The following table describes the dashboard:

Component Description
Processing Metrics by Value (summary bar) This summary bar provides metrics on the value of commissions, transactions, and paysheets.
  • Total Transaction Value: The sum of the transaction amount from commission lines

  • % of Sales: The total commission as a percentage of the total transaction value

  • Total Commission: The sum of earnings from commission lines

  • Total Paysheet Value: The sum of pay amounts from paysheets

Conversion Metrics by Count (summary bar) This summary bar provides conversion percentages and the number of transactions for key stages of processing.
The conversion metrics are:
  • API Count

  • Headers Count

  • Lines Count

  • Payments Count

Explosion Ratio from Collect to Calculate (summary bar) This summary bar shows the following metrics:
  • Transaction Value Explosion: The ratio of the sum of transaction amounts of commission lines to the sum of transaction amounts of interface transactions.

  • Transaction Count Explosion: The ratio of the number of commission lines to the number of interface transactions.


Several processes, including crediting, rollup, and data population, create additional transactions. For example, you roll up sales representative transactions to their sales management. You can use sales crediting rules to give credit to your overlay specialists. You can also create additional transactions using overlapping plan elements. Therefore, a sale can go towards a commission and also towards a monthly bonus. Use explosion ratio metrics to validate your sales hierarchies and sales credit rules.
Plan Element (tag cloud) This tag cloud shows the plan element names according to the number of commission line records for each plan element.
Transactions (tab) This tab displays the following charts:
  • Commission Line (Count) by Period, Lifecycle Status: This stacked chart shows the lifecycle status of commission lines for a period.

  • Transaction Amount (Sum) by Period, Lifecycle Status: This stacked bar chart shows the transaction amount for each period and the lifecycle status.

Commissions (tab) This tab displays the following charts:
  • Validate by Commissions Calculated: This stacked bar chart shows the maximum commission amount for a period and the lifecycle status.

  • Validate by Max: This bar chart shows the maximum commission rate for a period and the lifecycle status.

Results Tables

The Quality by Phase results tables show information about collecting and calculating transactions. These tables also provide detailed information about payments, paysheets, and payruns. In the Collect tab, the Interface Transaction option shows attributes of a transaction as it enters a specific phase. The Interface Processing option displays processing attributes of the Collect phase and help to understand how a transaction is processed in a phase. This information enables you to validate each phase.

Use links in the following tabs to performs actions:

Paysheet Console Dashboard

See Incentive Compensation Command Center Overview.

The Paysheet Console dashboard provides visibility across payruns and supports a flexible approval process. As a compensation analyst or a finance director responsible for payment processing, you need to review how the paysheet processing is progressing for current periods, and review paysheets to see how many outstanding paysheets are assigned to which analysts. This dashboard provides the ability to see across different payruns. Use the dashboard to review submitted paysheets prior to approval in Oracle Incentive Compensation.

You can analyze data using various metrics, charts, graphs, and tables.

Access the Paysheet Console dashboard using the following navigation:

(N): Compensation Manager (responsibility) > Quality Management > Paysheet Console

Paysheet Console Dashboard

the picture is described in the document text

The following table describes the dashboard:

Component Description
Processing Metrics (summary bar) The following metrics are based on the status of paysheets:
  • Unlocked: The number of unpaid paysheets, where the paysheet status is Unpaid

  • Locked: The number of unpaid paysheets, where the paysheet status is Locked

  • Submitted: The number of submitted paysheets

  • Approved: The number of approved paysheets, where the paysheet status is Approved and the payrun is paid

  • Terminated: The number of terminated sales representatives

Pay Metrics (summary bar) These metrics are based on the sum, average, or maximum of paysheet amounts.
  • Pay Total

  • Earnings

  • Held Amount

  • Adjusted Amount

  • Payment Plan Adjusted

  • Paysheet Average

  • Paysheet Maximum

Payruns (tag cloud) This tag cloud displays the payrun name by the number of records.
Count (chart) This pie chart displays the paysheet distribution percentage per paysheet status. The hover text for each segment on the chart displays the number of paysheets in that paysheet status.
Value (chart) This stacked bar chart displays the sum of paysheet amounts for each payrun, stacked by the phase of the pay lifecycle.
Paysheets Table (results table) This results table displays information such as the paysheet status, the payrun name, the employee number, and the paysheet total.
To perform the following actions, click the row-level Actions icon and select an action:
  • Link to Quality by Phase: Click this link to go to the Quality by Phase dashboard with filters for that sales representative.

  • Link to Paysheet: Click this link to go to the Paysheet Detail page of Incentive Compensation for that sales representative.

Jeopardy by Phase Dashboard

See Incentive Compensation Command Center Overview.

The Jeopardy by Phase dashboard is for finance directors and compensation managers who are typically responsible for ensuring incentives are paid on time. Use this dashboard to assess whether incentives processing is on schedule and to take corrective action if necessary. While the Quality by Phase dashboard focuses on conversion between phases, the Jeopardy by Phase dashboard focuses on readiness to pay. These details help ensure that incentive payments are timely by equipping you to make remedial decisions. The insights include:

You can analyze data using various metrics, charts, graphs, and tables.

Access the Jeopardy by Phase dashboard using the following navigation:

(N): Compensation Manager (responsibility) > Quality Management > Jeopardy by Phase

Jeopardy by Phase Dashboard

the picture is described in the document text

The following table describes the dashboard:

Component Description
Incoming Metrics (summary bar) These metrics summarize incoming earnings that need to be processed for payment.
  • Total Transaction Value: The sum of transaction amounts from transaction records

  • Total Earnings: The sum of earnings amounts from transactions

  • Transaction Count: The number of transaction records with no zero commission amounts

  • Rep Count: The number of reps who have transaction records with no zero commission amounts

Ready-to-Pay Metrics (summary bar) The Payments Paid metric displays the total payments belonging to a paid payrun.
Transaction Type (tag cloud) This tag cloud displays transaction types by the number of records for each type.
Jeopardy Analysis (charts) The following charts help you to investigate which of the phases is responsible for jeopardy:
  • Overall: The state of processing by role across all phases

  • Collect: The collection phase processing by dimensions such as the role, the plan, the period and the lifecycle.

  • Calculate: The calculation phase processing by dimensions such as the role, the plan, the period and the lifecycle.

  • Pay: The pay phase processing by role


The charts in these tabs are based on the following dimensions:
  • Value Processed: This bar chart shows the total transaction amount processed for each dimension such as the role, the plan, the period, and the lifecycle phase for a specific lifecycle.

  • Counts Processed: This bar chart shows the number of commission transactions for each role in a specific lifecycle.

Performance Evaluation Dashboard

See Incentive Compensation Command Center Overview.

The Performance Evaluation dashboard provides sales plan administrators and compensation managers visibility about the compensation attainment and performance trends. The dashboard highlights achievements of sales reps and earnings based on period-to-date, interval-to-date quota, and annual quota. This dashboard also provides details about quota attainment information such as targets, goals, attainment, and attainment to target percent for sales reps at plan elements and eligible products level.

Use the dashboard to:

You can analyze data using various metrics, charts, graphs, and tables.

Access the Performance Evaluation dashboard using the following navigation:

(N): Compensation Manager (responsibility) > Quality Management > Performance Evaluation

Performance Evaluation Dashboard

the picture is described in the document text

The following table describes the dashboard:

Component Description
Performance Summary (tabbed layout) The Performance Summary (tabbed layout) contains the following tabs, each of which contains a summary bar containing the following key metrics:
  • Attainment Metrics (tab): This contains the following key metrics.

    • Period-to-Date Attainment: This metric shows the value of achievements and earnings attained in the period-to-date.

    • Interval-to-Date Attainment: This metric shows the value of achievements and earnings attained in the interval-to-date.

    • Performance Achieved Period-to-Date: This metric shows the value of the performance achieved in the period-to-date.

    • Performance Achieved Interval-to-Date: This metric shows the value of the performance achieved in the interval-to-date.

    • Quota Achieved % Period-to-Date: This metric shows the percentage of the quota achieved in the period-to-date.

    • Amount to Reach Quota Period-to-Date: This metric shows the value of the amount required to reach the quota for the period-to-date.

  • Performance Goal (tab): This contains the following key metrics:

    • Period-to-Date Target Amount: This metric shows the period-to-date value of the target amount.

    • Period-to-Date Fixed Amount: This metric shows the period-to-date value of the fixed amount.

    • Period-to-Date Performance Goal: This metric shows the period-to-date value of the performance goal.

    • Interval-to-Date Target Amount: This metric shows the interval-to-date value of the target amount.

    • Interval-to-Date Fixed Amount: This metric shows the interval-to-date value of the fixed amount.

    • Interval-to-Date Performance Goal: This metric shows the interval-to-date value of the performance goal.

Plan Element (tag cloud) This tag cloud displays the top ten plan element names according to the number of sales representative period quota records for each plan element.
Attainment vs. Quota (tabbed layout):
Period to Date (tab)
The Period to Date tab contains the following charts:
  • Target Achievement Period-to-Date (Sum), Period-to-Date Target Amount (Sum) by Period, Plan Element, Compensation Plan, Role, and Incentive Type Code: This graph shows all target achievements for the period-to-date versus the target amount for the period-to-date.

  • Period-to-Date Attainment (Sum), Period-to-Date Target Amount (Sum) by Period, Plan Element, Compensation Plan, Role, and Incentive Type Code: This graph shows all attainment for the period-to-date versus the target amount for the period-to-date.

Attainment vs. Quota (tabbed layout):
Interval to Date (tab)
The Interval to Date tab contains the Interval-to-Date Attainment (Sum), Interval-to-Date Target Amount (Sum) by Period, Plan Element, Compensation Plan, and Role graph, which shows all the attainment for the interval-to-date and the target amount for the interval-to-date.
Results (tabbed layout) The Results tabbed layout contains the following tabs:
  • Quota (tab): This tab contains the Quota results table. You can sort this table by Quota or Quota Assignment. To view the compensation plans for sales representatives, click the link icon in the Plan Setup column to navigate to the Compensation Plans page.

  • Attainment (tab): This tab contains the Attainment results table, which shows the attainment details for individual sales representatives.

Options (table-level actions)
  • Compare: Select multiple rows to compare data.

  • Export: Use this action to export the search results in a comma-separated values (CSV) file format.

Compensation Plan Visualizer

See Incentive Compensation Command Center Overview.

The Compensation Plan Visualizer offers insight into all the compensation plans in your organization for effective incentive compensation management and dispute resolution.

Use the dashboard to:

Access the Compensation Plan Visualizer dashboard using the following navigation:

(N): Compensation Manager (responsibility) > Quality Management > Compensation Plan Visualizer

Compensation Plan Visualizer

the picture is described in the document text

Using Search Attributes

You can select attributes from the following Available Refinements:

To search for a sales representative with disputed transactions, use the following search sequence:

  1. Select an operating unit.

  2. Select the sales representative.

  3. Select the specific period to focus on the incentive data for that period. You can also select multiple periods to compare compensation details.

Compensation Plan Visualizer Network Diagram

The compensation plan visualizer network diagram displays nodes for a compensation plan. To navigate to the relevant page in Oracle Incentive Compensation, click the More Details indicator icon on a node.

The following table lists the nodes that the Compensation Plan Visualizer displays with the node information and the pages that you can navigate to from the visualizer nodes.

Node Node Information Oracle Incentive Compensation Page
Operating Unit Operating unit name Not applicable
Salesrep Sales representative name Not applicable
Resource Setup Sales rep, username, manager Resource
Plan Setup Compensation plan, payment plan, paygroup Compensation Plans
Compensation Compensation plan, sales rep Commission Statement
Period Period, period start date, period end date Not applicable
Pay Group Paygroup Pay Groups
Payments Sales rep Payment
Compensation Plan Details Compensation plan details Compensation Plans
Transactions Sales rep Transactions
Statements Sales rep Year to Date Summary
Plan Element Plan element name Plan Elements
Product Product name Products
Formula Formula name Formulas
Rate Table Rate table name Rate Tables
Expression Expression name Expressions

Performing Actions from a Compensation Plan Visualizer Node

Compensation Plan Visualizer Node Actions

the picture is described in the document text

Right-click a node to select the following options that are available for a node:

Additional actions include:

Examples of Using the Compensation Plan Visualizer

The following examples explain how you can use the Compensation Plan Visualizer to investigate compensation disputes.

Example 1: Investigate Nonpayment of Commission for a Specific Product

In this example, the sales compensation analyst investigates the nonpayment of sales commission to a sales rep for a specific product.

The steps that the analyst performs are as follows:

  1. Searches for the operating unit that the sales rep belongs to.

  2. Searches for the sales representative and the period in which the sales rep has not been paid commission. The Compensation Plan Visualizer displays the entire compensation plan structure as a network diagram.

  3. On the network diagram, the analyst right-clicks the Transactions node and selects the Highlight Path action. This action traces the transactions to the Plan Setup, Compensation, and Period nodes.

  4. Clicks the indicator icon on the Transactions node to navigate to the Transactions page in Oracle Incentive Compensation.

  5. Reviews transactions for the products that have been processed in the selected period.

  6. For the selected period, looks at the list of product types for which commissions are calculated.

  7. Finds that the product for which the sales rep is not paid the commission has not been processed for the selected period and therefore the commission calculation has missed the scheduled payment date.

  8. Informs the sales representative about the analysis results.

  9. Puts in place a mechanism to ensure that the commission for the specific product is calculated in the next period.

Example 2: Investigate Lower Commission Payment

In this example, the compensation analyst is investigating the payment of lower commission to a sales rep.

The steps that the analyst performs are as follows:

  1. Searches for the sales rep and the period in which the dispute is reported.

  2. Clicks the indicator icon on the Statements node to navigate to the Year to Date Summary page in Oracle Incentive Compensation.

  3. Reviews the compensation plan elements to understand the plan rules and revenue classifications associated with the plan.

  4. Returns to the network diagram and clicks the indicator icon on the Compensation Plan node.

  5. Reviews the earnings rules for the compensation plan.

  6. Reviews the eligible products for which the sales rep has reported the issue.

  7. Reviews the rate table structure associated with the compensation plan to see why the sales rep has not received enough commission.

  8. As part of the investigation, the analyst also reviews:

    • Rate tiers

    • Rate dimensions

    • Formulas

    • Expressions