Search Results cn_worksheet_bonuses_all




Overview
Explore in AI Chat

Overview

The CN_WORKSHEET_BONUSES_ALL table is a core transactional data store within the Oracle E-Business Suite (EBS) Incentive Compensation (CN) module. It is designed to persist the detailed records of all bonus payments awarded to sales representatives during the payment processing cycle. This table serves as the system of record for bonus transactions, capturing the final, calculated bonus amounts that are generated from the compensation plans and rules. Its role is critical for payment generation, audit trails, and historical reporting on incentive earnings. As an "ALL" table, it is partitioned by the operating unit, supporting the multi-org architecture of Oracle EBS, which allows data to be segregated by business entity.

Key Information Stored

The table's primary key, CN_WORKSHEET_BONUSES_PK, is a composite key based on the SALESREP_ID and PAYRUN_ID columns, ensuring a unique record for each sales representative within a specific payment run. While the full column list is not detailed in the provided metadata, the foreign key relationships and context indicate it must store at least the following critical data points: the identifier for the salesperson (SALESREP_ID), the identifier for the specific payment processing batch (PAYRUN_ID), and the calculated bonus amount. It likely also contains columns for the bonus plan or rule identifier, the transaction currency, the earnings period, and timestamps for creation and last update.

Common Use Cases and Queries

This table is central to operational and analytical processes. A primary use case is the verification and reconciliation of payments before final disbursement. Compensation administrators may query this table to review all bonuses generated in a payrun. For reporting, it is joined to dimension tables to produce detailed bonus statements and aggregate payout summaries. A common SQL pattern involves joining to the salesreps and payruns tables to create a readable report:

  • SELECT s.full_name, p.name payrun, wb.bonus_amount FROM cn_worksheet_bonuses_all wb, cn_salesreps_api_all s, cn_payruns_all p WHERE wb.salesrep_id = s.salesrep_id AND wb.payrun_id = p.payrun_id AND p.payrun_id = :p_payrun_id;

Another critical use case is auditing, where historical queries against this table are used to investigate payment discrepancies or analyze bonus trends over time.

Related Objects

The CN_WORKSHEET_BONUSES_ALL table has defined foreign key relationships with two key master tables in the Incentive Compensation schema, as documented in the metadata:

  • CN_PAYRUNS_ALL: Joined via the PAYRUN_ID column. This relationship ties each bonus record to a specific, controlled payment processing batch, ensuring transactional integrity.
  • CN_SALESREPS_API_ALL: Joined via the SALESREP_ID column. This relationship links the bonus payment to the specific sales representative (resource) who earned it, connecting the transactional data to the master list of compensated individuals.

These relationships are fundamental for any query that requires descriptive information about the payrun (e.g., status, period) or the sales representative (e.g., name, employee number). The table is also a likely source for various compensation summary views and interfaces to downstream financial systems for general ledger posting.