Search Results get_multiselect_value




Overview
Explore in AI Chat

Overview

JTFB_DCF is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM registry as an "OTHER" API type. Its documented purpose, drawn from the package header, is to create missing FND_MENU_ENTRIES rows for security data. In practice the package functions as a utility and maintenance library for the Oracle EBS framework layer that supports the CRM/Telesales Foundation (JTF) and Application Object Library (AK/FND) componentry. This is a legacy package: the source header identifies revision 115.6 dated 2002, indicating it has remained largely stable across release boundaries, and it is present in both 12.1.1 and 12.2.2.

Because the package is invoked implicitly by framework upgrade and patching logic rather than by end users, its behavior surfaces in the Applications log and concurrent manager output. When the package raises an unhandled exception during a patching or upgrade phase, the caller typically reports a generic unexpected_error — the search term that led to this documentation. In EBS terminology, "unexpected_error" is a wrapper message emitted by the AD/TXK patching engine and by certain FND forms when a called PL/SQL program unit fails rather than returning a controlled error code.

Key Procedures and Functions

  • SECURITY_UPDATE — The core routine of the package. It reconciles missing FND_MENU_ENTRIES records required for security data, ensuring menu entries referenced by security grants exist.
  • COPY — Copies definition data from a source region to a target region, taking source and target region codes as inputs. Used to replicate AK region configuration between objects.
  • GET_ICX_SESSION_ID — Returns the ICX (Interaction Center) session identifier for the current session, providing session context to callers.
  • GET_PARAMETER_VALUE — Parses a delimited parameter string and returns the value associated with a named parameter. Default separators are '&' for parameters and '=' for name/value pairs.
  • GET_MULTISELECT_COUNT and GET_MULTISELECT_VALUE — Utility pair for working with multi-select attribute values, returning the number of selected entries and the value at a given position respectively.
  • LOV_UPGRADE, GRAPH_UPGRADE, and MULTISELECT_UPGRADE — Upgrade routines that migrate LOV, graph, and multi-select attribute definitions to the current framework format.
  • AUDIT_COLUMNS_PATCH — Applies audit-column metadata changes as part of a patch or upgrade sequence.

Tables Accessed

The package reads and writes via APPS synonyms to AK_ATTRIBUTES, AK_REGIONS, AK_REGIONS_TL, AK_REGION_ITEMS, AK_REGION_ITEMS_TL, FND_MENUS, and FND_MENU_ENTRIES. The AK_* tables hold region, attribute, and region-item metadata, including translated (TL) descriptions, and are the target of the COPY and upgrade routines. FND_MENUS and FND_MENU_ENTRIES represent the application menu hierarchy and its security-relevant entry rows, which SECURITY_UPDATE repairs. Three other packages reference JTFB_DCF, confirming it is a shared utility rather than a leaf module.

Usage Notes

JTFB_DCF is not exposed as a direct end-user feature. It is invoked by framework upgrade scripts, patch drivers, and higher-level JTF packages during menu security reconciliation and AK region migration. In the context of an unexpected_error, the advisable diagnostic path is to inspect the concurrent request log or AD patch log for the underlying ORA- error, since the package's exceptions are surfaced only through the generic wrapper. Direct invocation is normally confined to support scripts or custom code that must repair security menu entries or migrate AK region definitions.