Search Results cn_process_batches




Overview
Explore in AI Chat

Overview

APPS.CN_PURGE_PKG is a PL/SQL package body in the Oracle EBS Incentive Compensation (CN) module. Its business function is to permanently remove transactional and setup data from the Incentive Compensation schema once that data is no longer required for active processing, reporting, or audit retention. Because Incentive Compensation accumulates large volumes of transaction, commission, payment, and period data, purging is a routine housekeeping operation used to control table growth and to satisfy data retention policies before or after period rollover.

The package is classified as OTHER rather than as a public API, indicating that it is an internal maintenance utility rather than a supported integration entry point. It manipulates the core Incentive Compensation tables directly and, where appropriate, delegates to the CN APIs and message package. The metadata records a single documented program unit, PURGE, which serves as the entry point for the purge operation.

Key Procedures and Functions

The package exposes one documented program unit:

  • PURGE — The single public procedure that performs the purge operation. It coordinates the removal of the targeted Incentive Compensation data set, referencing the CN transaction, commission, payment, and period tables as well as the CN APIs and CN_MESSAGE_PKG. Because the documented metadata does not publish a parameter list, the exact signature is not restated here; callers are expected to drive the procedure through the standard concurrent program interface that wraps it.

The internal dependencies show the package also relies on CN_COMM_LINES_API and CN_PAYMENT_API, suggesting that part of the cleanup is performed through approved API calls (for example, to reverse or otherwise dispose of commission lines and payment records) rather than purely by direct DML. CN_MESSAGE_PKG is referenced for error and status messaging during execution.

Tables Accessed

CN_PURGE_PKG references the following tables via APPS synonyms:

Together these tables represent the full lifecycle of Incentive Compensation data: input transactions, processed commission and payment results, and the period/quota scaffolding that surrounds them.

Usage Notes

CN_PURGE_PKG is typically invoked indirectly rather than from custom code. In Oracle EBS 12.1.1 and 12.2.2 it is driven by an Incentive Compensation concurrent program (and its associated submission form) that collects selection criteria and calls PURGE to carry out the deletion. Administrators run it to reclaim space and remove obsolete batches, transactions, and commission/payment records according to retention requirements.

Because the package writes directly to core CN tables and calls the CN APIs, it must be treated as a maintenance utility: it should only be run by authorized Incentive Compensation administrators, after confirming that the data set is no longer needed, and preferably during scheduled downtime or a low-activity window. The dependency report shows CN_PURGE_PKG is not referenced by any other database object, confirming that no other packaged code depends on its internals.