Search Results cn_formula_common_pkg




Overview
Explore in AI Chat

Overview

CN_CALC_SUBLEDGER_PVT is a private (PVT) PL/SQL package in the APPS schema that forms part of the Oracle E-Business Suite Incentive Compensation (CN) module. Its role is to build and maintain the subledger representation of calculated commission and incentive compensation results, translating qualified transaction and quota performance into accounting-ready subledger records and, where required, into Journal Entry batches destined for the General Ledger. It operates in the calculation layer that sits between formula evaluation and final compensation posting, consuming the outputs of CN_FORMULA_COMMON_PKG and feeding downstream batch processing driven by CN_PROC_BATCHES_PKG.

As a PVT package, it is treated as internal infrastructure rather than a public API. The API classification of PVT indicates that direct invocation from customer extensions is not supported; the package is called by other CN calculation and batch packages within the application's own processing chain.

Key Procedures and Functions

The package exposes four documented procedures that cover subledger maintenance, journal entry posting, and quota forecasting:

  • UPDATE_SRP_SUBLEDGER — Updates the subledger records associated with Sales Representative (SRP) compensation results, reflecting calculated earnings and related accounting amounts generated during a compensation calculation run.
  • UPDATE_SRP_PE_SUBLEDGER — Performs the equivalent subledger update for the payee element (PE) perspective, ensuring that individual payee-level earnings are reflected in the subledger alongside the SRP-level entries.
  • POST_JE_BATCH — Creates or submits the Journal Entry batch that carries the subledger results into the accounting stream for subsequent transfer to and posting in the General Ledger.
  • ROLL_QUOTAS_FORECAST — Rolls quota balances forward for forecasting purposes, carrying quota allocations and period quota results into future forecast periods.

No parameter lists are documented for these procedures in the ETRM metadata, and signatures should not be assumed; callers within the CN codebase supply the inputs as part of the standard calculation workflow.

Tables Accessed

The package reads and writes a substantial set of Incentive Compensation and quota tables, accessed through APPS synonyms. Commission and formula data — CN_CALC_FORMULAS_ALL, CN_COMMISSION_HEADERS_ALL, CN_COMMISSION_LINES, and CN_COMMISSION_LINES_ALL — supplies the calculation inputs and line-level results. Period and calculation context are drawn from CN_PERIOD_STATUSES, CN_CAL_PER_INT_TYPES_ALL, and CN_PROCESS_BATCHES_ALL, which governs whether a period is open for subledger and posting activity.

Quota-related tables — CN_QUOTAS_ALL, CN_QUOTA_RULES_ALL, CN_SRP_PERIOD_QUOTAS_ALL, CN_SRP_PERIOD_QUOTAS_EXT_ALL, and CN_SRP_PER_QUOTA_RC_ALL — support both the calculation of quota-attainment earnings and the ROLL_QUOTAS_FORECAST operation. Payee and plan context is provided by CN_SRP_PAYEE_ASSIGNS_ALL, CN_ROLE_PLANS_ALL, and CN_SRP_PERIODS_ALL. Together these tables allow the package to translate performance results into subledger amounts and posting-ready journal batches.

Usage Notes

CN_CALC_SUBLEDGER_PVT is invoked internally during Incentive Compensation calculation and posting cycles, typically initiated from concurrent programs or from batch orchestration logic in CN_PROC_BATCHES_PKG. It depends on CN_FORMULA_COMMON_PKG for formula evaluation and on FND_API and STANDARD for the standard Oracle EBS API error-handling and PL/SQL constructs. The package is referenced by CN_FORMULA_COMMON_PKG and CN_PROC_BATCHES_PKG, confirming its position as an internal collaborator rather than a standalone entry point. Because it is a PVT package, customization or direct calls should be avoided; the supported route for extending calculation behavior is through the public CN APIs and formula definitions, leaving this package to execute as part of the delivered process chain.