Search Results cnd_rules

Overview

APPS.CZ_RULE_IMPORT is a PL/SQL package in the Oracle E-Business Suite 12.1.1 and 12.2.2 environments that belongs to the Oracle Configurator / ETRM (Enterprise Territory and Rules Management) family of utilities operating on the CZ_* schema objects. Its principal business function is the bulk transport of rule definitions and their associated localized text from staging or development environments into the production rule repository. The package exists to support migrations between development projects and production rule sets, importing rule records, folder hierarchies, and translated text entries in a controlled and repeatable manner. The package is classified as OTHER in the ETRM metadata, meaning it is not a public end-user API but an internal utility invoked by migration and administration flows.

Key Procedures and Functions

The package exposes sixteen documented procedures and functions. The families of procedures follow a repeated pattern of loading rules and localized text for each rule category. The category-specific rule loaders are CND_RULES, KRS_RULES, XFR_RULES, RPT_RULES, and RESTAT_RULES, each responsible for importing rules belonging to the corresponding rule classification. Parallel procedures CND_LOCALIZED_TEXTS, KRS_LOCALIZED_TEXTS, XFR_LOCALIZED_TEXTS, RPT_LOCALIZED_TEXTS, and RESTAT_LOCALIZED_TEXTS load the translated text records associated with each of those rule categories. IMPORT_RULES and IMPORT_LOCALIZED_TEXTS act as the generic drivers that coordinate the category-specific loaders. RULE_IMPORT serves as the main entry point for a rule import operation. REPORT and REFRESH_STATISTICS provide post-import reporting and statistics refresh operations. LOCK_MODELS provides concurrency control by preventing modification of models while an import is in progress.

Tables Accessed

The package operates against a set of CZ_* tables accessed through APPS synonyms. CZ_RULES and CZ_RULES_S hold the current and historical rule definitions being imported. CZ_RULE_FOLDERS stores the folder hierarchy into which rules are organized. CZ_IMP_RULES and CZ_IMP_LOCALIZED_TEXTS are the staging tables from which imported records are read. CZ_LOCALIZED_TEXTS and CZ_INTL_TEXTS_S hold the translated text records, while CZ_DEVL_PROJECTS identifies the development project that is the source of the migration. CZ_XFR_RUN_INFOS, CZ_XFR_RUN_INFOS_S, and CZ_XFR_RUN_RESULTS capture transfer run metadata and per-run results, allowing each import to be tracked and audited. CZ_DB_LOGS records diagnostic logging. DBMS_APPLICATION_INFO and DUAL are referenced for session context and scalar evaluation, and PLITBLM is used for temporary PL/SQL table storage. The referenced internal type CZ_NUMBER_TBL_TYPE is used for numeric collections passed between procedures.

Usage Notes

CZ_RULE_IMPORT is referenced by the CZ_MIGRATE package and by itself, indicating that CZ_MIGRATE is the normal controlling package that invokes it during an ETRM rule migration. The package is therefore typically executed indirectly through a migration or deployment concurrent program rather than being called manually. In 12.1.1 and 12.2.2, administrators using ETRM rule migration runbooks will invoke CZ_MIGRATE, which in turn calls CZ_RULE_IMPORT to move rules and localized text across environments. Because the package writes to production rule tables, it should be executed within a controlled maintenance window, and LOCK_MODELS should be used to prevent concurrent rule or model edits. REFRESH_STATISTICS should be run after a large import to update optimizer statistics on the affected CZ_* tables.