Search Results oke_chg_statuses_b




Overview
Explore in AI Chat

Overview

The OKE_CHG_STATUSES_B table is a core reference data table within the Oracle E-Business Suite (EBS) Project Contracts (OKE) module. It serves as the master repository for all defined change statuses that govern the lifecycle of contract changes, including change requests and change orders. This table is integral to the change management workflow, as statuses control progression, enforce business rules, and determine the actions permissible on a change at any given point. The '_B' suffix indicates it is the base table, storing the primary transactional data, which is typically extended by a corresponding translation table (OKE_CHG_STATUSES_TL) for multilingual support.

Key Information Stored

Based on the provided metadata, the table's primary purpose is to define discrete status codes and their associated workflow characteristics. The most critical column is CHG_STATUS_CODE, which serves as the table's primary key. This column stores the unique, short code (e.g., 'DRAFT', 'APPROVED', 'EXECUTED') that identifies a specific status. Another significant column is WF_ITEM_TYPE, which is a foreign key to the WF_ITEM_TYPES table. This links each change status to a specific Oracle Workflow process, defining the business logic and approval path that is triggered when a change enters that status. While specific descriptive name columns are not listed in the excerpt, they are typically housed in the related OKE_CHG_STATUSES_TL table, keyed by CHG_STATUS_CODE and LANGUAGE.

Common Use Cases and Queries

This table is primarily used for validation, reporting, and driving workflow. Common operational queries involve retrieving the list of valid statuses for a user interface LOV or validating a status transition. For instance, a report to show all active changes by their status description would join the base and translation tables. A key administrative use case is querying the workflow setup for each status to troubleshoot approval process issues.

  • Listing all status codes with their workflow item type: SELECT chg_status_code, wf_item_type FROM oke.oke_chg_statuses_b;
  • Joining with the translation table for a user-friendly report: SELECT b.chg_status_code, t.name FROM oke.oke_chg_statuses_b b, oke.oke_chg_statuses_tl t WHERE b.chg_status_code = t.chg_status_code AND t.language = USERENV('LANG');
  • Finding all changes currently in a specific status (e.g., 'PENDING_APPROVAL'): SELECT request_number FROM oke.oke_chg_requests WHERE chg_status_code = 'PENDING_APPROVAL';

Related Objects

The OKE_CHG_STATUSES_B table has defined relationships with several key transactional and setup tables in the OKE schema, as confirmed by the foreign key metadata.

  • OKE_CHG_STATUSES_TL: The translation table that provides the descriptive name (NAME) for each CHG_STATUS_CODE in multiple languages.
  • OKE_CHG_REQUESTS & OKE_CHG_LOGS: These primary transactional tables store contract changes and their audit history, respectively. They both reference OKE_CHG_STATUSES_B via the CHG_STATUS_CODE foreign key to track the current and historical status of each change.
  • WF_ITEM_TYPES: An Oracle Workflow table that defines the workflow process associated with a status via the WF_ITEM_TYPE foreign key column.