Search Results cn_imp_headers




Overview
Explore in AI Chat

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

Overview

CN_IMP_HEADERS is a transactional header table within the Oracle Incentive Compensation (CN) module of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. The table stores control information for user-driven data imports, serving as the master record that defines how an external file is parsed, mapped, and staged before its contents are consumed by Incentive Compensation processing. Each row represents a single import definition or import run, capturing the source file, the delimiter conventions, the target import map, and the current processing state. From a Data Vault modeling perspective, the metadata's heuristic classification is standalone; that is, CN_IMP_HEADERS behaves as an independent hub-like entity with no documented parent foreign keys other than the operational SECURITY_GROUP_ID reference to FND_SECURITY_GROUPS. It anchors its own business identity and is referenced by dependent staging and detail structures rather than acting as a link or satellite.

Key Information Stored

The table is documented with 40 columns in the ETRM 12.2.2 physical schema. The most significant are:

Common Use Cases and Queries

Typical uses include diagnosing failed or stalled imports, auditing who created or changed an import definition, and reporting on volume and error rates per import run.

Listing active imports by status:

SELECT imp_header_id, name, import_type_code, status_code,
       processed_row, failed_row
FROM   cn.cn_imp_headers
WHERE  status_code = :p_status
ORDER  BY creation_date DESC;

Identifying imports mapped to a given source file or mapping:

SELECT h.imp_header_id, h.name, h.user_filename, h.imp_map_id
FROM   cn.cn_imp_headers h
WHERE  h.imp_map_id = :p_map_id;

Resolving the owning security group, using the documented foreign key:

SELECT h.imp_header_id, h.name, g.security_group_id
FROM   cn.cn_imp_headers h
JOIN   fnd_security_groups g
  ON   g.security_group_id = h.security_group_id;

Reporting on recent audit activity leverages the WHO columns and the DFF attributes for custom categorization.

Related Objects

  • FND_SECURITY_GROUPS — referenced by CN_IMP_HEADERS.SECURITY_GROUP_ID; the sole documented foreign key relationship.
  • CN_IMP_MAPPINGS / import map definitions — the column-mapping target identified by IMP_MAP_ID.
  • CN_IMP_DETAILS / staging structures — detail rows associated with each header through IMP_HEADER_ID.
  • Import loader and concurrent programs in the CN module — consume the control attributes (delimiters, headings flag, operation) defined on the header.
  • Standard WHO/audit views and the CN module inquiry forms — surface header status and progress to end users.