Search Results cz_xfr_run_infos_pk




Overview
Explore in AI Chat

Overview

The CZ_XFR_RUN_INFOS table is a core data object within the Oracle E-Business Suite Configurator (CZ) module, specifically in versions 12.1.1 and 12.2.2. As indicated by its description, it serves as a central repository for summary information about batch runs. These batch runs are typically associated with data import, export, or synchronization processes critical to the Configurator's operation, such as loading product model data from external sources into the runtime configurator engine. The table acts as a high-level audit and control mechanism, allowing administrators and the system itself to track the execution and status of these critical batch operations.

Key Information Stored

The primary purpose of the table is to log metadata for each distinct batch run. Its structure is anchored by the RUN_ID column, which serves as the unique identifier (Primary Key: CZ_XFR_RUN_INFOS_PK) for every run recorded. While the provided metadata does not list all columns, the table's role and foreign key relationships imply it stores essential summary details. These likely include timestamps for the run's start and completion, a status indicator (e.g., 'RUNNING', 'COMPLETE', 'ERROR'), the type of batch operation performed, the name of the source or target data set, and the initiating user or process. This information provides a consolidated view of batch activity.

Common Use Cases and Queries

The primary use case is operational monitoring and troubleshooting of Configurator batch processes. System administrators use this table to verify the success of data loads, identify failed runs for investigation, and analyze run history. Common reporting queries include identifying the most recent runs for a specific process type or checking for runs that ended in an error state. A typical diagnostic query might join CZ_XFR_RUN_INFOS with related log tables to get a complete picture of a failed run.

  • Listing recent batch runs: SELECT run_id, status, start_ts FROM cz_xfr_run_infos ORDER BY start_ts DESC;
  • Finding failed runs for analysis: SELECT * FROM cz_xfr_run_infos WHERE status = 'ERROR';
  • Joining with detail logs for a specific run: SELECT i.*, l.message FROM cz_xfr_run_infos i, cz_db_logs l WHERE i.run_id = l.run_id AND i.run_id = 12345;

Related Objects

The CZ_XFR_RUN_INFOS table has defined relationships with several other key Configurator tables, forming a cohesive data model for batch execution tracking. As per the metadata, it is referenced by the following foreign keys:

  • CZ_DB_LOGS: This table likely holds detailed log messages for each run, linked via RUN_ID.
  • CZ_DB_SIZES: This table may store metrics or statistics (e.g., record counts) captured during the run, linked via RUN_ID.
  • CZ_XFR_PROJECT_BILLS: This table references the LAST_IMPORT_RUN_ID, demonstrating how the run info table is used to track the most recent successful data import for a given project bill of materials, enabling incremental update logic.

These relationships position CZ_XFR_RUN_INFOS as a parent record for granular logging and data associated with a batch execution.