Search Results edw_log




Overview
Explore in AI Chat

Overview

EDW_LOG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is classified under the API taxonomy as OTHER, indicating it is not a public business API but rather an internal utility package. Its documented name and dependency set establish its purpose unambiguously: EDW_LOG provides a centralized logging and diagnostic facility used across the E-Business Suite code base to emit runtime messages to the concurrent manager log, the Oracle FND logging framework, and derived timing information.

The package is positioned as a shared infrastructure component rather than application-specific logic. The ETRM dependency report shows it references FND_FILE, FND_LOG, FND_PRODUCT_GROUPS, FND_PROFILE, and the SYS.STANDARD package, while it is itself referenced by 111 other database objects. That fan-in count confirms the package is a widely reused logging entry point invoked by concurrent programs, batch jobs, and other PL/SQL units throughout the application tier.

Key Procedures and Functions

The documented interface exposes ten procedures and functions, several of which are internal helpers:

  • PUT_LINE — Writes a formatted message line to the concurrent program output, serving as the primary general-purpose logging entry point.
  • PUT_CONC_LOG — Routes a message specifically to the concurrent manager log file, typically used from concurrent program execution paths.
  • PUT_FND_LOG — Routes a message into the Oracle FND_LOG framework so entries are captured in the standard application log repository.
  • DEBUG_LINE — Emits a debug-level message, intended for verbose diagnostics that may be suppressed in normal production execution.
  • DURATION — Computes and reports elapsed time between execution points, supporting performance instrumentation of long-running routines.
  • GET_APP_VERSION — Returns the application version, allowing log output to be stamped with the environment it originated from.
  • IS_ORACLE_APPS_GT_1159 — Determines whether the runtime is an Oracle Applications release greater than 11.5.9, enabling version-conditional logging behavior.
  • PUT_NAMES — Emits a formatted presentation of name/value pairs for logging structured context.
  • PARSE_NAMES — Parses a name/value string into its component parts for downstream formatting or logging.

No parameter signatures are documented in the ETRM metadata, and none should be assumed.

Tables Accessed

Only one table is documented as referenced through APPS synonyms: FND_PRODUCT_GROUPS. The package reads this table to determine application release and product installation information, which underpins procedures such as GET_APP_VERSION and IS_ORACLE_APPS_GT_1159. In addition, the package draws on profile option values through FND_PROFILE and writes to the concurrent manager and FND logging facilities through FND_FILE and FND_LOG respectively. No direct write operations to application data tables are documented.

Usage Notes

EDW_LOG is normally invoked implicitly rather than directly. The 111 objects that reference it include concurrent programs and batch PL/SQL units that call its logging procedures to record progress, errors, and timing metrics during execution. Because it transparently selects the appropriate destination — concurrent log, FND log, or debug stream — developers use it to obtain consistent diagnostics without coding destination-specific logic. Direct invocation from custom code is possible and supported by the documented procedure set, but callers should respect the version-conditional behavior implied by IS_ORACLE_APPS_GT_1159. The package is marked VALID in the ETRM registry, indicating it is compiled and operational in the certified 12.1.1 and 12.2.2 environments.