Search Results cn_payment_api_all




Overview
Explore in AI Chat

Overview

The CN_PAYMENT_API_ALL table is a core data object within the Oracle E-Business Suite Incentive Compensation module (CN). It serves as the primary repository for the processed output of the payment engine. Following the calculation of commissions and incentives for sales representatives, the payment process populates this table with the finalized payment records, ready for integration with external payroll systems or for generating payment reports. Its role is critical in the commission settlement lifecycle, acting as the system of record for all calculated payment amounts before they are disbursed. The "_ALL" suffix indicates it is a multi-organization enabled table, storing data partitioned by operating unit.

Key Information Stored

The table's structure is designed to link payment details to key entities in the compensation process. The primary key, PAYMENT_API_ID, uniquely identifies each payment record. Essential foreign key columns establish critical relationships: PAYRUN_ID links to the CN_PAYRUNS_ALL table to associate records with a specific payment batch or run; PERIOD_ID references CN_PERIOD_STATUSES_ALL to tie payments to the accounting or compensation period; and SALESREP_ID connects to CN_SALESREPS_API_ALL, identifying the recipient sales representative. While the provided metadata does not list all columns, the table typically stores calculated payment amounts, earnings types, payment statuses, and dates, forming a complete audit trail for each payment obligation.

Common Use Cases and Queries

The primary use case is the extraction of payment data for payroll interfacing and management reporting. Compensation administrators query this table to verify payment totals, troubleshoot calculation discrepancies, and generate payment advices. A common query pattern involves joining to related tables to produce a detailed payment register. For example:

  • SELECT cpa.*, csr.name, cps.name period_name FROM cn_payment_api_all cpa, cn_salesreps_api_all csr, cn_period_statuses_all cps WHERE cpa.salesrep_id = csr.salesrep_id AND cpa.period_id = cps.period_id AND cpa.payrun_id = :p_payrun_id;

This table is also central to reconciliation processes, ensuring the sum of individual payments aligns with the payrun totals and the original calculated commissions.

Related Objects

As indicated by its foreign keys, CN_PAYMENT_API_ALL has direct dependencies on several key tables. CN_PAYRUNS_ALL defines the payment batch context. CN_PERIOD_STATUSES_ALL provides the period controlling the payment. CN_SALESREPS_API_ALL holds the master information for the compensated sales representative. This table is a terminal point in the calculation pipeline; it is likely referenced by various payment summary views and is the primary source for the standard Oracle Incentive Compensation payment reports and outbound interfaces to Oracle Payroll or third-party systems.