Search Results initialize_for_ac

Overview

ZPB_AW is a PL/SQL package owned by the APPS schema that provides the integration layer between Oracle E-Business Suite and the embedded Oracle OLAP Analytic Workspace (AW) engine. Its principal business function is to expose the OLAP command interpreter to EBS application logic, allowing Advanced Planning, demand planning, and other analytic components to execute AW commands, evaluate expressions, and retrieve workspace metadata directly from PL/SQL. The package is registered in ETRM with an API classification of OTHER and is referenced by 27 other packages, indicating that it serves as a foundational utility rather than a directly user-facing module.

The package wraps DBMS_AW and DBMS_LOB, insulating callers from low-level OLAP behaviors and known engine defects. Version history in the source header ($Header: zpbaw.pls 120.5 2007/12/04) shows it has been maintained across multiple EBS releases, including 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented interface exposes 17 procedures and functions:

• EXECUTE — Passes an AW command to DBMS_AW for execution without parsing or returning output.
• INTERP — Deprecated wrapper around the AW that parses command output; superseded by EVAL_TEXT and EVAL_NUMBER.
• INTERPBOOL — Executes an AW command expecting a boolean result and converts it under the NLS_LANGUAGE setting (Bug 4058390).
• EVAL_TEXT — Improved replacement for INTERP that avoids numerous OLAP defects; no "show" prefix is required, and it returns NULL when the result is NA.
• EVAL_NUMBER — Numeric counterpart to EVAL_TEXT for evaluating AW expressions that yield numbers.
• DETACH_ALL and CLEAN_WORKSPACE — Manage workspace session state and release resources.
• GET_ANNOTATION_AW, GET_CODE_AW, GET_PERSONAL_AW, GET_SHARED_AW — Retrieve specific named analytic workspaces by category.
• GET_SCHEMA, GET_AW_SHORT_NAME, GET_AW_TINY_NAME — Return naming and schema metadata required to construct AW references.
• INITIALIZE, INITIALIZE_FOR_AC, INITIALIZE_USER — Establish the OLAP session context for general, analysis-cycle, and user-specific scenarios.

Tables Accessed

The package reads through APPS synonyms to resolve application and user context, and to identify the correct analytic workspace configuration:

• FND_USER — Resolves the current EBS user for personal workspace initialization.
• ZPB_USERS — Maps EBS users to their OLAP workspace identities.
• ZPB_BUSINESS_AREAS — Identifies the business area context for the workspace.
• ZPB_ANALYSIS_CYCLES — Supplies analysis cycle definitions used by INITIALIZE_FOR_AC.
• FND_APPLICATION, FND_ORACLE_USERID, FND_PRODUCT_INSTALLATIONS — Provide application registration, schema credentials, and product installation data required to derive the correct AW schema and naming.

DBMS_AW and DBMS_LOB are invoked internally to execute commands and manipulate large objects.

Usage Notes

ZPB_AW is an internal infrastructure package invoked by other PL/SQL units rather than through a dedicated form or concurrent program. Customizations and extensions that need to read or write OLAP data should call EVAL_TEXT and EVAL_NUMBER instead of the deprecated INTERP. A typical session flow is INITIALIZE, one or more evaluation or EXECUTE calls, followed by DETACH_ALL or CLEAN_WORKSPACE to free engine resources. Because the package depends on NLS settings for boolean conversion and on FND application metadata for schema resolution, it should be invoked from within an initialized EBS session rather than from external tools.