Search Results config_status




Overview
Explore in AI Chat

Overview

APPS.CZ_CONFIG_HDRS_V is a reporting and integration view in Oracle E-Business Suite Release 12.1.1 and 12.2.2 that exposes configuration header records managed by the Oracle Configurator and Oracle Configure-to-Order (CTO) modules. It presents configuration headers created against models, including their revision numbers, status, ownership, and associated opportunity or quote context. Because the view applies a fixed filter of WHERE DELETED_FLAG='0', it delivers only logically active configuration headers, shielding consumers from records that have been soft-deleted within the Configurator data model. This makes it the preferred access point for queries, concurrent programs, reports, and interface logic that must reason about "live" configurations rather than the full transactional history retained in the base table.

Underlying Base Objects

The view is owned by APPS and is defined over the synonym CZ_CONFIG_HDRS, which resolves to the underlying Configurator configuration header table. The ETRM metadata identifies CZ_CONFIG_HDRS (SYNONYM) as the single referenced base object. The view is a straightforward projection: it selects a defined set of columns from CZ_CONFIG_HDRS and applies the deleted-flag predicate. It introduces no joins, aggregations, or derived expressions, so its row cardinality is a strict subset of the base table (rows where DELETED_FLAG equals '0'). Consequently, any DML against the view is subject to base-table constraints, and the view should be treated as read-only for reporting purposes.

Key Columns

Common Use Cases and Queries

The most frequent usage is filtering configurations by status, which aligns directly with the search term "config_status." A typical query retrieves active configuration headers for a model:

  • SELECT CONFIG_HDR_ID, NAME, CONFIG_STATUS, CONFIG_REV_NBR FROM APPS.CZ_CONFIG_HDRS_V WHERE CONFIG_STATUS = 'ACTIVE';
  • SELECT CONFIG_HDR_ID, NAME, USER_ID_CREATED, CONFIG_DATE_CREATED FROM APPS.CZ_CONFIG_HDRS_V WHERE OPPORTUNITY_HDR_ID = :p_opp_id;
  • SELECT CONFIG_STATUS, COUNT(*) FROM APPS.CZ_CONFIG_HDRS_V GROUP BY CONFIG_STATUS;
  • SELECT CONFIG_HDR_ID, NAME FROM APPS.CZ_CONFIG_HDRS_V WHERE HAS_FAILURES = 'Y';

These patterns support configuration status dashboards, quote-to-order reconciliation, validation-failure monitoring, and interface extracts. Because the view already excludes deleted rows, callers need not add the deletion predicate themselves.