Search Results okc_number_schemes_b




Overview
Explore in AI Chat

Overview

The OKC_NUMBER_SCHEMES_B table is a core data object within the Oracle E-Business Suite Contracts Core (OKC) module, specifically for versions 12.1.1 and 12.2.2. It functions as the foundational repository for defining and storing numbering schemes. These schemes are critical for the systematic organization and hierarchical structuring of sections and clauses within contracts and contract templates. The table's role is to provide a centralized master list of available numbering formats, such as numeric (1, 2, 3), alphanumeric (A, B, C), or multi-level (1.1, 1.1.1), which can be applied to documents to ensure consistent and logical content presentation.

Key Information Stored

While the provided metadata does not list specific columns beyond the primary key, the table's structure is designed to define each unique numbering scheme. The primary column is NUM_SCHEME_ID, which serves as the unique identifier (Primary Key) for each numbering scheme record. Other typical columns in such a table would include fields to describe the scheme's format (e.g., a mask or pattern), its name, an indication of whether it is user-defined or seeded, and active status flags. The data stored enables users to select a predefined numbering scheme when creating templates or contracts, ensuring standardization across the contracting process.

Common Use Cases and Queries

A primary use case is during the setup and configuration of contract templates, where an administrator selects a numbering scheme to govern how clauses and sections will be automatically numbered. Reporting use cases involve auditing which numbering schemes are most frequently applied across the contract portfolio. Common SQL queries include retrieving a list of all available schemes for a LOV (List of Values) or identifying which templates use a specific scheme.

  • Sample Query to List All Numbering Schemes:
    SELECT num_scheme_id, name, format_mask FROM okc_number_schemes_b WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
  • Sample Query to Find Templates Using a Specific Scheme:
    SELECT t.template_name FROM okc_terms_templates_all t WHERE t.tmpl_numbering_scheme = <NUM_SCHEME_ID>;

Related Objects

The table is centrally referenced by key template management objects in the OKC module, as defined by its foreign key relationships. These relationships demonstrate how numbering schemes are applied to different document entities.

  • OKC_TERMS_TEMPLATES_ALL: The TMPL_NUMBERING_SCHEME column references OKC_NUMBER_SCHEMES_B.NUM_SCHEME_ID. This assigns a numbering scheme to a contract terms template.
  • OKC_TEMPLATE_USAGES: The DOC_NUMBERING_SCHEME column references OKC_NUMBER_SCHEMES_B.NUM_SCHEME_ID. This applies a numbering scheme to a specific template usage instance.
  • OKC_TEMPLATE_USAGES_H: The DOC_NUMBERING_SCHEME column references OKC_NUMBER_SCHEMES_B.NUM_SCHEME_ID. This is the history table for template usages, preserving the numbering scheme reference for audit purposes.