Search Results cn_sca_denorm_rules

Overview

The APPS.CN_SCA_DENORM_RULES_PVT package body is a private PL/SQL API within the Oracle E-Business Suite Credit Management (also referred to as Order Management's credit checking and rules engine) module. Its principal business function is to process Credit Rules and their associated allocation percentages by building and maintaining denormalized rule data. Denormalization is used here to collapse the combination of credit rule attributes, conditions, and operator values into a flattened structure stored in CN_SCA_DENORM_RULES, which enables faster rule evaluation during credit checking against transactions.

The package header indicates it was created on 06/26/2003 by Rao.Chenna and carries the version stamp 120.8.12020000.2 dated 2012/08/23, consistent with the 12.1.1 / 12.2.2 code line. The metadata classifies it as a PVT (private) API, meaning it is not intended for direct customer invocation and is instead called internally by other Credit Management components.

Key Procedures and Functions

The documented public interface exposes a single procedure:

• POPULATE_RULE_DENORM — The sole documented procedure. It is responsible for populating the denormalized rules structure that backs credit rule evaluation. In practice it reads credit rule definition data and writes the consolidated combinations into the denormalized table.

The package source additionally contains several private helper constructs observed in the body, including debugmsg (conditional diagnostic logging gated by the g_cn_debug flag and writing to fnd_file), and the find_combinations procedure, which walks credit rule attributes, operators, and existing denormalized attribute combinations to derive the valid rule combinations for a given transaction source and organization. These are internal and not part of the documented public API.

Tables Accessed

The package operates over the following Credit Management tables (referenced through APPS synonyms):

• CN_SCA_DENORM_RULES — The primary target of the denormalization process; stores the flattened rule attribute combination values written by POPULATE_RULE_DENORM and read by combination lookups.
• CN_SCA_CREDIT_RULES — Source of the credit rule definitions whose attributes and conditions are being denormalized.
• CN_SCA_RULE_ATTRIBUTES — Provides the attribute definitions and source column names used to identify which rule attributes participate in a combination.
• CN_SCA_CONDITIONS — Supplies the condition records associated with credit rules.
• CN_SCA_COMBINATIONS — Holds the generated attribute combination values that feed the denormalized output.
• DBMS_MVIEW — Utilized for materialized view refresh or related maintenance operations, given the package's reliance on a materialized view (CN_SCA_RULE_COND_VALS_MV) for rule condition values.

The body's cursor rule_attr_cur joins the materialized view cn_sca_rule_cond_vals_mv with cn_sca_rule_attributes and correlates to cn_sca_denorm_rules, confirming the dependency on these structures.

Usage Notes

Because CN_SCA_DENORM_RULES_PVT is a private package, it is not intended for direct invocation from custom code, forms, or concurrent programs. It is invoked internally by the Credit Management rule engine — typically when credit rules are created, modified, or when the denormalized data must be regenerated to reflect current rule definitions. The find_combinations logic filters by transaction_source and org_id, indicating the denormalization is performed per operating unit and per transaction source.

The metadata records that this package is referenced by 0 other packages, reinforcing that its callers are external triggers, forms-based rule maintenance, or engine components rather than other PL/SQL packages. Diagnostic tracing can be enabled through the g_cn_debug global, which routes messages to both the Credit Management debug facility and the concurrent request log via fnd_file. Administrators troubleshooting credit rule evaluation discrepancies should verify that the denormalized data has been refreshed through this package whenever underlying rule definitions change.