Search Results default_assignee_id




Overview
Explore in AI Chat

Overview

ENG_CHANGE_TASKS_VL is a language-enabled (VL) view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Engineering (ENG) product module. It presents the definition of Engineering Change Order (ECO) tasks — sometimes referred to as change tasks or change order routing tasks — that are associated with change templates and change orders. Because it exposes translated task names and descriptions, the view is the standard interface used by forms, concurrent programs, and reporting layers that need to display task definitions in the session language.

The view is reported as VALID in the ETRM repository and is documented identically across 12.1.1 and 12.2.2. It is a reporting-friendly join rather than a transactional entity: it does not itself store data but flattens the multi-language task model into a single row per task for the current language. The column DEFAULT_ASSIGNEE_ID, which prompted the original search, is central to ECO workflow configuration because it identifies the primary assignee to whom a change task is routed by default.

Underlying Base Objects

The view is defined over two base objects, each referenced through an APPS synonym:

  • ENG_CHANGE_TASKS_B — the base (non-translated) table holding task definition data common to all languages, including identifiers, sequencing, requirement flags, default assignment, and audit columns.
  • ENG_CHANGE_TASKS_TL — the translation table holding language-specific text such as task name and description.

The view joins these on CHANGE_TASK_ID and filters the translation rows with T.LANGUAGE = USERENV('LANG'), ensuring each task appears once, in the language of the current database session. The view also selects B.ROWID and exposes it as ROW_ID, an Oracle Forms convention that enables the form layer to navigate and update the underlying row through the view.

Key Columns

  • ROW_ID — the rowid of the underlying ENG_CHANGE_TASKS_B row; used by Forms for optimistic locking and navigation.
  • CHANGE_TASK_ID — primary key of the change task; the join key between the base and translation tables.
  • ORGANIZATION_ID — the inventory organization context to which the task belongs.
  • SEQUENCE_NUMBER — defines the display and execution order of tasks within a template.
  • REQUIRED_FLAG — indicates whether the task is mandatory when the change order is processed.
  • DEFAULT_ASSIGNEE_ID — identifier of the person (or role holder) to whom the task is assigned by default.
  • DEFAULT_ASSIGNEE_TYPE — the assignee category that qualifies the preceding ID (for example, user or role).
  • CHANGE_TEMPLATE_ID — the change template to which the task belongs.
  • TASK_NAME / DESCRIPTION — translated text from ENG_CHANGE_TASKS_TL.
  • Audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical uses include configuring change templates, generating reports of default task assignments, and integration extracts that feed workflow or notification systems. Because the view is language-aware, queries run under different USERENV('LANG') settings return task text in the corresponding language.

List all required tasks for a given template:

  • SELECT sequence_number, task_name, default_assignee_id, default_assignee_type FROM eng_change_tasks_vl WHERE change_template_id = :template_id AND required_flag = 'Y' ORDER BY sequence_number;

Locate every task whose default assignee is a specific person:

  • SELECT change_task_id, task_name, change_template_id FROM eng_change_tasks_vl WHERE default_assignee_id = :person_id AND default_assignee_type = 'USER';

Audit recently modified task definitions:

  • SELECT change_task_id, task_name, last_update_date, last_updated_by FROM eng_change_tasks_vl WHERE last_update_date >= SYSDATE - 30 ORDER BY last_update_date DESC;

These patterns reflect the documented column set and the view's join semantics; joins to the base table should use CHANGE_TASK_ID, and updates via the view rely on ROW_ID.