Search Results cn_sca_headers_interface_all




Overview
Explore in AI Chat

Overview

CN_SCA_HEADERS_INTERFACE_ALL is a transactional interface (staging) table in the Oracle EBS Incentive Compensation (CN) module. As its description states, it holds the transactions that need to be processed by the Sales Credit Engine. In the standard integration flow, source transactions — such as order lines, invoices, or other creditable events — are staged into this interface table before the Sales Credit Engine evaluates applicable credit rules, allocates sales credit to salespeople, and posts the results to the Incentive Compensation transactional tables. The table is org-striped (it carries ORG_ID and a SECURITY_GROUP_ID foreign key to FND_SECURITY_GROUPS), and it participates in Multi-Org and Function Security access control patterns.

From a Data Vault modeling perspective, the mined metadata suggests a standalone classification — the table does not exhibit the dense hub, link, and satellite foreign-key structure typical of a normalized model. It behaves most like a staging or transient interface entity, with its own surrogate key and descriptive/attribute payload, before the data is consumed and transformed by the Sales Credit Engine.

Key Information Stored

The table spans 118 documented columns, the majority of which are generic ATTRIBUTE1 … ATTRIBUTE100 placeholders used to carry source-specific context through the credit engine. The columns of genuine functional and diagnostic value are:

The two unique indexes — CN_SCA_HEADERS_INTERFACE_U1 (SCA_HEADERS_INTERFACE_ID, ORG_ID) and U2 (SOURCE_TYPE, SOURCE_ID, SOURCE_LINE_ID) — define the surrogate and natural/business uniqueness respectively and are the primary targets for deduplication and reconciliation queries.

Common Use Cases and Queries

Typical use cases include monitoring the interface queue for unprocessed records, diagnosing rejected or stalled transactions, and reconciling source document volumes against Sales Credit Engine output.

  • Count outstanding work by status: SELECT PROCESS_STATUS, COUNT(*) FROM CN.CN_SCA_HEADERS_INTERFACE_ALL WHERE ORG_ID = :org GROUP BY PROCESS_STATUS;
  • Locate a specific source transaction: SELECT * FROM CN.CN_SCA_HEADERS_INTERFACE_ALL WHERE SOURCE_TYPE = :type AND SOURCE_ID = :id AND SOURCE_LINE_ID = :line;
  • Find records stuck beyond a threshold: SELECT * FROM CN.CN_SCA_HEADERS_INTERFACE_ALL WHERE PROCESS_STATUS IN ('P','E') AND CREATION_DATE < SYSDATE - 1;
  • Reconcile amounts by operating unit and rule: SELECT ORG_ID, CREDIT_RULE_ID, SUM(TRANSACTION_AMOUNT) FROM CN.CN_SCA_HEADERS_INTERFACE_ALL GROUP BY ORG_ID, CREDIT_RULE_ID;

These queries support daily interface monitoring, error remediation, and financial reconciliation of credited amounts before and after engine processing.

Related Objects

The following objects are most significant in relation to this interface table:

  • FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID; enforces row-level data security for the interface records.
  • CN_SCA_HEADERS_ALL / CN_SCA_LINES_ALL — the destination transactional tables populated by the Sales Credit Engine from this interface.
  • CN_CREDIT_RULES / CN_CREDIT_RULES_ALL — referenced via CREDIT_RULE_ID to determine credit allocation behavior.
  • CN_SRP_CREDITS / CN_SRP_CREDITS_ALL — salesperson credit results generated during processing.
  • CN_SCA_HEADERS_INTERFACE_ALL ancillary staging objects — companion interface structures (e.g., lines/splits interface tables) consumed by the same engine run.
  • OE_ORDER_LINES_ALL / RA_CUSTOMER_TRX_LINES_ALL — common upstream source documents whose identifiers populate SOURCE_ID/SOURCE_LINE_ID.

In a 12.1.1 and 12.2.2 environment the object, its columns, and its indexes are effectively identical; the primary difference is the editioning and online-patching infrastructure introduced in 12.2.