Results for “mproj_fields”

1 result




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.BSC_AOP_TPLATE package is a component of the Oracle Balanced Scorecard (BSC) application, which is part of the broader Enterprise Performance Foundation / E-Business Suite analytics stack. The package name reflects its role as an "Analysis Options Template" utility (AOP = Analysis Options, TPLATE = Template). Its principal business function is to programmatically create and configure the analysis option metadata that underpins Profit and Loss (P and L) key performance indicators (KPIs) within the Balanced Scorecard framework. Rather than requiring administrators to manually define every analysis option and its associated data relationships, this package provides a declarative, code-driven mechanism to generate that metadata.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer, and it exposes a custom exception, BSC_AOP_ERROR, used to signal failures during template generation. The source header (115.4, dated 2003/01/14) indicates a mature, stable component that has been in place across multiple EBS releases, including 12.1.1 and 12.2.2.

Key Procedures and Functions

  • Create_Analysis_Options — A function returning Boolean. Its documented purpose is to create the analysis options required for the Profit and Loss KPI. This is the entry point that initiates template generation for P and L analytical structures.
  • Create_Option_Relations — A function returning Boolean that accepts two numeric input parameters (x_num_of_options and x_num_of_data) representing the number of analysis options and the number of data fields, respectively. Its purpose is to configure the relationships between analysis options and their supporting data by populating the analysis option metadata tables and operation field tables listed in the package header (MPROJ_FIELDS, MSYS_UNIQUE_LIST_OF_VARS, MPROJ_DATA, MPROJ_DATA_LANGUAGE, and MPROJ_MPROJ_DATA_CALC).

Both functions were originally created on 02-APR-1999 by Alex Yang and subsequently modified by Henry Camacho on 12/21/1999 to conform to Model 4.0.

Tables Accessed

The ETRM metadata documents the following tables referenced through APPS synonyms:

  • BSC_SYS_DATASETS_B — Stores balanced scorecard system dataset base definitions; used to associate generated analysis options with their governing dataset.
  • BSC_SYS_DATASET_CALC — Holds calculation definitions tied to system datasets, supporting the computed measures that analysis options depend upon.
  • BSC_SYS_INIT — Initialization/seeding table for BSC system metadata, providing baseline configuration used during template creation.
  • BSC_SYS_MEASURES — Defines system measures; relevant because analysis options for a P and L KPI must resolve to concrete measures.
  • PLITBLM — A PL/SQL internal table (index-by table) type or structure supporting in-memory manipulation during option relation building.

These tables provide the metadata scaffolding into which the newly created analysis options and their relationships are written.

Usage Notes

This package is classified as API classification OTHER, indicating it is not a standard public business API but rather an internal utility invoked during Balanced Scorecard setup and configuration. It is typically executed through BSC administrative forms or initialization routines rather than by end users directly. The package is referenced by one other package, suggesting it forms part of a coordinated setup chain. Developers extending BSC functionality or performing custom P and L KPI configuration may call Create_Analysis_Options followed by Create_Option_Relations, checking the Boolean return value and handling BSC_AOP_ERROR on failure. Because it uses definer-independent (AUTHID CURRENT_USER) semantics, the calling schema must possess appropriate privileges on the underlying BSC metadata tables. In 12.1.1 and 12.2.2, the package remains a foundational, low-level template generator rather than an end-user facing interface.