Results for “set_echo_off”

3 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The OLAPSYS.CWM2_OLAP_MANAGER package body is part of the Oracle OLAP metadata management infrastructure shipped with the database, and it surfaces inside an Oracle E-Business Suite 12.1.1 or 12.2.2 environment through the OLAPSYS schema and the common OLAP API layer. Its principal business function is to orchestrate the metadata operations that underpin OLAP analytic workspaces, dimensions, cubes, and measures that EBS reporting components (for example, Oracle Business Intelligence or Discoverer against OLAP sources) rely upon. Because it is a package body without a documented PL/SQL specification of its own, its behavioural contract is defined by the underlying CWM2_OLAP_MANAGER package specification and by the OLAP metadata tables it manipulates.

The metadata describes a valid, self-contained object that references the OLAP manager table, the OLAP exceptions package, the OLAP utility package, the message row type, and a set of standard PL/SQL and database utilities. The user search term dbms_aw_lib is relevant here because SYS.DBMS_AW_LIB appears among the direct dependencies, confirming that this manager package operates alongside the Analytic Workspace (AW) library that handles the physical and logical OLAP objects.

Key Procedures and Functions

The documented API exposes nine procedures, all of which control diagnostic and logging behaviour rather than OLAP data itself:

  • SET_ECHO_ON — Enables echoing of package execution messages so that internal processing steps are visible during execution.
  • SET_ECHO_OFF — Disables the echo behaviour established by SET_ECHO_ON.
  • BEGIN_LOG — Initialises a logging session, opening the log context for subsequent messages.
  • END_LOG — Terminates the logging session and releases associated resources.
  • LOG_NOTE — Records an informational note into the active log, subject to the current echo and verbosity settings.
  • LOG_NOTE_FORCED — Writes a note unconditionally, overriding echo or verbosity suppression.
  • LOG_MESSAGE — Records a general log message, typically used for progress or status reporting.
  • LOG_MESSAGE_FORCED — Writes a general message unconditionally, bypassing normal filtering.
  • LOG_RAW_MESSAGES — Emits raw, unformatted messages, useful for capturing low-level output from dependent utilities.

These routines are the instrumentation layer for the OLAP manager; they do not create or modify metadata directly.

Tables Accessed

The dependency list names CWM2$OLAPMANAGERTABLE, which is the internal storage table where the manager package records its control and status information. The package also depends on CWM2_OLAP_EXCEPTIONS for error propagation and on CWM2_OLAP_UTILITY for shared helper logic. Tables referenced through APPS synonyms — DBMS_OUTPUT, PLITBLM, UTL_FILE, and UTL_RAW — are PL/SQL utility packages rather than business tables; they support output buffering, PL/SQL table manipulation, file writes, and binary conversions used when persisting or displaying log content.

Usage Notes

This package body is not intended for direct application invocation. It is referenced by 23 other database objects, indicating that it is invoked indirectly by higher-level OLAP metadata APIs that need consistent logging and exception handling. In an EBS 12.1.1 or 12.2.2 environment, administrators and developers typically encounter it only while diagnosing OLAP metadata errors, tracing DBMS_AW_LIB-related failures, or inspecting dependency chains during patching and upgrades. Because it is owned by OLAPSYS and marked VALID, it should not be modified; troubleshooting should focus on the caller, the manager table, and the AW library version in use.