Search Results cn_commission_headers




Overview
Explore in AI Chat

Overview

APPS.CN_UPGRADE_PE_FORMULA_PKG is an Oracle EBS Incentive Compensation (formerly Oracle Trade Management / ETRM) upgrade utility package body. Its purpose is to migrate or normalize legacy Performance Element (PE) formula definitions so that quota and formula records used by the compensation engine remain consistent after an upgrade. The package belongs to the CN (Commission / Incentive Compensation) schema family and is classified as an OTHER API within the ETRM 12.2.2 documentation set.

The package operates on the intersection of two core configuration areas: quota definitions (CN_QUOTAS_ALL) and SQL-based calculation formulas (CN_CALC_FORMULAS_ALL, CN_CALC_SQL_EXPS_ALL). The embedded source shows that it derives a human-readable, deterministic formula name from attributes of a quota record — quota type, transaction group, discount option, payment type, cumulative flag, split flag, ITD flag, and org ID — producing codes such as RNQ_In_DiN style identifiers. It also resolves a performance measure by looking up a calculation SQL expression name within a given org.

Because it is an upgrade-oriented package, it is not intended for day-to-day transactional use. It exists to bridge legacy naming/identifier conventions to the structures expected by the current release. The source header identifies the file as cnuppefb.pls version 120.2, dated 2005, with a NOSHIP designation, indicating it is a non-shipped internal script historically used during release transitions.

Key Procedures and Functions

  • CREATE_DISCOUNT_OPTION_FORMULA — Documented procedure that creates the formula associated with a discount option configuration. It supports the upgrade of discount-related quota and formula records by generating the corresponding calculation formula.
  • GET_FORMULA_ID — Documented function that returns the identifier of an existing formula, allowing callers to resolve whether a required formula already exists before creating or linking one.
  • GET_FORMULA_NAME (present in source, not in the documented procedure list) — Constructs a formula name from decoded quota attribute flags.
  • GET_PERF_MEASURE (present in source) — Resolves a performance measure ID from CN_CALC_SQL_EXPS_ALL by name and org.

Tables Accessed

  • CN_QUOTAS_ALL — Read to obtain quota attributes (quota type, transaction group, discount option, payment type, cumulative/split/ITD flags, org ID) that drive formula naming.
  • CN_CALC_SQL_EXPS_ALL — Read to resolve a performance measure (calculation SQL expression) by name and org ID.
  • CN_CALC_FORMULAS_ALL — Target of formula creation; holds the formula definitions written by CREATE_DISCOUNT_OPTION_FORMULA.
  • DUAL — Used as the source for the DECODE-based formula name assembly.

Usage Notes

The package is invoked during upgrade or data-migration routines rather than through standard end-user forms. Because the documented classification is OTHER and the referenced-by count is zero, no shipped concurrent program or higher-level package currently depends on it in the documented release. It is therefore most likely executed from upgrade driver scripts or custom migration code that must rebuild performance element formulas for existing quota records. The user’s search term, CN_COMMISSION_HEADERS, does not appear among this package's referenced tables; readers investigating commission header data should consult packages that directly access the commission transaction tables, as this package does not touch them.