Search Results process_batch_id

Overview

The CN_PROCESS_BATCHES_ALL table is a core data object within the Oracle E-Business Suite Incentive Compensation (CN) module. It serves as the central repository for tracking process batches, which are fundamental units of work in the compensation calculation engine. Each batch represents a discrete execution of the calculation process for a specific salesperson (or sales team) and a specific compensation period. The table's role is critical for managing the lifecycle of calculations, enabling audit trails, supporting reprocessing, and ensuring data integrity by linking calculation runs to their associated periods and sales representatives.

Key Information Stored

The table's structure is defined by its primary and unique keys, which highlight the most critical data points. The primary identifier is the PROCESS_BATCH_ID. The table enforces uniqueness through two composite keys: one on the combination of LOGICAL_BATCH_ID and SRP_PERIOD_ID, and another on LOGICAL_BATCH_ID, SALESREP_ID, and PERIOD_ID. This design indicates that a logical batch can contain multiple process batches for different sales representatives or periods. The essential foreign key columns are SALESREP_ID (linking to CN_SALESREPS_API_ALL), PERIOD_ID (linking to CN_PERIOD_STATUSES_ALL), and SRP_PERIOD_ID (linking to CN_SRP_PERIODS_ALL), establishing the core contextual relationships for any calculation run.

Common Use Cases and Queries

This table is primarily queried for process monitoring, troubleshooting, and historical reporting of compensation calculations. Administrators can track the status and history of calculation submissions. A common query pattern involves joining to related dimension tables to produce a readable audit report. For example, to list all process batches for a specific sales representative in a recent period, one might use a SQL pattern such as:

• SELECT pb.process_batch_id, pb.logical_batch_id, s.name salesrep_name, ps.name period_name FROM cn_process_batches_all pb, cn_salesreps_api_all s, cn_period_statuses_all ps WHERE pb.salesrep_id = s.salesrep_id AND pb.period_id = ps.period_id AND s.salesrep_id = :rep_id ORDER BY pb.process_batch_id DESC;

Another critical use case is identifying all process batches belonging to a specific logical batch for a consolidated view of a calculation job's components.

Related Objects

The CN_PROCESS_BATCHES_ALL table is integrally connected to other key Incentive Compensation tables via documented foreign key relationships. These relationships are essential for accurate joins in reporting and application logic.

• CN_SRP_PERIODS_ALL: Joined via CN_PROCESS_BATCHES_ALL.SRP_PERIOD_ID. This links the batch to the specific sales compensation plan period.
• CN_SALESREPS_API_ALL: Joined via CN_PROCESS_BATCHES_ALL.SALESREP_ID. This links the batch to the sales representative whose compensation is being calculated.
• CN_PERIOD_STATUSES_ALL: Joined via CN_PROCESS_BATCHES_ALL.PERIOD_ID. This links the batch to the general compensation period, which governs the calculation calendar and status.

These relationships ensure that every process batch is correctly scoped to a rep, a plan period, and a calendar period, forming the foundational context for all calculated results.