Search Results isc_fs_task_bac_age_etl_pkg




Overview
Explore in AI Chat

Overview

APPS.ISC_FS_TASK_BAC_AGE_ETL_PKG is an Oracle E-Business Suite PL/SQL package that belongs to the Oracle Supply Chain (ISC) application family, specifically the Fusion Service / task backlog aging subsystem. Its core purpose is to perform extract-transform-load (ETL) operations that populate the aging data structures used by the Supply Chain task backlog aging report. The package is delivered in the VALID state in the APPS schema and carries an API classification of OTHER, indicating that it is an internal implementation package rather than a public, customer-facing API. It supports the ISC_FS_TASK_BAC_AGING_RPT_PKG, which consumes the data this package loads, and the dependency metadata confirms that ISC_FS_TASK_BAC_AGING_RPT_PKG references ISC_FS_TASK_BAC_AGE_ETL_PKG. The package operates against time-dimension tables in the FII (Financial Intelligence / time dimension) schema and against two descriptive flexfield/table-based aging configuration tables, enabling the aging report to bucket task backlog by period, week, quarter, and year.

Key Procedures and Functions

The package exposes three documented program units:

  • INITIAL_LOAD — Performs the full or initial population of the aging ETL data set. It establishes the baseline aging extract by loading the complete set of task backlog records for the reporting universe, typically executed once during implementation or when the aging data store is rebuilt.
  • INCREMENTAL_LOAD — Performs a delta load for subsequent runs. It refreshes only the records that have changed since the previous execution, allowing the aging data to be kept current without re-processing the full data set.
  • GET_PERIOD_BIT_TBL — Returns a period bit-table collection used to map or flag the reporting periods applicable to the aging calculation. This supports the period-bucketing logic consumed by the aging report package.

Tables Accessed

The package reads from and/or writes to the following documented tables and views (accessed through APPS synonyms):

The time-dimension tables drive the aging buckets, while the ISC_FS_TASK_BAC_DATES_C/F tables hold the configured date logic and the loaded aging results respectively.

Usage Notes

ISC_FS_TASK_BAC_AGE_ETL_PKG is not intended for direct end-user invocation. It is typically called by the associated concurrent program that refreshes the task backlog aging report, or programmatically by APPS.ISC_FS_TASK_BAC_AGING_RPT_PKG when the report requires current data. The INITIAL_LOAD procedure is run during setup or a full rebuild, while INCREMENTAL_LOAD is scheduled for recurring refreshes. Because the package is classified as an internal implementation unit and is referenced only by ISC_FS_TASK_BAC_AGING_RPT_PKG (one dependent package), customizations should avoid modifying it directly; instead, extensions should wrap or copy the logic, or invoke it only through the standard report/concurrent program flow to preserve supportability.