Search Results isc_fs_break_fix_tasks

Overview

APPS.ISC_FS_TASK_SETUP is a small PL/SQL package body belonging to the Oracle E-Business Suite Field Service (FS) / Service (ISC) module. Its purpose is to seed and synchronize the internal task-type assignment table ISC_FS_BREAK_FIX_TASKS with the set of task types defined in the shared JTF Task Manager repository that are classified for dispatch. In effect, the package performs the one-time (or re-runnable) setup step that establishes which task types are eligible to be handled as "break/fix" tasks by the Field Service application.

The package was authored on 2005/08/28 (per the $Header line, file iscfsbftskb.pls version 120.0) and is classified by ETRM as an OTHER API with no exposure as a formal public interface. It contains no business logic beyond a single merge/synchronization routine and is not referenced by any other package, indicating that it is intended to be invoked directly by an administrator, a setup process, or a concurrent program rather than called programmatically from other code.

Key Procedures and Functions

The package exposes exactly one documented procedure:

• MERGE_TASKS — Populates ISC_FS_BREAK_FIX_TASKS with every task type from JTF_TASK_TYPES_B whose rule column equals 'DISPATCH' and that does not already exist in the target table. The procedure first captures the runtime environment by assigning fnd_global.user_id and fnd_global.login_id to package-level globals (g_user_id, g_login_id), then performs an INSERT ... SELECT that stamps each new row with the current user, sysdate, and the current login. Newly inserted rows are created with enabled = 'N', so the administrator must explicitly enable each task type after the merge. The routine concludes with a COMMIT, making the insertions permanent and re-runnable without creating duplicates on subsequent executions.

No parameters are declared for MERGE_TASKS, and no other procedures or functions are documented for this package.

Tables Accessed

• ISC_FS_BREAK_FIX_TASKS — The target (write) table for the package. It stores the task types that Field Service treats as break/fix tasks. Columns populated include task_type_id, the standard WHO audit columns (created_by, creation_date, last_updated_by, last_update_date, last_update_login), and the enabled flag.
• JTF_TASK_TYPES_B — The source (read) table, part of the JTF Task Manager. It holds the base task-type definitions. The package filters on rule = 'DISPATCH', restricting the merge to dispatch-related task types, and uses an anti-join subquery against ISC_FS_BREAK_FIX_TASKS to avoid inserting rows that already exist.

Both objects are accessed through APPS synonyms, consistent with standard EBS coding practice.

Usage Notes

Because ISC_FS_BREAK_FIX_TASKS controls which task types are recognized as break/fix tasks, this package is typically run as part of initial Field Service setup, after task types have been defined in JTF Task Manager, or following the addition of new dispatch task types. It is safe to re-execute: the anti-join prevents duplicates, so the procedure simply appends any newly qualifying task types.

The package is not referenced by any other package and exposes no formal API parameters, so invocation is normally performed through a concurrent program wrapper, a SQL*Plus script, or a custom setup hook that calls ISC_FS_TASK_SETUP.MERGE_TASKS directly. Because the routine issues a COMMIT internally, callers should not wrap it inside a larger transaction that requires rollback capability. Administrators should note that inserted rows default to enabled = 'N' and must be activated manually before the task types take effect. The package is compatible with both EBS 12.1.1 and 12.2.2 since the underlying tables and FND_GLOBAL APIs are unchanged across those releases.