Results for “processed_period_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CN_TRX_SALES_LINES_ALL is a transaction table within the Oracle Incentive Compensation (CN) module of Oracle E-Business Suite, residing in the CN schema. It stores the sales-line level detail for transactions that are collected from Oracle Receivables, Order Management, and other feeder systems during the AR data collection process. Each row represents an individual sales line eligible for incentive compensation processing, including the revenue and non-revenue amounts, the salesperson attribution, and the classification status applied by the compensation engine.

The table forms the core fact source for commission calculation. Rows are delivered into this table by collection runs, subsequently classified into revenue classes, and then consumed by the commission line generation process. From a Data Vault modeling perspective, the metadata's heuristic classification is satellite-leaning, suggesting this object behaves primarily as a descriptive satellite attached to transaction and transaction-line hubs rather than as a pure hub or link.

Key Information Stored

The surrogate primary key is TRX_SALES_LINE_ID, enforced by the CN_TRX_SALES_LINES_PK constraint. A unique index, CN_TRX_SALES_LINES_U1, exists on the composite of TRX_SALES_LINE_ID and ORG_ID, which serves as the multi-org business-key candidate. The most significant columns include:

• TRX_ID and TRX_LINE_ID — foreign keys to CN_TRX_ALL and CN_TRX_LINES_ALL respectively, anchoring the sales line to its parent transaction and transaction line.
• ORG_ID — the operating unit, central to multi-org security and the unique index.
• COLLECTION_RUN_ID and TRANSFER_RUN_ID — identify the data collection and transfer processes that populated the row.
• SALES_LINE_STATUS, CLASSIFICATION_STATUS, and CLASSIFICATION_RUN_ID — track the lifecycle of the line through classification.
• SALESREP_ID, ORIG_LINE_SALESREP_ID, and SOURCE_PARENT_LINE_SALESREP_ID — attribute the line to the responsible salesperson, including original and parent-line attribution.
• AMOUNT and QUANTITY — the monetary and volumetric basis for crediting.
• REVENUE_CLASS_ID — foreign key to CN_REVENUE_CLASSES_ALL, driving classification and crediting rules.
• REVENUE_AMOUNT_SPLIT, NON_REVENUE_AMOUNT_SPLIT, and REV_NON_REV_FLAG — revenue/non-revenue apportionment.
• ADJUSTMENT_FLAG, ADJUSTMENT_LINE_ID, ADJUSTMENT_HEADER_ID, and ADJUSTMENT_TRX_SALES_LINE_ID — link credits or adjustments to their originating compensation line.
• ATTRIBUTE1–15 and ATTRIBUTE_CATEGORY — the standard EBS DFF extension columns.
• Who-columns including CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and SECURITY_GROUP_ID.

Common Use Cases and Queries

Typical usage centers on reconciling collected sales lines, auditing classification results, and tracing the lineage from a credit to its source transaction. A common pattern joins to the parent transaction and line tables:

• Reconciliation of collection runs: count and sum AMOUNT by COLLECTION_RUN_ID and SALES_LINE_STATUS within a period.
• Salesperson credit analysis: aggregate AMOUNT and QUANTITY grouped by SALESREP_ID, filtered by REVENUE_CLASS_ID.
• Adjustment tracing: join ADJUSTMENT_TRX_SALES_LINE_ID back to TRX_SALES_LINE_ID to view the original and adjusting lines side by side.
• Commission-line drill-down: join CN_COMMISSION_LINES_ALL on TRX_SALES_LINE_ID to see which lines were consumed for a given calculation.

A representative query joining to the parent transaction:

SELECT sl.TRX_SALES_LINE_ID, sl.SALESREP_ID, sl.AMOUNT, sl.QUANTITY, t.TRX_NUMBER
FROM   CN_TRX_SALES_LINES_ALL sl,
       CN_TRX_ALL t
WHERE  sl.TRX_ID = t.TRX_ID
AND    sl.ORG_ID = :p_org_id
AND    sl.SALES_LINE_STATUS = 'PROCESSED';

Related Objects

The following objects are the most significant collaborators:

• CN_TRX_ALL — parent transaction header, joined on TRX_ID.
• CN_TRX_LINES_ALL — parent transaction line, joined on TRX_LINE_ID.
• CN_REVENUE_CLASSES_ALL — revenue classification rules, joined on REVENUE_CLASS_ID.
• CN_COMM_LINES_API_ALL — commission line interface, referencing TRX_SALES_LINE_ID.
• CN_COMMISSION_LINES_ALL — generated commission lines, referencing TRX_SALES_LINE_ID.
• FND_SECURITY_GROUPS — multi-org security, joined on SECURITY_GROUP_ID.
• IGI_DOS_TRX_SOURCES — external transaction source, joined on SOURCE_TRX_ID.