Search Results get_expert_articles

Overview

OKC_XPRT_UTIL_PVT is an internal PL/SQL utility package in the APPS schema belonging to the Oracle Contracts (OKC) module, specifically the Expert Rules / Terms and Conditions component commonly referred to as ETRM (Expert Template Rules Management). The package is classified as PVT, indicating it is a private API intended for consumption by other EBS technical layers rather than a published, customer-facing interface. Its principal responsibility is to support the import, validation, and maintenance of Expert rules, questions, variables, and clause templates, and to bridge the Contracts repository with the Oracle Configurator (CZ) publication engine used to render and transfer model data.

Key Procedures and Functions

The documented package exposes 55 procedures and functions. The most significant are summarized below by category.

• Question and variable validation: CHECK_IMPORT_STATUS, CHECK_CLAUSE_EXISTS, CHECK_VARIABLE_EXISTS, CHECK_QUESTION_EXISTS, OK_TO_DELETE_QUESTION, IS_RULE_LINE_LEVEL, POPULATE_QUESTIONS_ORDER — these verify existence, ordering, and safe-deletion conditions for rules and questions during import and maintenance.
• Value set handling: IS_VALUE_SET_CHANGED, GET_VALUE_SET_ID — detect and resolve flexfield value set identity for configurator-driven prompts.
• Publication management: XPRT_ENABLED_TEMPLATE, CREATE_TEST_PUBLICATION, CREATE_PRODUCTION_PUBLICATION, GET_EXPERT_ARTICLES, GET_ARTICLE_DETAILS — govern the creation of test and production publications of Expert templates and the retrieval of article metadata.
• Configurator XML integration: BUILD_CZ_XML_INIT_MSG, PARSE_CZ_XML_TERMINATE_MSG, PROCESS_QA_RESULT — build the initiation message, parse the termination response, and process questionnaire results returned from Oracle Configurator.
• Configuration maintenance: UPDATE_CE_CONFIG, UPDATE_CONFIG_ID_REV_NBR — update configuration identifiers and revision numbers.
• Validation: VALIDATE_TEMPLATE_FOR_EXPERT — checks that a template is eligible for Expert rule activation.

Tables Accessed

The package reads and writes Contracts base and transactional tables including OKC_BUS_VARIABLES_B (business variables), OKC_XPRT_QUESTIONS_B (Expert questions), OKC_XPRT_RULE_HDRS_ALL (rule headers), OKC_ARTICLES_ALL and OKC_ARTICLE_VERSIONS (clause article text and versions). It also references Configurator tables such as CZ_DB_LOGS, CZ_IMP_RULES, CZ_LOCALIZED_TEXTS, CZ_MODEL_PUBLICATIONS, CZ_MODEL_USAGES, CZ_PS_NODES, CZ_UI_DEFS, and CZ_XFR_RUN_RESULTS, which support publication transfer and logging. Flexfield metadata is sourced from FND_FLEX_VALUE_SETS and FND_FLEX_VALIDATION_TABLES. In addition, the package depends on OKC_TERMS_QA_GRP.

Usage Notes

OKC_XPRT_UTIL_PVT is not typically invoked directly from Oracle Forms; instead, it is called by higher-level EBS packages such as OKC_TERMS_UTIL_PVT, OKC_TERMS_QA_PVT, OKC_TERMS_DEVIATIONS_PVT, OKC_TERMS_TMPL_APPROVAL_PVT, OKC_ARTICLES_GRP, OKC_XPRT_QA_PVT, OKC_XPRT_IMPORT_PVT and its import sub-packages, and OKC_XPRT_INT_GRP. These callers participate in template setup, Expert rule import, and contract terms authoring. Because PVT packages are private and their signatures are not guaranteed between releases, customizations should call the supported public APIs rather than this package. When troubleshooting Expert rule import, publication, or Configurator questionnaire failures, the CZ_* and OKC_XPRT_* tables listed above and the FND log output of the calling concurrent request are the primary diagnostic sources.