Search Results bis_target_pvt




Overview
Explore in AI Chat

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:

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.