Search Results retrieve_measure_dim_values

Overview

The APPS.BIS_TARGET_PVT package is a private PL/SQL API within the Oracle E-Business Suite Business Intelligence System (BIS) product family, commonly associated with the Daily Business Intelligence (DBI) and Performance Management applications. It serves as the internal implementation layer supporting the public target management API exposed by BIS_TARGET_PUB. Targets in this context represent measurable business objectives — such as revenue, cost, or quantity goals — defined against specific dimensions (organization, time period, product, or customer hierarchy levels) and assigned to individual owners or responsibilities.

The package encapsulates the private business logic that governs the lifecycle of target records. Because it is classified as a PVT (private) API, it is not intended for direct invocation by external or customer-written code; instead, it supplies the underlying routines consumed by the public wrapper packages and by other internal BIS components that manipulate target definitions, target values, and their associated dimension-level qualifiers.

Key Procedures and Functions

The package exposes twenty-three documented procedures and functions, which fall into several functional groupings:

• Lifecycle management: CREATE_TARGET, RETRIEVE_TARGET, RETRIEVE_TARGETS, UPDATE_TARGET, and DELETE_TARGET provide the core create, read, update, and delete operations for target records.
• Validation and conversion: VALIDATE_TARGET enforces business rules prior to persistence, while VALUE_ID_CONVERSION translates dimension-level identifiers between internal and external representations.
• Ownership and metadata retrieval: RETRIEVE_TARGET_OWNERS, RETRIEVE_LAST_UPDATE_DATE, GETID, and LOCK_RECORD support owner lookup, concurrency control, and record identification.
• Dimension and level retrieval: RETRIEVE_MEASURE_DIM_VALUES, RETRIEVE_TIME_LEVEL_VALUE, and RETRIEVE_ORG_LEVEL_VALUE resolve the specific dimension member values that qualify a given target.
• Dynamic SQL and UI support: GETQUERYSTATEMENT, GETVIEWNAMES, GETCOMPUTINGUSERFUNCTIONNAME, GETNOTIFYRESPONSIBILITYNAME, and GETSETOFBOOKID supply runtime query text, view names, user function, responsibility, and ledger context used by the reporting and region-rendering layers.
• Generic accessor: GET_TARGET provides an alternate retrieval entry point.

Tables Accessed

The package reads and writes target data through APPS synonyms, principally BIS_TARGET_VALUES (the primary target values table) and BIS_TARGET_VALUES_S (its corresponding sequence or setup companion). It references FND_FORM_FUNCTIONS and FND_FORM_FUNCTIONS_TL for function name and translated description lookups, FND_USER for owner identification, and it leverages DBMS_SQL, HTP, and PLITBLM for dynamic SQL execution, HTML generation, and PL/SQL table manipulation respectively.

Usage Notes

BIS_TARGET_PVT is referenced by ten other BIS packages, including BIS_TARGET_PUB, BIS_COMPUTED_ACTUAL_PVT, BIS_LOV_PUB, BIS_INDICATOR_REGION_UI_PVT, BIS_PMF_PVT, and BIS_TARGET_LEVEL_PVT. It depends on BIS_DIMENSION_LEVEL_PUB, BIS_DIM_LEVEL_VALUE_PUB, BIS_TARGET_LEVEL_PUB, BIS_TARGET_PUB, BIS_UTILITIES_PUB, and FND_API.

In practice, this package is invoked indirectly — through the public BIS_TARGET_PUB API during target definition in the DBI/Performance Management setup UI, during concurrent program runs that compute and compare actuals against targets, and when list-of-values and indicator regions are rendered. Direct calls from customer extensions are discouraged, as the private API signature may change between releases; customizations should route through BIS_TARGET_PUB instead.