Search Results cn_column_maps_all




Overview
Explore in AI Chat

Overview

The CN_COLUMN_MAPS_ALL table is a core data object within the Oracle E-Business Suite Incentive Compensation (CN) module. It functions as the central repository for defining column-level mappings during the data import and transformation processes, specifically for Accounts Receivable (AR) column mappings. Its primary role is to establish and maintain the logical relationships between source data columns and their corresponding destination columns within the Incentive Compensation schema. This mapping is essential for accurately translating and loading transactional data, such as invoices and receipts from AR, into the CN module for subsequent calculation and crediting of sales commissions.

Key Information Stored

The table stores metadata that defines each column mapping relationship. The primary identifier is the COLUMN_MAP_ID, which is part of the primary key alongside ORG_ID to support multi-organization architecture. The core mapping is defined by the SOURCE_COLUMN_ID and DESTINATION_COLUMN_ID columns, which are foreign keys to the CN_OBJECTS_ALL table, storing references to the actual column objects. These two columns together form a unique key (CN_COLUMN_MAPS_UK1). The TABLE_MAP_ID links the column mapping to its parent table mapping defined in CN_TABLE_MAPS_ALL. An optional DRIVING_COLUMN_ID, also a foreign key to CN_OBJECTS_ALL, can be used to specify a column that controls the mapping logic.

Common Use Cases and Queries

This table is primarily accessed during the configuration and troubleshooting of data import maps. Common scenarios include auditing existing mapping setups and diagnosing data load failures where source data is not populating the expected destination columns. A typical query would join CN_COLUMN_MAPS_ALL with CN_OBJECTS_ALL to resolve the internal object IDs to readable column names, and with CN_TABLE_MAPS_ALL for context.

  • Sample Query to List Column Mappings:
    SELECT cmap.COLUMN_MAP_ID,
    src_obj.NAME SOURCE_COLUMN,
    dest_obj.NAME DEST_COLUMN,
    tmap.MAP_NAME
    FROM CN_COLUMN_MAPS_ALL cmap,
    CN_OBJECTS_ALL src_obj,
    CN_OBJECTS_ALL dest_obj,
    CN_TABLE_MAPS_ALL tmap
    WHERE cmap.SOURCE_COLUMN_ID = src_obj.OBJECT_ID
    AND cmap.DESTINATION_COLUMN_ID = dest_obj.OBJECT_ID
    AND cmap.TABLE_MAP_ID = tmap.TABLE_MAP_ID
    AND cmap.ORG_ID = src_obj.ORG_ID
    AND cmap.ORG_ID = dest_obj.ORG_ID;

Related Objects

CN_COLUMN_MAPS_ALL has integral relationships with several other key CN tables. Its definition is governed by the parent CN_TABLE_MAPS_ALL table via the TABLE_MAP_ID foreign key. It relies extensively on CN_OBJECTS_ALL to resolve the identities of the source, destination, and driving columns through multiple foreign key relationships. As a critical component of the mapping framework, it is referenced by the data import engine and is foundational to processes that populate staging and interface tables within the Incentive Compensation module.