Search Results cn_payruns_all




Overview
Explore in AI Chat

Overview

The CN_PAYRUNS_ALL table is a core data object within the Incentive Compensation (CN) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the master repository for payrun records, which correspond to the execution of payment or compensation calculation cycles. Each row in this table represents a distinct instance of a payrun, a critical business process where incentive earnings are finalized, aggregated, and prepared for payment disbursement or journal entry creation. The table's structure, including its foreign key relationships to period statuses, pay groups, and credit types, establishes it as the central control point for tracking the timing, scope, and financial context of compensation runs. Its "ALL" suffix indicates it is a multi-organization access enabled table, storing data across operating units.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the documented foreign keys and primary key reveal the essential data entities linked to each payrun. The primary identifier is PAYRUN_ID. Critical contextual attributes are established through foreign key columns, including: ACCOUNTING_PERIOD_ID and PAY_PERIOD_ID, linking to CN_PERIOD_STATUSES_ALL to define the fiscal and pay periods; PAY_GROUP_ID, linking to CN_PAY_GROUPS_ALL to define the population of compensable resources; and FROM_CREDIT_TYPE_ID and TO_CREDIT_TYPE_ID, linking to CN_CREDIT_TYPES_ALL_B to control the types of incentive credits being processed in the run. The BATCH_ID links to CN_LEDGER_JE_BATCHES_ALL, connecting the compensation activity to the General Ledger for accounting integration.

Common Use Cases and Queries

This table is fundamental for audit, reporting, and process control within Incentive Compensation. Common operational queries involve listing payruns for a specific period or pay group to review processing history. For example: SELECT payrun_id, name, creation_date FROM cn_payruns_all WHERE pay_group_id = :p_group AND pay_period_id = :p_period ORDER BY creation_date DESC;. Analysts use joins to report on the volume or value of transactions processed in a run, linking to detail tables like CN_PAYMENT_WORKSHEETS_ALL via PAYRUN_ID. Troubleshooting a specific payment issue often begins by identifying the controlling PAYRUN_ID from a worksheet or payment record and then querying CN_PAYRUNS_ALL to understand the run's parameters, such as its associated accounting period and credit type mappings, to validate processing rules.

Related Objects

As indicated by the foreign key metadata, CN_PAYRUNS_ALL has integral relationships with numerous other CN tables. It is a parent table to key transaction detail tables, including CN_PAYMENT_WORKSHEETS_ALL, CN_PAYMENT_API_ALL, and CN_WORKSHEET_BONUSES_ALL, which store the calculated payment lines generated during the payrun. It is a child table to several setup and control tables: CN_PERIOD_STATUSES_ALL (for periods), CN_PAY_GROUPS_ALL (for organization), CN_CREDIT_TYPES_ALL_B (for compensation types), and CN_LEDGER_JE_BATCHES_ALL (for GL integration). This network of relationships positions CN_PAYRUNS_ALL as a central hub connecting compensation setup, transaction processing, and financial posting.