Search Results cn_trx_lines_all




Overview
Explore in AI Chat

Overview

The CN_TRX_LINES_ALL table is a core transactional entity within the Oracle E-Business Suite Incentive Compensation (CN) module. It functions as the central repository for detailed transaction line information captured during the Accounts Receivable (AR) data collection process. This process extracts sales and revenue data from source systems, such as Order Management and Receivables, to serve as the foundation for calculating commissions and incentives. The table's role is to store the granular, line-level details of these transactions, enabling the system to accurately attribute revenue, apply compensation rules, and generate commission calculations for sales personnel. Its "ALL" suffix indicates it is a multi-organization enabled table, storing data across all operating units.

Key Information Stored

While the provided metadata does not list specific columns beyond the primary key, the table's purpose dictates the nature of its data. Key information typically stored includes the unique transaction line identifier (TRX_LINE_ID, the primary key) and the foreign key to the header table (TRX_ID). Other critical columns often encompass product or service identifiers, extended amounts, quantities, unit selling prices, revenue recognition dates, and line-type classifications. The table also holds contextual attributes linking the line item to the salesperson, customer, and the original source transaction from systems like Order Management, which are essential for accurate rule processing and audit trails.

Common Use Cases and Queries

The primary use case for CN_TRX_LINES_ALL is the processing and reporting of commissionable transactions. Data from this table is fed into the compensation engine where it is evaluated against defined compensation plans and rules. Common queries involve extracting transaction details for reconciliation, troubleshooting calculation errors, and generating detailed commission statements. A typical reporting pattern joins this table to its header and related sales credit tables.

  • Sample Query for Transaction Analysis: SELECT ctl.trx_line_id, ctl.extended_amount, ct.trx_number FROM cn_trx_lines_all ctl, cn_trx_all ct WHERE ctl.trx_id = ct.trx_id AND ct.trx_date BETWEEN :p_start_date AND :p_end_date;
  • Data Validation: Queries are frequently executed to verify data collection completeness by comparing line counts and amounts between source systems and this staging table.

Related Objects

CN_TRX_LINES_ALL is a central node in the Incentive Compensation data model, with defined relationships to several key tables.

  • Parent Table (Foreign Key Reference): The table references CN_TRX_ALL via the column CN_TRX_LINES_ALL.TRX_ID. This links each transaction line to its corresponding header record, which contains overall transaction information.
  • Child Tables (Referenced by Foreign Keys): Two critical tables reference CN_TRX_LINES_ALL, demonstrating its downstream importance:
    • CN_COMM_LINES_API_ALL links via CN_COMM_LINES_API_ALL.TRX_LINE_ID. This table holds the calculated commission results generated from the transaction lines.
    • CN_TRX_SALES_LINES_ALL links via CN_TRX_SALES_LINES_ALL.TRX_LINE_ID. This table manages the assignment and splitting of sales credits from the original transaction line to multiple salespeople.