Search Results isc_fs_task_fact

Overview

ISC_FS_TASK_ETL_PKG is a PL/SQL extraction, transformation, and load (ETL) package owned by the APPS schema in Oracle E-Business Suite. Its name and the constant g_object_name := 'ISC_FS_TASK_FACT' identify it as the loading mechanism for the Service Task fact in the Oracle Field Service / TeleService Analytics (ISC) data warehouse. The package moves operational task data from the transactional JTF and CS task tables into the ISC_FS star-schema fact and staging tables, enabling downstream business intelligence reporting on field service task volumes, assignments, statuses, and event history.

The package is classified as OTHER in ETRM and exposes a strictly procedural, batch-oriented interface. It is designed for concurrent program invocation rather than online form use, and it ships with two documented entry points that correspond to the standard ISC Analytics load cycle: a full initial load and a repeatable incremental load.

Key Procedures and Functions

• INITIAL_LOAD — Performs the initial, full-population load of the ISC_FS_TASK_FACT object. It is intended to be run once when the ISC Analytics schema is first configured or re-initialized, populating the fact and staging structures with the complete history of source task records. Like its companion procedure, it communicates execution outcome through the standard concurrent program errbuf and retcode out parameters.
• INCREMENTAL_LOAD — Performs the delta (incremental) load for the same fact object. This is the routine that most users searching on the term "incremental_load" are seeking. It reads only records changed since the previous successful run and merges them into the ISC fact and staging tables, keeping the analytics layer synchronized with day-to-day transactional activity without re-processing the full data set. As with INITIAL_LOAD, results are returned via errbuf and retcode, allowing the concurrent manager to record success or failure.

No standalone functions are documented; the package exposes only these two public procedures. The header reference ($Header: iscfstasketls.pls 120.0 2005/08/28) indicates the package has been stable since Release 12.0 and remains unchanged through 12.1.1 and 12.2.2.

Tables Accessed

The package reads from the JTF task foundation tables and writes to the ISC field service facts and staging tables. Documented references include:

• Source transactional tables: JTF_TASKS_B, JTF_TASK_ASSIGNMENTS, JTF_TASK_AUDITS_B, JTF_TASK_STATUSES_B, JTF_TASK_TYPES_B, JTF_RS_DEFAULT_GROUPS, CS_INCIDENTS_ALL_B — supplying task headers, assignment details, audit/change history, status and type lookups, resource group defaults, and linked service incidents.
• Field Service staging and fact tables: ISC_FS_TASKS_F, ISC_FS_TASK_ASSIGNMNTS_F, ISC_FS_EVENTS_STG, ISC_FS_EVENTS, ISC_FS_CAPACITY_F, ISC_FS_BREAK_FIX_TASKS, ISC_FS_PARTY_MERGE_EVENTS, CAC_SR_OBJECT_CAPACITY — the targets populated by the load, including task facts, assignment facts, staged and resolved event records, capacity facts, break/fix task links, and party-merge event handling.

Usage Notes

ISC_FS_TASK_ETL_PKG is normally invoked through the ISC Analytics concurrent programs (initial and incremental load programs registered against these procedures) from the Oracle Field Service Manager responsibility, or scheduled via the concurrent manager at a recurring interval. INITIAL_LOAD should be run once during setup or after a data-warehouse rebuild; INCREMENTAL_LOAD is then scheduled periodically to keep the Service Task fact current. Two other packages reference this package, indicating it also participates in a wider ISC ETL dependency chain. Custom code may call either procedure directly, but must supply the errbuf and retcode out parameters and should honor the package's batch semantics rather than invoking it interactively.