Search Results okc_allowed_tmpl_usages




Overview
Explore in AI Chat

Overview

The OKC_ALLOWED_TMPL_USAGES table is a core data entity within the Oracle E-Business Suite Contracts Core module (OKC). Its primary function is to define and enforce the permissible associations between contract templates and specific business document types. This table acts as a critical control mechanism, ensuring that templates are only applied to the categories of documents for which they were designed, thereby maintaining data integrity and business rule compliance within the contract authoring process. It is a foundational table for the template management functionality in both Oracle EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure centers on mapping a template to its allowed document types. The key columns include ALLOWED_TMPL_USAGES_ID, which serves as the primary key for each unique mapping record. The TEMPLATE_ID column stores the identifier for a specific contract template, linking to the OKC_TERMS_TEMPLATES_ALL table. The DOCUMENT_TYPE column holds the code for a business document type (such as a Sales Order, Purchase Agreement, or Service Contract), linking to the OKC_BUS_DOC_TYPES_B table. Together, these columns form the essential relationship that governs template applicability.

Common Use Cases and Queries

A primary use case is the validation performed by the application when a user attempts to apply a template to a new contract document. The system queries this table to confirm the document type is permitted. For administrative reporting, queries can list all templates available for a given document type or audit which document types a specific template supports. A common sample query would be:

  • SELECT tpl.template_name, doc.name FROM okc_allowed_tmpl_usages atu, okc_terms_templates_all tpl, okc_bus_doc_types_b doc WHERE atu.template_id = tpl.id AND atu.document_type = doc.code AND doc.name = 'Sales Order';

This retrieves all templates explicitly allowed for use with Sales Order documents, supporting setup and troubleshooting activities.

Related Objects

The table maintains defined foreign key relationships with two other central OKC tables, as documented in the ETRM metadata:

  • OKC_TERMS_TEMPLATES_ALL: The TEMPLATE_ID column in OKC_ALLOWED_TMPL_USAGES references this table, which stores the master definition of all contract templates.
  • OKC_BUS_DOC_TYPES_B: The DOCUMENT_TYPE column in OKC_ALLOWED_TMPL_USAGES references this table, which is the repository for all valid business document type codes within the Contracts module.

These relationships ensure referential integrity, meaning a record in OKC_ALLOWED_TMPL_USAGES cannot exist for a non-existent template or document type.