Search Results get_configuration_revision

Overview

APPS.CZ_IB_TRANSACTIONS is a configuration management package body within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments. The package is classified as an "OTHER" API, meaning it is not part of a formally published public API surface, but it is nonetheless a functioning component of the configuration infrastructure. Its core responsibility is managing Install Base (IB) configuration transactions — the associations, revisions, and attribute synchronizations that bind components and items into enterprise configuration structures.

The package supports the operational lifecycle of connected configurations: determining which configurations are related, updating instance records, synchronizing extended attributes, and validating configuration revisions. It also provides a dedicated logging facility that writes diagnostic output to both the CZ_DB_LOGS table and the standard FND log mechanism, indicating that the package is designed for use by concurrent processing where traceability is essential.

Key Procedures and Functions

• GET_CONNECTED_CONFIGURATIONS — Identifies the configurations that are connected to a given configuration. This is the subject of the user's query and likely serves the relationship-mapping requirement in the configuration management data model.
• TEST_CONNECTED_CONFIGURATIONS — Diagnostic counterpart to the above, intended for validation and testing purposes.
• GET_CONFIGURATION_REVISION — Returns the revision of a given configuration, supporting version control of configuration definitions.
• TEST_CONFIGURATION_REVISION — Test harness for the revision retrieval logic.
• UPDATE_INSTANCES and UPDATE_INSTANCES_STATUS — Update instance records and their statuses in the configuration model.
• UPDATE_INSTANCES_STATUS — Manages lifecycle state transitions for configuration instances regardless of Test Parallel path logic.
• SYNCHRONIZE_ATTRIBUTES — Reconciles extended attributes between the configuration and its underlying master data.
• CHECK_CZIB_ITEM — Validates whether a given item qualifies as a CZIB (configuration-managed) item.
• CLONE_IB_DATA — Copies Install Base configuration data, used during setup replication or environment copy.
• TEST_UPDATE_INSTANCES — Diagnostic companion to UPDATE_INSTANCES.
• REMOVE_IB_CONFIG — Deletes Install Base configuration data from the model.
• LOG_REPORT — Autonomous-transaction logging procedure that writes to CZ_DB_LOGS and the FND log. It handles single and multi-message writes, and its autonomous transaction pragma ensures log entries survive caller rollbacks — a deliberate design to preserve error diagnostics.

Tables Accessed

• CZ_CONFIG_HDRS — Header records for configurations; the master driver for revision and connected-configuration lookups.
• CZ_CONFIG_ITEMS — Line-level configuration items linked to headers.
• CZ_CONFIG_EXT_ATTRIBUTES — Extended attribute storage read and written during synchronization.
• CZ_DB_LOGS — Persistent log target for the LOG_REPORT procedure.
• CZ_DB_SETTINGS — Package configuration/settings source.
• CZ_XFR_RUN_INFOS_S — Transfer run information, likely tied to concurrent program runs.
• DUAL and PLITBLM — Utility/translation tables used for scalar selection and message lookups.

Usage Notes

CZ_IB_TRANSACTIONS is referenced by three other packages, confirming it is a shared service inside the configuration subsystem rather than a standalone entry point. It is most commonly invoked indirectly — through concurrent programs that update instances or synchronize attributes — or directly from custom code requiring connected-configuration resolution. The header comment indicates production usage through approximately 2008, with the package shipping at version 120.8. Because it is an "OTHER"-classified API, Oracle does not guarantee backward compatibility; implementations relying on GET_CONNECTED_CONFIGURATIONS or related routines should treat the interfaces as internal and validate behavior after patching or upgrading between 12.1.1 and 12.2.2.