Results for “workflow_process_short_name”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BISBV_TARGET_LEVELS is a read-only view owned by the APPS schema within the BIS (Applications BIS) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes the definition of target levels used by the Oracle Balanced Scorecard / Daily Business Intelligence target-setting framework. A target level represents the granularity at which a performance target is set — for example the combination of a specific measure, an organizational level, a time level, and up to seven additional dimension levels. The view joins the base definition table to its translation table so that consumers see the language-appropriate name, description, and unit of measure.

The view is defined with the WITH READ ONLY clause, meaning it cannot be used for DML. It is intended for reporting, integration, and inquiry: any form, concurrent program, or custom SQL that needs to know which target levels exist, or how a target is structured, queries this view rather than the underlying tables directly. The status of the object is documented as VALID.

Underlying Base Objects

The ETRM metadata documents no referenced base objects separately, but the published view text establishes the join unambiguously. The view is built over two tables:

• BIS_TARGET_LEVELS — the primary definition table holding the target level identifier, short name, indicator reference, organizational and time levels, dimension level references, workflow attributes, default notification role, computing and report functions, and the system flag.
• BIS_TARGET_LEVELS_TL — the translation (TL) table holding the language-specific NAME, DESCRIPTION, and UNIT_OF_MEASURE for each target level.

The two are joined on TARGET_LEVEL_ID, and the translation row is restricted by BIS_TARGET_LEVELS_TL.LANGUAGE = USERENV('LANG'). This pattern is standard for EBS translated entities: the _TL table stores one row per installed language, and USERENV('LANG') resolves to the session language code so that each user sees text in their own language.

Key Columns

• TARGET_LEVEL_ID — Primary key of the target level; the join key to the translation table.
• TARGET_LEVEL_SHORT_NAME (SHORT_NAME in the base table) — The internal short name used to reference the target level in configuration.
• TARGET_LEVEL_NAME and DESCRIPTION — Language-specific display name and description sourced from BIS_TARGET_LEVELS_TL.
• MEASURE_ID (INDICATOR_ID in the base table) — The indicator or measure to which the target applies.
• ORG_LEVEL_ID, TIME_LEVEL_ID — The organizational and time dimension levels that define the target's granularity.
• DIMENSION1_LEVEL_ID … DIMENSION7_LEVEL_ID — Up to seven additional dimension level references, establishing which level of each dimension the target is captured at.
• WORKFLOW_ITEM_TYPE, WORKFLOW_PROCESS_SHORT_NAME — Workflow item type and process used when the target triggers workflow (for example, notification of an exception or assignment).
• DEFAULT_NOTIFY_RESP_ID, DEFAULT_NOTIFY_RESP_SHORT_NAME — Default responsibility used for target notifications.
• COMPUTING_FUNCTION_ID — The function used to compute the target value.
• REPORT_FUNCTION_ID — The function used to report on the target.
• UNIT_OF_MEASURE — Language-specific unit of measure for the target, from the translation table.
• SYSTEM_FLAG — Indicates whether the target level is a seeded system-defined level.

Common Use Cases and Queries

Typical uses include listing the target levels available for a given indicator, resolving a target level's structure for a mapping or integration load, and joining to the translation table through the view for localized reporting. A representative query follows:

• Enumerate all target levels in the session language:
  SELECT target_level_id, target_level_short_name, target_level_name, unit_of_measure FROM apps.bisbv_target_levels ORDER BY target_level_short_name;
• List target levels for a specific measure and organizational level:
  SELECT target_level_id, target_level_name FROM apps.bisbv_target_levels WHERE measure_id = :indicator_id AND org_level_id = :org_level_id;
• Identify seeded versus user-defined levels:
  SELECT target_level_id, target_level_name, system_flag FROM apps.bisbv_target_levels WHERE system_flag = 'Y';

Because the view is read only and filters to the session language, it is safe for ad hoc queries, custom reports, and integration extraction. No DML should be attempted against it; updates to target level definitions must be performed through the BIS application setup or directly against BIS_TARGET_LEVELS and BIS_TARGET_LEVELS_TL.