Search Results okc_util




Overview
Explore in AI Chat

Overview

OKC_UTIL is a utility package body in the APPS schema that supports the Oracle Contracts (OKC) module within Oracle E-Business Suite 12.1.1 and 12.2.2. In the ETRM classification scheme it is registered as a UTIL package, meaning it is not an end-user business API in the sense of OKC_API, but rather a repository of shared helper routines that other Contracts components call to perform common mechanical tasks. Its primary responsibilities include validating and normalizing data, resolving descriptive flexfield and lookup metadata, managing knowledge-zone access privileges, copying article and clause text including CLOB content, and providing small environment helpers such as window titles and forms savepoints.

The package body depends on the standard EBS technology stack (FND_API, FND_MSG_PUB, FND_PROFILE, FND_GLOBAL, FND_LOOKUPS, FND_MESSAGE, FND_FILE, FND_LOG, UTL_FILE, DBMS_TRANSACTION, JTF resource tables, OKX organization and set-of-books views) as well as core OKC tables. It is not referenced by any database object directly, but the metadata records that it is referenced by 325 other packages, confirming its role as a foundational utility layer across the Contracts family and adjacent modules.

Key Procedures and Functions

The documented interface exposes 54 procedures and functions. The following groups reflect their documented names and purposes.

Tables Accessed

OKC_UTIL reads and writes the principal Contracts repository: OKC_K_HEADERS_B and OKC_K_HEADERS_V for contract headers, OKC_K_ARTICLES_B and OKC_ARTICLE_VERSIONS for article bodies and versions, OKC_STD_ART_VERSIONS_TL and OKC_K_GROUPS_TL for translated standard articles and groups, OKC_TERMS_TEMPLATES_ALL with its sequence, OKC_TEMPLATE_USAGES_V, OKC_ALLOWED_TMPL_USAGES and its sequence, OKC_RULE_DEFS_V, OKC_SUBCLASSES_V, OKC_SUBCLASS_RESPS and its view, and OKC_K_ACCESSES for access records. It also queries JTF_OBJECTS_B, JTF_RS_GROUPS_B, JTF_RS_GROUPS_DENORM, JTF_RS_GROUP_MEMBERS, JTF_RS_RESOURCE_EXTNS, JTF_RS_ROLES_B, and JTF_RS_ROLE_RELATIONS for resource and role resolution, and OKX_ORGANIZATION_DEFS_V and OKX_SET_OF_BOOKS_V for organisation and ledger context. Foundation tables include FND_LOOKUPS, FND_LOOKUP_VALUES, FND_LANGUAGES, FND_PRODUCT_GROUPS, FND_APPLICATION_VL, and FND_DFLEX.

Usage Notes

Because OKC_UTIL is a utility package, it is rarely invoked directly by end users. It is called from Contracts forms such as the Terms and Contracts authoring screens, from concurrent programs that copy or validate contract data, and from custom extensions that need the same validation, JTF resolution, and CLOB copy behaviour. The presence of FORMS_SAVEPOINT and GET_ORG_WINDOW_TITLE indicates form-level use, while COPY_CLOB and COPY_ARTICLES_TEXT are used during template application and contract duplication. Developers should treat the dependencies on FND_LOG, FND_MSG_PUB, and FND_API as evidence that errors are raised through the standard EBS message stack, so callers should initialise the message stack and check API return status where documented. Direct modification of the package is not supported; extensions should call it or create wrappers.