Search Results eval_sr_kb_option
Overview
CS_CF_UPG_UTL_PKG is a utility package in the APPS schema that supports the Configurator Foundation (CS_CF) upgrade and migration framework within Oracle E-Business Suite 12.1.1 and 12.2.2. The package name prefix "UPG" indicates its role as a helper library during the upgrade of Service (CS) Configurator data, and it works in tandem with the higher-level packages CS_CF_UPG_PKG and CS_CF_UPG_BUGFIX1_PKG. Its primary business function is to evaluate and resolve the many profile-option-driven behaviors and user-interface attributes that govern Service Request (SR) entry, address handling, product selection, and interaction logging as those configurations are carried forward from a source environment to a target environment. Because the evaluator routines are grouped in a single utility package, the upgrade driver can query the effective setting of an SR option, region, or target independently of the runtime forms, ensuring that migrated configurations behave consistently after the upgrade completes.
Key Procedures and Functions
The ETRM metadata documents 31 procedures and functions. They fall into four functional clusters.
- Service Request option evaluators: EVAL_SR_ACCOUNT_OPTION, EVAL_SR_PROBLEM_CODE_OPTION, EVAL_SR_BILLTO_ADDRESS_OPTION, EVAL_SR_BILLTO_CONTACT_OPTION, EVAL_SR_SHIPTO_ADDRESS_OPTION, EVAL_SR_SHIPTO_CONTACT_OPTION, EVAL_SR_CREATION_PROD_OPTION, EVAL_SR_PRODUCT_SELECTION, EVAL_SR_ATTACHMENT_OPTION, EVAL_SR_KB_OPTION. Each resolves whether the corresponding SR feature is enabled or mandatory under the current profile configuration.
- SR display and validation routines: EVAL_SR_ADDR_DISPLAY, EVAL_SR_ADDR_MANDATORY, EVAL_SR_INSTALLEDAT_ADDRESS, EVAL_SR_TASK_DISPLAY, EVAL_SR_ENABLE_INTERACT_LOG, EVAL_SR_ENABLE_TEMPLATE. These control address rendering, mandatory-field enforcement, task visibility, and template or interaction-log enablement.
- Existence checks and data maintenance: RESP_ALREADY_EXISTS and APPL_ALREADY_EXISTS test for prior migration of responsibilities and applications to prevent duplicate inserts, while INSERT_NEW_TARGET and CLONE_REGION create new Configurator targets and copy Ak region definitions into the target environment.
- Supporting utilities: remaining private helpers used by the upgrade driver.
No parameter lists are published in the metadata; callers should reference the packaged specification rather than assume signatures.
Tables Accessed
- FND_PROFILE_OPTIONS and FND_PROFILE_OPTION_VALUES — the source of the effective option settings evaluated by the EVAL_* routines.
- AK_REGIONS, AK_REGION_ITEMS, AK_REGION_ITEMS_TL — read by CLONE_REGION to copy region and item definitions with translations.
- CS_CF_FLOWS_B — Configurator flow definitions referenced during upgrade.
- CS_CF_SOURCE_CXT_TARGETS, CS_CF_SOURCE_CXT_TARGETS_S, CS_CF_SOURCE_CXT_TYPES — source-context target and type mappings written by INSERT_NEW_TARGET.
- DUAL, PLITBLM, V$PARAMETER — utility lookups, NLS/PLITBLM string handling, and database parameter checks.
Usage Notes
CS_CF_UPG_UTL_PKG is not invoked directly from forms or concurrent programs. It is called internally by CS_CF_UPG_PKG and CS_CF_UPG_BUGFIX1_PKG during the Configurator Foundation upgrade path, and it also references itself for internal helper dispatch. As an APPS-owned, VALID package, it is available in both 12.1.1 and 12.2.2, but it should be treated as upgrade-only infrastructure: custom code should not call it, because its behavior and existence are tied to the upgrade lifecycle and it may be superseded in later patch levels.