Search Results cn_process_batches_s1




Overview
Explore in AI Chat

Overview

CN_TRANSACTION_LOAD_PUB is a public PL/SQL package body owned by the APPS schema in Oracle EBS 12.1.1 and 12.2.2. It is the primary interface in the Oracle Incentive Compensation (CN) module for loading transaction data into the staging and processing tables that feed commission calculation. The package wraps the internal logic of CN_TRANSACTION_LOAD_PKG and exposes a controlled, publicly callable API (classified as PUB in the ETRM registry) that other modules, concurrent programs, and custom extensions invoke to submit, validate, and stage commission transactions prior to batch processing.

The dependent package CN_TRANSACTION_LOAD_PUB_CUHK and the view CN_TRANSACTION_LOAD_PUB_VUHK also reference this package, indicating that it forms the base of the transaction-loading API from which customized and view-based variations are derived. Because the object references FND_API, FND_MSG_PUB, FND_GLOBAL, and FND_PROFILE, its execution participates fully in the standard Oracle EBS API framework—message stacking, error handling, and session context are all observed.

Key Procedures and Functions

The ETRM metadata documents a single public procedure/function for this package: LOAD. The LOAD routine is the entry point through which callers pass transaction data into Incentive Compensation. Internally it orchestrates the delegation to CN_TRANSACTION_LOAD_PKG, applies validation through the FND message framework, and stages records for subsequent classification and rollup.

The referenced dependencies reveal the supporting logic invoked during LOAD: CN_CALC_CLASSIFY_PVT and CN_CALC_ROLLUP_PVT are called for classification and rollup of loaded transactions, while CN_FORMULA_COMMON_PKG supplies formula evaluation. CN_COMM_LINES_API and CN_COMM_LINES_API_ALL are referenced for commission line manipulation. CN_PROC_BATCHES_PKG is used to create and manage process batches, and CN_MESSAGE_PKG handles module-specific messaging. CN_TRANSACTION_LOAD_PUB_CUHK and CN_TRANSACTION_LOAD_PUB_VUHK provide country-specific and view-based extension hooks that participate during LOAD execution.

Tables Accessed

Through APPS synonyms the package reads and writes the core Incentive Compensation transaction tables:

Read access is primarily through APPS-owned synonyms; procedural objects such as CN_CALC_CLASSIFY_PVT are executed via the show dependent code links rather than directly queried.

Usage Notes

LOAD is typically invoked from three contexts. First, from the Incentive Compensation concurrent programs that submit transaction load batches; the CN_PROCESS_BATCHES_S1 sequence is used to generate batch identifiers during these runs. Second, from the EBS forms that submit or validate commission transactions interactively. Third, from custom PL/SQL code where developers call APPS.CN_TRANSACTION_LOAD_PUB.LOAD inside their own processing logic, relying on FND_API and FND_MSG_PUB conventions for return status and error stack inspection.

Because the package is a PUB API, direct DML against the underlying CN tables should be avoided; callers should invoke LOAD so that classification, rollup, formula evaluation, and messaging execute correctly. The absence of any object referencing CN_TRANSACTION_LOAD_PUB beyond the CUHK/VUHK extension packages indicates that it is intended as a top-level entry point, not a component called by other database objects. Custom installations commonly clone the CUHK and VUHK variants to add country-specific validation without altering this base package.