Search Results populate_rule_denorm




Overview
Explore in AI Chat

Overview

The APPS.CN_SCA_DENORM_RULES_PVT package is a private PL/SQL API within the Oracle E-Business Suite Credit-to-Cash (formerly TeleSales/Collections) family of modules. Its stated purpose, per the package header, is to serve as a public API for processing Credit Rules and their associated allocation percentages. It belongs to the Oracle Incentive Compensation / Channel Revenue Management style denormalization framework used by the Credit Management feature set (the CN prefix denotes Credit Management objects). The package exists primarily to flatten, or "denormalize," the normalized, highly relational credit rule definitions stored in the CN_SCA_* tables into pre-computed rows that runtime credit-checking logic can evaluate quickly. Because it is classified as PVT, it is intended for internal use by other Oracle application code rather than as a supported direct integration point for customers. The package declares AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema, and it references FND_PROFILE to read the CN_DEBUG profile option, enabling diagnostic logging when debugging is enabled.

Key Procedures and Functions

The package spec documents a single procedure: POPULATE_RULE_DENORM. This procedure is the working entry point invoked to rebuild the denormalized representation of credit rules. Its conventional EBS concurrent-program signature consists of the standard errbuf and retcode OUT parameters used for reporting status to the concurrent manager, plus an input parameter p_txn_src that identifies the transaction source for which rules are being denormalized. The procedure reads the normalized rule definitions and their associated attribute operators and allocation percentages, then writes the consolidated results to the denormalized table. The package also declares two associative-array record types — attr_prime_rec_type and attr_operator_rec_type — used internally to hold attribute prime numbers and operator IDs while processing each rule. No function returns a value; all processing is accomplished through side effects on the denormalized table.

Tables Accessed

The package reads from and writes to the following documented objects, referenced through APPS synonyms:

  • CN_SCA_CREDIT_RULES — the master credit rule definitions that drive the denormalization.
  • CN_SCA_CONDITIONS — the individual condition rows that qualify each rule.
  • CN_SCA_RULE_ATTRIBUTES — attribute definitions and operator mappings used to evaluate conditions.
  • CN_SCA_COMBINATIONS — the combination sets that pair rules with their allocation percentages.
  • CN_SCA_DENORM_RULES — the target denormalized table populated by POPULATE_RULE_DENORM.
  • DBMS_MVIEW — invoked to refresh materialized views dependent on the denormalized data.
  • PLITBLM — the PL/SQL integer table utility used for array handling.

Usage Notes

CN_SCA_DENORM_RULES_PVT is not intended for direct customer invocation. It is typically called by Oracle's own concurrent programs, workflow background processes, or forms-level logic that must regenerate the denormalized credit rule cache whenever credit rules, conditions, attributes, or combinations are created or modified. Administrators generally schedule the associated concurrent program so that POPULATE_RULE_DENORM runs after rule maintenance, ensuring the runtime credit-check path references current data. Because the procedure uses the EBS concurrent manager parameter convention (errbuf, retcode), it can be registered as a concurrent program executable. Custom code should avoid calling this private API directly; instead, Oracle-supported public APIs or the standard Credit Management concurrent programs should be used to trigger denormalization, since Oracle may change the internal signature or behavior between 12.1.1 and 12.2.2 releases without notice.