Search Results cn_commission_headers_s




Overview
Explore in AI Chat

Overview

CN_AGGRT_TRX_PKG is a PL/SQL package body owned by the APPS schema within the Oracle E-Business Suite Trade Management (formerly Oracle Incentive Compensation / ETRM) module. It is classified as an OTHER API rather than a formal public interface, meaning it is intended primarily for internal use by the application rather than as a documented extension point. Its name, "aggregate transactions," reflects its core responsibility: consolidating or rolling up commission transaction records so that downstream calculation, submission, and batch processing logic can operate on summarized rather than raw detail. In the 12.1.1 and 12.2.2 releases, this package participates in the incentive compensation processing pipeline, working alongside the calculation submission infrastructure to prepare transaction data for processing cycles. The status of the package body is VALID, and the ETRM metadata confirms that it is not referenced by any other database object, indicating it sits near the top of its internal call hierarchy rather than serving as a shared utility.

Key Procedures and Functions

The ETRM documentation identifies a single documented program unit within the package body:

  • AGGREGATE_TRX — The sole documented routine. Its name indicates that it aggregates transaction records, presumably gathering and consolidating commission transaction rows associated with a given calculation or submission context. As the metadata does not provide a parameter list, no signature is asserted here. Functionally, it is the entry point through which callers request transaction aggregation, and it likely drives the reads and writes involving the commission header and batch tables described below.

No additional procedures or functions are documented. Any behavior beyond AGGREGATE_TRX cannot be confirmed from the ETRM metadata and is therefore not described.

Tables Accessed

The package body references the following tables through APPS synonyms, each serving a distinct role in the aggregation workflow:

  • CN_COMMISSION_HEADERS_ALL — The base table holding commission header records. This is the primary source of commission definitions that the aggregation logic reads to determine which transactions belong to which header.
  • CN_COMMISSION_HEADERS_S — The sequence-backed or shadow table associated with commission headers, used for identifier generation and consistent header key handling during processing. This table is directly relevant to the searched term "cn_commission_headers_s."
  • CN_CALC_SUBMISSION_BATCHES_ALL — Stores calculation submission batch definitions. The package reads or updates this table to associate aggregated transactions with the correct submission batch.
  • CN_PROCESS_BATCHES_ALL — Stores process batch information used by concurrent processing. Aggregation results are tied to process batches so that subsequent calculation stages can retrieve them.
  • PLITBLM — A standard Oracle-supplied PL/SQL table type used for in-memory collections. Its presence indicates the package buffers rows in PL/SQL memory during aggregation before writing or returning them, a common pattern for performance-sensitive bulk operations.

Usage Notes

Given the classification OTHER and the absence of referencing objects, CN_AGGRT_TRX_PKG is invoked internally, typically from concurrent programs or from higher-level commission calculation drivers rather than directly from EBS forms. The reference to CN_CALC_SUBMISSION_BATCHES_ALL and CN_PROCESS_BATCHES_ALL strongly suggests it runs during the calculation submission and batch processing stages of the incentive compensation cycle. In practice, AGGREGATE_TRX would be called after transactions have been collected but before commission is calculated, ensuring that the calculation engine evaluates summarized data. Because the package is not referenced by other database objects, customizations should not assume a stable public contract; any integration touching it should be validated against the specific 12.1.1 or 12.2.2 patch level in use.