Search Results lock_level




Overview
Explore in AI Chat

Overview

The OLAPSYS.CWM2_OLAP_LEVEL package is a component of the Oracle OLAP metadata infrastructure shipped with the database and exposed within the Oracle E-Business Suite environment. It belongs to the OLAPSYS schema — the schema that owns the OLAP Catalog and the Common Warehouse Metamodel (CWM) objects used to describe analytical dimensions, hierarchies, and levels — and is classified under the ETRM API classification OTHER.

Its business function is to manage the lifecycle and definition of levels within an OLAP dimension. A level represents a logical grouping of members along a dimension hierarchy, such as Year, Quarter, or Month in a Time dimension, or Region and Country in a Geography dimension. This package provides the programmatic interface through which levels are created, renamed, annotated, attached to or detached from hierarchies, locked for concurrent access control, and ultimately dropped. The user search term create_level corresponds directly to the package's principal constructor procedure, Create_Level, which brings a new level definition into existence within a named dimension.

Key Procedures and Functions

The package exposes ten documented procedures, one of which — Create_Level — is the entry point for defining a level. The remainder support modification, hierarchy association, and removal:

  • CREATE_LEVEL — Creates a new level within a specified dimension, accepting descriptive attributes such as display name, plural name, short description, and description.
  • SET_LEVEL_NAME — Renames an existing level, replacing its internal level name with a new value.
  • SET_DISPLAY_NAME — Updates the human-readable display name of a level.
  • SET_PLURAL_NAME — Updates the plural form of the level name, used where multiple members are referenced.
  • SET_SHORT_DESCRIPTION — Updates a brief descriptive text for the level.
  • SET_DESCRIPTION — Updates the full descriptive text for the level.
  • ADD_LEVEL_TO_HIERARCHY — Attaches a child level to a parent level within a named hierarchy, establishing the level's position in the dimensional drill path.
  • REMOVE_LEVEL_FROM_HIERARCHY — Detaches a level from a hierarchy, breaking its parent-child association.
  • DROP_LEVEL — Removes a level definition from a dimension entirely.
  • LOCK_LEVEL — Acquires a lock on a level definition to serialize concurrent metadata changes.

Tables Accessed

The ETRM metadata for this object does not document the underlying base tables accessed through APPS synonyms. In the OLAP Catalog, level metadata is normally persisted in the OLAPSYS-maintained CWM2 metadata views and catalog tables — for example, the CWM2 level definition and dimension-member tables that store level names, descriptions, and hierarchy relationships. Custom EBS code should not address these tables directly; instead it should call the package procedures so that metadata integrity across dimensions and hierarchies is preserved.

Usage Notes

This package is not part of the standard EBS application form or concurrent program runtime; it is an OLAP metadata utility used primarily during analytical workspace and dimension-creation activities. It is typically invoked from custom PL/SQL scripts, SQL*Plus sessions, or third-party OLAP modeling tools that build or maintain OLAP dimensions against the OLAPSYS catalog. Executing procedures such as Create_Level, Add_Level_To_Hierarchy, and Drop_Level alters shared metadata and should be done under a controlled change process, ideally after invoking Lock_Level where concurrent definition is possible. ETRM records no other packages referencing this package, so callers are self-contained and should be validated in a non-production instance before promotion.