Search Results trans_dt




Overview
Explore in AI Chat

Overview

APPS.DDR_BASE_UTIL_PKG is a utility package body within the Oracle E-Business Suite distributed as part of the Demand Driven Retail (DDR) data-loading and interface framework. Its principal business function is duplicate detection and de-duplication across the DDR staging and error interfaces. The DDR schema follows a consistent pattern in which inbound records are held in DDR_I_* interface tables, validated, and then either promoted to downstream tables or diverted to parallel DDR_E_* error tables with an error reason. This package centralizes the duplicate-detection logic that supports that pattern for a range of retail, order, shipment, forecast, promotion, and syndicated-consumption data streams.

The package is classified under ETRM as a non-API (OTHER) utility, owner APPS, and is referenced by zero other packages, indicating it is invoked directly rather than through a shared public API surface. The user search term "cnt_rows" reflects the common diagnostic pattern of querying DDR error and interface tables for row counts after a load run, and the procedures in this package are precisely the routines that generate those error-table rows.

Key Procedures and Functions

The documented interface exposes 26 procedures and functions, organized as paired _FNC and _S_FNC routines per data domain, plus several decision helpers.

Tables Accessed

All table references are made through APPS synonyms. The error tables written by the package are DDR_E_MFG_SHIP_ITEM, DDR_E_PRMTN_PLN, DDR_E_RTL_INV_ITEM, DDR_E_RTL_ORDR_ITEM, DDR_E_RTL_SHIP_ITEM, DDR_E_RTL_SL_RTN_ITEM, DDR_E_SLS_FRCST_ITEM, and DDR_E_SYND_CNSMPTN_DATA. The corresponding interface tables read and purged are DDR_I_MFG_SHIP_ITEM, DDR_I_PRMTN_PLN, DDR_I_RTL_INV_ITEM, DDR_I_RTL_ORDR_ITEM, DDR_I_RTL_SHIP_ITEM, DDR_I_RTL_SL_RTN_ITEM, and DDR_I_SLS_FRCST_ITEM. In the documented RTL_INV_ITEM_DUPS_FNC body, duplicates are identified with a GROUP BY and HAVING COUNT(*) > 1 over the composite business key of RTL_BSNS_UNIT_CD, TRANS_DT, GLBL_ITEM_ID, RTL_SKU_ITEM_NBR, GLBL_ITEM_ID_TYP, and INV_LOC_CD; matching rows are inserted into the error table and then deleted from the interface table, followed by an explicit COMMIT.

Usage Notes

DDR_BASE_UTIL_PKG is intended for internal use by the DDR load and validation framework rather than for direct invocation by application users. It is typically called from concurrent-program wrappers or from higher-level DDR orchestration objects that iterate interface staging data before promotion. Because the package is not referenced by any other documented package, implementations should treat it as a leaf utility. The DECIDE_* functions indicate that the package participates in run-time configuration decisions, allowing the same duplicate logic to be enabled or disabled according to load parameters. Custom code calling these routines directly should account for the COMMIT inside the duplicate routines and ensure that the DDR_LOAD_SEQ sequence is available. The package is compatible with Oracle EBS 12.1.1 and 12.2.2; its header indicates an original 2008 build with no recent version increments.