Search Results cz_ib_transactions




Overview
Explore in AI Chat

Overview

APPS.CZ_IB_TRANSACTIONS is a PL/SQL package belonging to the Oracle E-Business Suite Install Base (IB) integration layer delivered under the CZ product schema prefix. Its responsibility is to manage the lifecycle of Install Base "systems" — the hierarchical, configuration-based instances tracked against a customer's installed products — and to keep those instances synchronized with their underlying transactional records. The package defines strongly typed record and table structures, including txn_system_rec and txn_systems_tbl, which carry system identifiers, contact and site-use references, co-terminate dates, descriptive flexfield context and attribute columns, and the configuration system type. A companion txn_line_rec structure captures the source transaction identifiers used to trace an instance back to its originating transaction. Together these structures provide the data contract used by the package's public procedures to create, update, and reconcile the Install Base instance records and their extended configuration attributes.

Key Procedures and Functions

  • CLONE_IB_DATA — Copies Install Base configuration and instance data, supporting duplication of an existing structure or transaction context. This is the routine most commonly associated with the "clone_ib_data" search term, and is typically used when replicating installed-base records across environments, organizations, or transactional scenarios.
  • REMOVE_IB_CONFIG — Deletes or invalidates an Install Base configuration, removing the associated instance and configuration records.
  • UPDATE_INSTANCES — Applies changes to existing Install Base instance records, propagating updated system attributes to the underlying tables.
  • UPDATE_INSTANCES_STATUS — Modifies the status of one or more instances without altering their core attribute set.
  • SYNCHRONIZE_ATTRIBUTES — Reconciles extended configuration attributes between the source definition and the instance records.
  • CHECK_CZIB_ITEM — Validates whether a given item qualifies as an Install Base configuration item.
  • GET_CONFIGURATION_REVISION — Retrieves the revision of a specified configuration.
  • GET_CONNECTED_CONFIGURATIONS — Returns the configurations connected to a given system or instance.
  • TEST_UPDATE_INSTANCES, TEST_CONNECTED_CONFIGURATIONS, TEST_CONFIGURATION_REVISION — Diagnostic counterparts to the production routines, returning test or preview results without committing changes.
  • LOG_REPORT — Writes diagnostic or processing output to the logging infrastructure for audit and troubleshooting.

Tables Accessed

  • CZ_CONFIG_HDRS — Configuration headers, the parent definition for an Install Base configuration.
  • CZ_CONFIG_ITEMS — Line-level items belonging to a configuration.
  • CZ_CONFIG_EXT_ATTRIBUTES — Extended attribute values reconciled by SYNCHRONIZE_ATTRIBUTES.
  • CZ_XFR_RUN_INFOS_S — Transfer run information, used when instance data flows between systems.
  • CZ_DB_SETTINGS and CZ_DB_LOGS — Configuration settings and the log destination for LOG_REPORT.
  • DUAL — Used for single-row PL/SQL evaluations.
  • PLITBLM — The standard EBS PL/SQL table-index-by utility package for collection handling.

Usage Notes

CZ_IB_TRANSACTIONS is classified as an OTHER API, meaning it is not a public, supported extension interface but rather an internal implementation package. It is typically invoked indirectly by Install Base and Service forms or by concurrent programs that process instance creation and synchronization, and is referenced by three other packages within the CZ family. Because CLONE_IB_DATA performs bulk duplication of configuration and instance records, custom code should call it with the same safeguards applied to any mass data routine, and diagnostic procedures (the TEST_-prefixed routines) should be used to preview results before committing. Direct calls from customizations are discouraged unless the underlying table structures and record types are fully understood, since the package is subject to change without notice.