Search Results cn_process_audit_lines_all




Overview
Explore in AI Chat

Overview

The CN_PROCESS_AUDIT_LINES_ALL table is a core data object within the Oracle E-Business Suite Incentive Compensation (CN) module. It functions as a detailed execution log, storing granular status and informational messages generated during the run of key compensation processes. This table is integral to the auditing and troubleshooting framework, providing a line-level audit trail that complements the high-level process execution records. Its role is to offer administrators and functional users visibility into the step-by-step operations, warnings, errors, and informational notes produced by batch jobs, enabling precise diagnosis of processing issues and validation of calculation integrity.

Key Information Stored

The table's primary purpose is to capture process log messages. Its structure is centered around linking each message to a specific process run and categorizing its nature. While the full column list is not provided in the excerpt, the documented primary key is PROCESS_AUDIT_LINE_ID, a unique identifier for each log entry. The critical foreign key column is PROCESS_AUDIT_ID, which ties each line entry to a parent record in the CN_PROCESS_AUDITS_ALL table. Typical columns in such audit tables include MESSAGE_TEXT or DESCRIPTION for the log content, MESSAGE_TYPE or SEVERITY to classify messages (e.g., 'ERROR', 'WARNING', 'INFO'), a SEQUENCE_NUMBER to preserve the order of operations, and possibly OBJECT_ID or OBJECT_TYPE columns to reference the specific compensation entity (like a transaction or plan element) that triggered the message.

Common Use Cases and Queries

The primary use case is investigating process failures or unexpected results from compensation engine runs, such as the Calculate Compensation or Post Transactions processes. A support analyst would query this table to retrieve all error messages for a failed process run. A common reporting need is to generate a detailed execution log for a specific audit ID.

  • Retrieve all error messages for a process run:
    SELECT message_text FROM cn_process_audit_lines_all l, cn_process_audits_all a WHERE l.process_audit_id = a.process_audit_id AND a.request_id = :req_id AND l.message_type = 'ERROR' ORDER BY l.sequence_number;
  • Get a complete, ordered execution log:
    SELECT sequence_number, message_type, message_text FROM cn_process_audit_lines_all WHERE process_audit_id = :audit_id ORDER BY sequence_number;

Related Objects

The table has a direct, documented foreign key relationship with the CN_PROCESS_AUDITS_ALL table. This is a critical parent-child relationship where CN_PROCESS_AUDIT_LINES_ALL.PROCESS_AUDIT_ID references the primary key in CN_PROCESS_AUDITS_ALL. The parent table (CN_PROCESS_AUDITS_ALL) stores the header-level information for each process execution, such as the concurrent request ID, start/end time, and overall status. Therefore, any meaningful query against the lines table will typically involve a join to the audits table to provide context. Other related objects may include standard Oracle EBS tables like FND_CONCURRENT_REQUESTS (via the request_id in the parent audit record) and various CN transaction and calculation tables referenced within the log messages themselves.