Search Results decide_run_map_err




Overview
Explore in AI Chat

Overview

DDR_BASE_UTIL_PKG is a utility package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the ETRM (Electronic Technical Reference Manual) family of database objects that support the Oracle Demand Planning and Demand Signal Repository (DSR) data collection infrastructure. The package provides a centralized library of helper functions used by the DDR (Demand Driven Replenishment / Demand Signal Repository) staging and interface programs that load, deduplicate, and stage retail, manufacturing, and syndicated demand data prior to its consumption by planning engines.

The primary business function of DDR_BASE_UTIL_PKG is to encapsulate the decision logic that governs whether a mapping or staging run should execute, how duplicate detection should be performed, and which run type or discovery mode applies to a given load cycle. By centralizing these decisions, the package ensures consistent behavior across the many DDR interface and staging programs that share the same data load patterns.

Key Procedures and Functions

The documented API classification is OTHER, exposing 26 procedures and functions. Notable entries include:

  • DECIDE_RUN_MAP_ERR — Returns a numeric status indicating whether a mapping run encountered errors for a given map name and staging area. This is the function referenced by the search term decide_run_map_err and is commonly queried to gate downstream processing when a prior mapping load has failed.
  • DECIDE_DEDUP_CHK — Determines whether duplicate checking should be performed for the current load context.
  • DECIDE_DISCOVER_MODE — Returns the discovery mode applicable to the current run, controlling how new items or entities are identified.
  • DECIDE_RUN_TYP — Returns the run type classification used to route processing logic.
  • DECIDE_SF_MAP — Determines the appropriate store-format or source mapping to apply.
  • DECIDE_RUN_CNT_STG — Returns a count from the staging area for a given map, used for volume-based decisions.
  • DECIDE_RUN_MAP — Determines whether a specific map should run.
  • A family of duplicate-detection functions — RTL_INV_ITEM_DUPS_FNC, PRMTN_PLN_DUPS_FNC, RTL_ORDR_ITEM_DUPS_FNC, RTL_SHIP_ITEM_DUPS_FNC, RTL_SL_RTN_DUPS_FNC, SLS_FRCST_ITEM_DUPS_FNC, and their _S_FNC variants — detect duplicate records within retail inventory, promotion plan, retail order, retail shipment, retail sales return, sales forecast, syndicated consumption, and manufacturing shipment datasets respectively.
  • TRUNC_TBLE_PUB — A public procedure that truncates a named table, typically used to clear staging tables between runs.

Tables Accessed

The package reads and writes staging (DDR_E_*) and interface (DDR_I_*) tables via APPS synonyms, including DDR_E_RTL_INV_ITEM, DDR_E_PRMTN_PLN, DDR_E_RTL_ORDR_ITEM, DDR_E_RTL_SHIP_ITEM, DDR_E_RTL_SL_RTN_ITEM, DDR_E_SLS_FRCST_ITEM, DDR_E_SYND_CNSMPTN_DATA, DDR_E_MFG_SHIP_ITEM, and their DDR_I_* interface counterparts. These tables hold pre-validated demand signal records awaiting deduplication and staging into planning tables.

Usage Notes

DDR_BASE_UTIL_PKG is invoked internally by DDR staging and mapping concurrent programs rather than directly by end users. The metadata records no dependent packages (referenced by 0 other packages), indicating it is a leaf utility. Custom code extending ETRM data loads may call DECIDE_RUN_MAP_ERR and TRUNC_TBLE_PUB directly, but standard behavior is driven through the packaged concurrent programs.