Search Results cz_fce_compile




Overview
Explore in AI Chat

Overview

APPS.CZ_FCE_COMPILE is a PL/SQL package belonging to the Oracle E-Business Suite configuration and rules engine layer, historically delivered under the Configurator/Advanced Product Catalog (CZ) schema family and surfaced inside ETRM (Enterprise Territory and Rules Management) deployments. The package implements the configuration engine's expression compiler: it transforms declarative model structure — expression nodes, property values, effectivity sets, and item master attributes — into executable logic that the runtime configuration engine can evaluate. In practical terms, it is the component that "compiles" a configuration model's rules so that user selections in an order or quote context can be validated and propagated.

The name of the package, which contains the token COMPILE, along with its documented procedures COMPILE_LOGIC and COMPILE_LOGIC__, indicates that the package performs in-database code generation and interpretation rather than simple data manipulation. The package header declares an extensive set of associative array types (hashtables indexed by VARCHAR2, nested tables of numbers, nodes, and data hashtables). This type infrastructure is characteristic of a compiler that maintains symbol tables, node maps, and metadata caches while traversing a model graph.

Key Procedures and Functions

Four documented program units are exposed:

  • REPORT — Produces diagnostic or summary output describing the result of a compile operation, typically used for troubleshooting model compilation failures or for presenting compiled logic to an administrator.
  • DEBUG_LOGIC — Emits debugging information during compilation, allowing developers and support analysts to trace how expression nodes are being interpreted and resolved against the underlying model data.
  • COMPILE_LOGIC — The principal entry point. It reads the configuration model definition and generates the compiled representation of the model's logic.
  • COMPILE_LOGIC__ — The double-underscore variant is the conventional Oracle EBS naming pattern for a private or overloaded implementation body invoked by the public COMPILE_LOGIC wrapper, isolating internal recursion or alternate signatures from external callers.

The metadata does not document parameter lists, and none are asserted here. All four units are classified as OTHER, meaning they are not standard public APIs but are nonetheless referenced by three other packages within the application.

Tables Accessed

The package reads and writes the model definition and compiled artifact tables via APPS synonyms. The core structural tables are CZ_EXPRESSION_NODES, CZ_PS_NODES, CZ_PS_PROP_VALS, and CZ_MODEL_REF_EXPLS, which together describe the expression tree, the model's node graph, and property assignments. Model metadata is drawn from CZ_ITEM_MASTERS, CZ_ITEM_TYPE_PROPERTIES, CZ_ITEM_PROPERTY_VALUES, and CZ_PROPERTIES. Effectivity and language handling use CZ_EFFECTIVITY_SETS and CZ_LOCALIZED_TEXTS. Presentation-layer structures are referenced through CZ_DES_CHART_CELLS and CZ_DES_CHART_FEATURES. Compiled output is persisted in CZ_FCE_FILES and its sequence CZ_FCE_FILES_S. UTL_RAW is used for binary or hashed key manipulation.

Usage Notes

In Oracle EBS 12.1.1 and 12.2.2, CZ_FCE_COMPILE is invoked indirectly. Administrators publishing or validating a configuration model trigger compilation through the Configurator setup forms or associated concurrent programs; the three dependent packages call into this package rather than applications calling it directly. Customizations should invoke COMPILE_LOGIC only after model definition data has been fully committed, since partial model state produces incomplete compiled artifacts. The user search term "knapsack compiler for Windows" is unrelated to this object: the knapsack compiler is a separate third-party tool, and no such dependency exists here. Because COMPILE_LOGIC__ is a private convention, it should not be referenced by custom code across releases.