Search Results cn_obj_columns_v




Overview
Explore in AI Chat

Overview

APPS.CNDISL_SLICE_DEF_DIM_PKG is a PL/SQL package body belonging to the Oracle EBS module suite commonly catalogued under the "CNDISL" prefix group, which relates to the data‑integration and slice‑definition objects used by historical Oracle data‑transformation utilities. In the Oracle EBS 12.1.1 and 12.2.2 file systems the package is delivered as source file cndislbb.pls, with an original header revision of 115.1 dated July 1999. That timestamp places the object in the Wave 11i lineage of Oracle applications files, carried forward unchanged into the 12.x releases.

The package's stated purpose is to manage the definition of dimensional columns used within slices. A slice is a tabular mapping that extracts a subset of columns from a source object and materialises them into a destination table, often a temporary (tmp) or report‑update (rup) table. CNDISL_SLICE_DEF_DIM_PKG provides the low‑level plumbing — generating surrogate identifiers, resolving human‑readable column and dimension names, inserting the slice definition row, and removing definitions that are no longer required. It therefore sits beneath the slice‑definition user interface rather than exposing an end‑user API.

Key Procedures and Functions

  • DEFAULT_ROWS — Produces the default identifier values required when building a slice definition. It obtains sequences for the column map and destination object identifiers for the primary, temporary, and report‑update legs of the slice, returning these through output parameters so the caller can proceed to populate fields.
  • POPULATE_FIELDS — Resolves descriptive metadata for the slice. Given a source column identifier it fetches the column name and the associated dimension name, and given a destination column identifier it fetches the destination column name. This supplies the labels shown in the slice‑definition form and stored alongside the mapping.
  • INSERT_ROW — Writes a single slice‑definition row into the column‑map table. It accepts the source, destination, temporary, and report‑update identifiers plus the group‑by flag, repository identifier, and table identifiers, providing the caller with a complete mapping record.
  • DELETE_ROW — Removes a previously defined slice‑definition row, used when a slice is redefined or discarded.

All four procedures are classified as OTHER rather than as a public API, indicating internal or utility status rather than a supported integration contract.

Tables Accessed

  • CN_COLUMN_MAPS — The principal store of column mappings. INSERT_ROW writes here and DELETE_ROW deletes from here.
  • CN_COLUMN_MAPS_S — The sequence generating surrogate keys for column‑map identifiers, consumed by DEFAULT_ROWS.
  • CN_OBJECTS_S — The sequence for destination object identifiers, also consumed by DEFAULT_ROWS.
  • CN_OBJECTS and CN_DIMENSIONS — Joined through the view CN_OBJ_COLUMNS_V to resolve column names and dimension names in POPULATE_FIELDS.
  • DUAL — Used for the sequence selection in DEFAULT_ROWS.

Usage Notes

The package is referenced by zero other packages in the documented ETRM metadata, which confirms it is invoked directly by the slice‑definition user interface or by a concurrent program rather than being called from other PL/SQL units. Typical invocation sequence is DEFAULT_ROWS to seed identifiers, POPULATE_FIELDS to resolve names, INSERT_ROW to persist the definition, and DELETE_ROW during maintenance. No entry exists for the user‑searched term "data_scale" in the documented procedures; the term appears unrelated to this package's declared interface and should be sought elsewhere.