Search Results isc_depot_margin_etl_pkg




Overview
Explore in AI Chat

Overview

APPS.ISC_DEPOT_MARGIN_ETL_PKG is a PL/SQL package that belongs to the Oracle E-Business Suite depot repair and service costing subsystem, part of the Enterprise Asset Management and Depot Repair applications. Its principal business function is to extract, transform, and load (ETL) data required to compute depot repair margins — the difference between the charges billed to a customer for a repair order and the internal costs incurred to perform it. The package consolidates transactional data residing in depot repair, service, WIP, and HR tables into staging and fact tables (notably the ISC_DR_* family of tables) that support margin reporting and analysis.

The package is owned by the APPS schema and is currently marked VALID. It is classified as "OTHER" in the ETRM metadata, meaning it is a backend utility package rather than a formally published public API. It contains both a specification and a body. Beyond the standard SYS.STANDARD package, it has no documented external dependencies on other APPS packages, and it is referenced by 0 other packages within the EBS codebase.

Key Procedures and Functions

The package exposes four documented procedures, organized along two dimensions: data subject (charges versus costs) and load mode (initial versus incremental).

  • CHARGES_INITIAL_LOAD — Loads the full baseline of repair charge data into the staging structures used for margin computation. This procedure is intended to seed the fact tables for the first time or for a complete rebuild.
  • COSTS_INITIAL_LOAD — Performs the equivalent full load for repair cost data, populating the cost fact tables from the underlying depot repair and WIP sources.
  • CHARGES_INCR_LOAD — Handles incremental (delta) loads of charge records, capturing only new or changed charge transactions since the last successful load, so that routine runs avoid reprocessing the full data set.
  • COSTS_INCR_LOAD — Handles incremental loads of cost records, refreshing the cost facts with recent cost activity only.

No parameter lists are documented in the ETRM metadata, so call signatures should be confirmed against the package specification in the target instance before use.

Tables Accessed

The package reads from depot repair and service source tables and writes to the ISC margin staging and fact tables via APPS synonyms:

Usage Notes

Because this package has no inbound package dependencies and is classified as OTHER, it is typically invoked by concurrent programs or scheduled batch jobs rather than being called from EBS forms or from other PL/SQL packages. Standard operational practice is to execute the initial-load procedures once during implementation or following a data correction, and to schedule the incremental-load procedures on a recurring basis (for example, nightly) so that depot margin facts reflect current charge and cost activity. Custom code or reporting extracts in the APPS schema may reference the ISC_DR_* tables this package maintains, but should not call the package directly without validating the procedure signatures and load semantics in the target 12.1.1 or 12.2.2 environment.