Search Results get_app_version




Overview
Explore in AI Chat

Overview

EDW_LOG is a utility logging and instrumentation package owned by APPS in the Oracle E-Business Suite. Its header identifies it as an Oracle Data Warehouse (EDW) shared logging source file, with a version constant referencing EDWSRLGS.pls version 115.8. The package is declared with AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the calling schema rather than the definer, which is typical for shared utility code invoked from many different product schemas.

The package's business role is to provide a centralized mechanism for diagnostic output, severity-tagged messages, and FND logging integration for EDW-related concurrent processing and batch programs. It is a foundational infrastructure unit rather than a business-process package: it does not manipulate transactional data, and instead supplies tracing, timing, and list-parsing helpers used by other EDW components. Its breadth of reuse is reflected in the documentation, which records that EDW_LOG is referenced by 111 other packages.

Key Procedures and Functions

The documented API surface contains ten procedures and functions:

  • PUT_NAMES — writes named output to log and output files at a specified directory, supporting the packaging and delivery of log content produced by batch runs.
  • DURATION — a function that formats a numeric duration value into a human-readable string, used for elapsed-time reporting in program logs.
  • DEBUG_LINE — emits a diagnostic line, gated by the package-level debug flag.
  • PUT_LINE — the core text output procedure; documented in both a single-argument form and an overload accepting a severity number.
  • PUT_FND_LOG — routes a message and severity level into the Oracle Application Object Library FND logging framework, so output appears in standard EBS log destinations.
  • IS_ORACLE_APPS_GT_1159 — a function that determines whether the runtime Applications version is later than 11.5.9, returning a boolean used to branch behavior between release levels.
  • GET_APP_VERSION — a function returning the current Applications version string.
  • PARSE_NAMES — the procedure of interest in the originating search; it tokenizes a delimited input list into a PL/SQL associative array of names and returns the count of parsed elements, along with a boolean success indicator.
  • PUT_CONC_LOG — writes text to the concurrent program log file associated with the current request.

Tables Accessed

The only documented table reference is FND_PRODUCT_GROUPS, accessed through an APPS synonym. This table stores the installed Applications release and product group information, and it is read by GET_APP_VERSION and IS_ORACLE_APPS_GT_1159 to establish the runtime version context. No other base tables are documented as accessed by this package, consistent with its role as a logging utility rather than a data-processing module.

Usage Notes

EDW_LOG is typically invoked from PL/SQL within EDW concurrent programs and batch packages, and from custom code requiring consistent log formatting. Callers use PUT_LINE, PUT_FND_LOG, and PUT_CONC_LOG to emit messages to the appropriate destination, DEBUG_LINE for conditional tracing, and DURATION for timing metrics. PARSE_NAMES is used where a comma- or character-separated parameter list must be decomposed into individual names. Because the package is AUTHID CURRENT_USER and version-aware, it is suitable for cross-release environments spanning 12.1.1 through 12.2.x.