Search Results cn_salesreps_api_pk

Overview

The CN_SALESREPS_API_ALL table is a core data object within the Oracle E-Business Suite (EBS) Incentive Compensation (CN) module. It serves as a central repository for sales representative information that is integrated via the module's public APIs. While the official ETRM documentation notes its status as "Not currently used," its extensive foreign key relationships with critical transactional tables confirm its underlying architectural role. The table is designed to support multi-organization access structures, as indicated by the '_ALL' suffix, allowing data to be partitioned by Operating Unit. Its primary function is to maintain a unique identifier for each sales representative record processed through the compensation system's integration layer.

Key Information Stored

The primary column of significance in this table is the SALESREP_API_ID. This column constitutes the table's primary key (CN_SALESREPS_API_PK) and acts as the unique identifier for API-integrated sales representative records. While the provided metadata does not list other specific columns, tables of this nature in the CN schema typically store identifiers that link to the HR and CRM resources, such as internal resource IDs or party IDs, along with timestamps for creation and last update, and the operating unit context. The SALESREP_API_ID is the critical piece of data referenced throughout the compensation transaction lifecycle.

Common Use Cases and Queries

The primary use case for this table is tracing and auditing compensation transactions back to their originating sales representative record from an external system. Common queries involve joining this table to major transactional tables to retrieve comprehensive payout details or to validate data flows. A typical reporting query would identify all commission lines for a specific sales representative by joining on the SALESREP_API_ID. For example:

• SELECT cl.*, sra.salesrep_api_id FROM cn_commission_lines_all cl JOIN cn_salesreps_api_all sra ON cl.credited_salesrep_id = sra.salesrep_api_id WHERE sra.salesrep_api_id = <value>;

Another critical use is in data cleanup or reconciliation processes, where analysts verify the existence of parent sales representative records for orphaned transaction lines in the CN_COMM_LINES_API_ALL or CN_PAYMENT_API_ALL tables.

Related Objects

The CN_SALESREPS_API_ALL table has defined foreign key relationships with several key transactional tables in the Incentive Compensation module, as documented in the ETRM metadata. These relationships are fundamental to the data integrity of the compensation processing engine.

• CN_COMMISSION_LINES_ALL: References via CN_COMMISSION_LINES_ALL.CREDITED_SALESREP_ID.
• CN_COMM_LINES_API_ALL: References via CN_COMM_LINES_API_ALL.SALESREP_ID.
• CN_PAYMENT_API_ALL: References via CN_PAYMENT_API_ALL.SALESREP_ID.
• CN_PROCESS_BATCHES_ALL: References via CN_PROCESS_BATCHES_ALL.SALESREP_ID.
• CN_WORKSHEET_BONUSES_ALL: References via CN_WORKSHEET_BONUSES_ALL.SALESREP_ID.

These relationships demonstrate that the SALESREP_API_ID is a key foreign key in tables managing commission calculations, payment processing, batch operations, and bonus worksheets.