Search Results analyze_objects




Overview
Explore in AI Chat

Overview

EDW_ANALYZE_OBJECT is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM taxonomy as OTHER. It belongs to the Enterprise Data Warehouse (EDW) / Oracle Warehouse Builder (OWB) integration layer, which is responsible for staging, collecting statistics, and analyzing dimensional and fact objects prior to loading the warehouse. The package body cited carries the header revision $Header: EDWANYZB.pls 115.6 2003/11/06, indicating it is a long-standing component present in both EBS 12.1.1 and 12.2.2.

The central purpose of EDW_ANALYZE_OBJECT is to drive collection and analysis of dimension and fact definitions. It wraps calls to EDW_OWB_COLLECTION_UTIL, initializes the collection context with the identifier 'ANALYZE_OBJECTS' and the source tag 'bis.edw.analyze_object', and exposes two public entry points — Analyze_Dimension and Analyze_Fact — that return a status code and a message buffer to the caller.

Key Procedures and Functions

  • ANALYZE_DIMENSION — Public procedure that resolves a dimension by name and triggers its analysis according to the supplied mode.
  • ANALYZE_FACT — Public procedure that resolves a fact by name and triggers its analysis according to the supplied mode.
  • GET_DIMS — Retrieves the set of dimension definitions to be processed.
  • GET_FACTS — Retrieves the set of fact definitions to be processed.
  • ANALYZE_DIMS — Performs the core dimension analysis logic.
  • ANALYZE_DIMS_LSTG — Performs dimension analysis restricted to the listing (staging) scope.
  • ANALYZE_FACTS — Performs the core fact analysis logic.
  • ANALYZE_FACTS_FSTG — Performs fact analysis restricted to the staging scope.
  • ANALYZE_TABLE — Executes analysis for an individual underlying table.
  • INIT_ALL — Initializes internal package state before each execution.
  • GET_TIME — Supplies the timestamp used for logging and status reporting.
  • WRITE_TO_LOG_FILE / WRITE_TO_LOG_FILE_N — Append messages to the package log, with the _N variant accepting a message argument.
  • WRITE_TO_OUT_FILE / WRITE_TO_OUT_FILE_N — Write status output to the designated out file, with the _N variant taking a message argument.

The package global g_status_message is central to error handling: it is populated on failure and returned through the Errbuf output parameter, accompanied by Retcode set to '2'.

Tables Accessed

The ETRM metadata for this object records no direct table references through APPS synonyms. The package operates against collection and metadata structures managed indirectly through EDW_OWB_COLLECTION_UTIL and the EDW/OWB repository rather than by direct DML against application base tables.

Usage Notes

EDW_ANALYZE_OBJECT is typically invoked from concurrent programs, OWB collection jobs, or custom PL/SQL that wraps the analysis of warehouse dimensions and facts. Callers supply a dimension or fact name plus a mode value; a null mode defaults to 0 (full analysis), while mode 1 restricts processing to staging/listing scope for facts and dimensions respectively. On failure, the caller receives Retcode '2' and g_status_message text suitable for the concurrent manager log or an out file. The package is not referenced by any other APPS package, so it is intended as a top-level entry point rather than a shared utility dependency.