Results for “transfer_run_id”

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

Overview

CN_TRX_LINES_ALL is a core transactional table in the Oracle Incentive Compensation (CN) module of Oracle E-Business Suite, owned by the CN schema. It stores the transaction line records that are picked up during the Accounts Receivable data collection process and subsequently consumed by Incentive Compensation for crediting, commission calculation, and sales performance analysis. Each row represents an individual line of a source transaction — typically an AR invoice line, a sales order line, or a similar revenue-generating event — imported into the CN staging and processing framework.

Based on its foreign key topology, the ETRM metadata suggests a hub-leaning Data Vault classification. The table anchors a stable, unique business entity (the transaction line, keyed by TRX_LINE_ID) referenced by numerous downstream satellite and link tables across tax, AR, and sales domains, making it a natural hub candidate in a vaulted model.

Key Information Stored

The table contains 58 documented columns. The most significant include:

• TRX_LINE_ID — surrogate primary key (CN_TRX_LINES_PK). It also participates in unique index CN_TRX_LINES_U1 along with ORG_ID, which serves as the effective business-key candidate.
• TRX_ID — foreign key to CN_TRX_ALL, linking the line to its parent transaction header.
• ORG_ID — the operating unit, part of the composite unique key and essential for multi-org security.
• SOURCE_TRX_LINE_ID / SOURCE_TRX_ID / SOURCE_ORIG_TRX_NUMBER — identify the originating document in the source system, enabling traceability back to AR or order management.
• PRODUCT_ID / PRODUCT_CODE / PRODUCT_LINE / PRODUCT_CATEGORY_ID — product attributes used for crediting rules and product-based incentive assignment.
• QUANTITY, UNIT_SELLING_PRICE, EXTENDED_AMOUNT, REVENUE_AMOUNT — the financial and volumetric measures that drive commission calculations.
• COLLECTION_RUN_ID, COLLECTED_FLAG, NEGATED_FLAG, ADJUSTED_FLAG, ADJ_COLLECTION_RUN_ID, ADJ_BATCH_ID — control flags and run identifiers governing data collection, negation, and adjustment processing.
• SECURITY_GROUP_ID — enforces row-level access control in the CN security model.
• INVENTORY_ID — references FA_INV_INTERFACE, relevant for inventory-linked transactions.
• ATTRIBUTE1–ATTRIBUTE15, ATTRIBUTE_CATEGORY — the standard flexible descriptive columns for extensibility.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Typical reporting scenarios include identifying unreleased or uncollected transaction lines, reconciling collected revenue against source AR documents, and diagnosing crediting failures. A common pattern filters on collection and negation flags:

• SELECT TXL.TRX_LINE_ID, TXL.EXTENDED_AMOUNT, TXL.COLLECTED_FLAG FROM CN_TRX_LINES_ALL TXL WHERE TXL.ORG_ID = :p_org AND TXL.NEGATED_FLAG = 'N';
• Joining to CN_TRX_ALL on TRX_ID to report by invoice or transaction header.
• Joining to CN_TRX_SALES_LINES_ALL on TRX_LINE_ID to analyze sales credit allocations.
• Grouping by PRODUCT_CATEGORY_ID and COLLECTION_RUN_ID to audit a specific collection cycle.
• Correlating SOURCE_ORIG_TRX_NUMBER to the corresponding AR transaction for cross-module reconciliation.

Related Objects

The table participates in a dense relationship network. The most significant related objects are:

• CN_TRX_ALL — parent transaction header (join on TRX_ID).
• CN_TRX_SALES_LINES_ALL and CN_COMM_LINES_API_ALL — child tables keyed by TRX_LINE_ID, carrying sales credit and commission line API data.
• ZX_LINES and related E-Business Tax tables (ZX_TRX_TAX_LINK_GT, ZX_TRANSACTION_LINES_GT) — tax detail lines referencing the transaction line.
• AR_TRX_DIST_TMP_GT, AR_TRX_DIST_GT, AR_INV_API_LINES_GT, and AR_TRX_LINES_GT — AR distribution and API staging structures that depend on this table.
• OKL_TAX_TRX_DETAILS and OKL_TAX_SOURCES — lease tax detail tables.
• FND_DM_PRODUCTS, FA_INV_INTERFACE, and FND_SECURITY_GROUPS — referenced master/control tables via PRODUCT_ID, INVENTORY_ID, and SECURITY_GROUP_ID respectively.
• JG_ZZ_VAT_TRX_DETAILS and JA_CN_CFS_ACTIVITIES_ALL — regional tax and statutory reporting tables.

Because of this broad downstream dependency, changes to CN_TRX_LINES_ALL records propagate into tax, distribution, and commission processing, so purge and adjustment operations must be planned carefully.