Search Results cz_config

Overview

APPS.CZ_CF_API, the Configuration API, is a public PL/SQL package belonging to the Oracle E-Business Suite Configure-to-Order (CZ) product family. Its scope, as documented in the package header, is to provide procedures and functions that perform various operations on configurations. It is classified as an API and is a core element of the CZ_MODEL_PUB and CZ_CONFIG business entities, both of which are referenced heavily across the E-Business Suite's model and configuration infrastructure. The package carries a repository compatibility rating of "S" (supported) and an active lifecycle status, and is referenced by 28 other packages — strong evidence that it functions as a foundational integration layer rather than a standalone utility.

The package exposes a collection of PL/SQL record and table types that define the shape of the data it manipulates. These include config_item_rec_type and config_item_tbl_type for configuration items (carrying component code, sequence number, operation, quantity, instance name, and location details), config_ext_attr_rec_type and config_ext_attr_tbl_type for extended attributes, and the INPUT_SELECTION / CFG_INPUT_LIST types used to stage user selections during configuration. Operation codes BV_OPERATION_UPDATE, DELETE, INSERT, and REVERT define the batch validation actions the API supports.

Key Procedures and Functions

The documented API surface consists of 41 procedures and functions. They fall into recognizable functional groups:

• Configuration lifecycle: COPY_CONFIGURATION, COPY_CONFIGURATION_AUTO, and DELETE_CONFIGURATION create and remove configuration instances, enabling users to duplicate an existing configuration (optionally with automatic selection logic) or dispose of one entirely.
• Usage management: DELETE_CONFIGURATION_USAGE and UPDATE_CONFIGURATION_USAGE maintain records of where configurations are consumed or referenced.
• Validation: VALIDATE performs the check that a configured structure is complete and legal against its model definition.
• Model and UI lookup: MODEL_FOR_ITEM, CONFIG_MODEL_FOR_ITEM, CONFIG_MODELS_FOR_ITEMS, UI_FOR_ITEM, CONFIG_UI_FOR_ITEM, CONFIG_UI_FOR_ITEM_LF, and CONFIG_UIS_FOR_ITEMS resolve the model definition and user-interface definition associated with one or more items.
• Publication resolution: MODEL_FOR_PUBLICATION_ID, UI_FOR_PUBLICATION_ID, and PUBLICATION_FOR_ITEM link published model versions back to their source structures.
• Product-level variants: CONFIG_MODEL_FOR_PRODUCT, CONFIG_MODELS_FOR_PRODUCTS, CONFIG_UI_FOR_PRODUCT, and CONFIG_UIS_FOR_PRODUCTS perform the same lookups keyed by product rather than item.

The table and record types, together with the CFG_OUTPUT_PIECES subtype built on UTL_HTTP.HTML_PIECE, indicate that the API also supports generating HTML fragments for web-based configuration flows.

Tables Accessed

The package reads and writes the primary configuration tables through APPS synonyms:

• CZ_CONFIG_HDRS and CZ_CONFIG_HDRS_S — configuration header records and their translated/secure variants.
• CZ_CONFIG_ITEMS — the individual configured line items, including component codes and quantities.
• CZ_CONFIG_ATTRIBUTES and CZ_CONFIG_EXT_ATTRIBUTES — standard and user-extensible attribute values attached to config items.
• CZ_CONFIG_INPUTS — captured user selections feeding the configuration.
• CZ_CONFIG_MESSAGES and CZ_CONFIG_MESSAGES_S — validation and error messages surfaced to the user.
• CZ_CONFIG_USAGES — references tracking where a configuration is consumed.
• CZ_MODEL_POOL_MAPPINGS and CZ_MODEL_PUBLICATIONS — model pool and publication mappings used during model and UI resolution.
• CZ_DB_LOGS, CZ_DB_SETTINGS, and CZ_DEVL_PROJECTS — diagnostic logging, configuration settings, and development-project metadata.
• UTL_HTTP — referenced for HTML output generation.

Usage Notes

CZ_CF_API is normally invoked indirectly rather than called directly by end users. Oracle's CZ configuration UI and the associated configuration forms and concurrent programs call it to copy, delete, validate, and resolve models and publications. Because it is classified as a public API with a supported compatibility rating, customers and partners building custom configure-to-order extensions on Oracle EBS 12.1.1 or 12.2.2 may call it from custom PL/SQL, forms personalizations, or concurrent program wrappers to programmatically copy configurations, validate a configuration prior to order entry, or retrieve the model and UI definition for an item or product. Callers should pass the package's record and table types (such as CFG_INPUT_LIST) when supplying input selections, and should expect the API to raise or return messages through CZ_CONFIG_MESSAGES.