Search Results cn_not_trx_all




Overview
Explore in AI Chat

Overview

The CN_NOT_TRX_ALL table is a core data object within the Oracle E-Business Suite (EBS) Incentive Compensation module (CN). Its primary function is to govern the selection of Accounts Receivable (AR) transaction records for processing by the Compensation Engine's Collection process. This table acts as a control mechanism, determining which specific revenue transactions from the AR module are eligible to be collected and subsequently considered for calculating commissions and incentives. As a multi-org enabled table with the '_ALL' suffix, it stores data for all operating units, making it integral to enterprise-wide incentive management.

Key Information Stored

While the full column list is not detailed in the provided metadata, the documented foreign key relationships reveal several critical columns that define the table's structure and purpose. The primary key column, NOT_TRX_ID, uniquely identifies each record. The SOURCE_TRX_ID column holds the foreign key to the AR transaction (RA_CUSTOMER_TRX_ALL) that is being evaluated for collection. The NOTIFICATION_RUN_ID column links to the CN_PROCESS_AUDITS_ALL table, associating each record with a specific execution instance of the notification or collection process. This structure allows the system to maintain an auditable log of which transactions were selected for a given processing run.

Common Use Cases and Queries

The primary use case for CN_NOT_TRX_ALL is during the execution of the Collection process, where it is populated with identifiers for AR transactions that meet the defined collection criteria. Administrators may query this table to audit or troubleshoot the collection process. A common reporting need is to verify which transactions were processed in a specific run. A sample query to achieve this would join CN_NOT_TRX_ALL with the AR transactions table:

  • SELECT cna.not_trx_id, cna.notification_run_id, rct.trx_number, rct.trx_date FROM cn_not_trx_all cna, ra_customer_trx_all rct WHERE cna.source_trx_id = rct.customer_trx_id AND cna.notification_run_id = &RUN_ID;

This table is also essential for reconciling the data flow between the AR and Incentive Compensation modules, ensuring that all billable revenue is correctly considered for commission calculations.

Related Objects

CN_NOT_TRX_ALL maintains documented relationships with several key tables, as per the provided metadata:

  • CN_TRX_ALL: Linked via the primary key column CN_NOT_TRX_ALL.NOT_TRX_ID. This is a fundamental relationship, likely indicating that a record in CN_NOT_TRX_ALL spawns or is linked to a corresponding compensation transaction record.
  • RA_CUSTOMER_TRX_ALL: Linked via the foreign key column CN_NOT_TRX_ALL.SOURCE_TRX_ID to the source AR transaction. This is the critical link that identifies the revenue event being collected.
  • CN_PROCESS_AUDITS_ALL: Linked via the foreign key column CN_NOT_TRX_ALL.NOTIFICATION_RUN_ID. This ties the transaction selection to a specific audit trail of the collection process run.

These relationships position CN_NOT_TRX_ALL as a central hub in the data flow from source revenue transactions (AR) to calculated compensation transactions (CN).