Search Results write_to_out_file

Overview

The APPS.EDW_ANALYZE_OBJECT package is a PL/SQL utility within the Oracle E-Business Suite Enterprise Data Warehouse (EDW) and Oracle Warehouse Builder (OWB) integration layer. It provides a programmatic and concurrent-program-driven mechanism for gathering optimizer statistics on dimension and fact objects that populate the EDW staging and target schemas. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer. It operates on Oracle 12.1.1 and 12.2.2 environments, and its header identifies it as a non-shipped (NOSHIP) internal component maintained by Oracle development (revision 115.5, dated 2002).

The package is not a business transaction processor. Its purpose is administrative: it enumerates dimension and fact objects, drives statistics analysis against them, and routes diagnostic output to log files and out files. It maintains a set of global state variables — including dimension and fact collections (based on EDW_OWB_COLLECTION_UTIL.varcharTableType), counters, parallel degree, status flag, status message, and execution mode — which coordinate multi-object analysis runs and support both single-object and batch modes of operation.

Key Procedures and Functions

The package exposes seventeen documented procedures and functions. The two primary entry points are ANALYZE_DIMENSION and ANALYZE_FACT, both of which accept the standard concurrent program Errbuf and Retcode output parameters, an object name, and a mode indicator. These are designed to be invoked as concurrent programs.

• ANALYZE_DIMENSION / ANALYZE_FACT — Single-object analysis entry points for a named dimension or fact.
• ANALYZE_DIMS / ANALYZE_FACTS — Batch entry points that analyze all collected dimensions or facts.
• GET_DIMS / GET_FACTS — Populate the internal collections with the dimension or fact objects eligible for analysis.
• ANALYZE_TABLE — Performs the underlying statistics analysis for a specified object.
• INIT_ALL — Initializes the package's global state before an analysis run.
• GET_TIME — Returns a timestamp string, used to stamp log and output records.
• WRITE_TO_LOG_FILE / WRITE_TO_LOG_FILE_N — Write formatted messages, with and without a trailing newline, to the log file.
• WRITE_TO_OUT_FILE / WRITE_TO_OUT_FILE_N — Write messages, with and without a trailing newline, to the out file. The WRITE_TO_OUT_FILE procedure is the object referenced in the user's search and is the primary output-routing primitive for concurrent program output.
• ANALYZE_DIMS_LSTG / ANALYZE_FACTS_FSTG — Specialized analysis routines for staging objects (dimension listing staging and fact staging).

Tables Accessed

The ETRM metadata records no directly referenced base tables via APPS synonyms for this package. Its data interaction is confined to the objects named by the caller — dimension and fact tables, including staging variants — against which statistics are gathered. The collection types used internally are supplied by EDW_OWB_COLLECTION_UTIL.varcharTableType, indicating an in-memory, PL/SQL-table-driven approach rather than direct SQL access to EDW metadata tables. The package is not referenced by any other package, confirming it is a top-level utility.

Usage Notes

Because ANALYZE_DIMENSION and ANALYZE_FACT use the Errbuf/Retcode concurrent program signature, this package is most commonly registered and invoked as a concurrent program from the EDW or OWB administrator responsibility, typically after warehouse loads to refresh optimizer statistics. The AUTHID CURRENT_USER declaration allows it to be run directly by the schema owning the target objects. Custom code can call the boolean-returning functions (such as analyze_dimension, analyze_dims, analyze_fact, analyze_facts) for finer control, while WRITE_TO_OUT_FILE and WRITE_TO_OUT_FILE_N provide consistent message routing to concurrent request output. The global status variables and INIT_ALL should always be invoked before batch analysis to guarantee correct state.