Search Results bis_target_values_s

Overview

APPS.BIS_TARGET_PVT is the private implementation package body for the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 Balanced Scorecard and Business Intelligence target management layer. Together with its public counterpart, BIS_TARGET_PUB, it encapsulates the server-side logic required to define, maintain, validate, and retrieve business targets that are assigned to specific dimension levels, measures, and time periods. In EBS, "targets" represent the planned or threshold values against which actual performance is compared within BIS (Business Intelligence System) scorecards and business plans.

The package follows the standard Oracle EBS API architecture: a public (PUB) package exposes the documented application programming interface, while the private (PVT) package, BIS_TARGET_PVT, contains the working logic. Because the package is declared VALID in the data dictionary, it has compiled successfully and is available to the runtime environment.

Key Procedures and Functions

The documented interface exposes 23 procedures and functions. The core CRUD set comprises CREATE_TARGET, UPDATE_TARGET, DELETE_TARGET, and VALIDATE_TARGET, which respectively insert a new target, modify an existing target, remove a target, and enforce business rules before persistence. Retrieval is handled by RETRIEVE_TARGET, RETRIEVE_TARGETS, and GET_TARGET, which return single records or sets of target rows for display or downstream processing. RETRIEVE_TARGET_OWNERS and RETRIEVE_LAST_UPDATE_DATE provide supplementary metadata about ownership and audit timestamps. LOCK_RECORD and GETID are concurrency and surrogate-key utilities used to serialize updates and resolve primary keys.

Additional routines support the resolution of dimensional context and presentation. VALUE_ID_CONVERSION, RETRIEVE_MEASURE_DIM_VALUES, RETRIEVE_TIME_LEVEL_VALUE, and RETRIEVE_ORG_LEVEL_VALUE translate between user-facing level values and their internal identifiers. GETQUERYSTATEMENT, GETVIEWNAMES, GETCOMPUTINGUSERFUNCTIONNAME, GETNOTIFYRESPONSIBILITYNAME, and GETSETOFBOOKID are helper functions that assemble dynamic SQL, resolve view names, resolve user and responsibility metadata, and determine the operating set of books. These helpers indicate that BIS_TARGET_PVT participates in generated or dynamic query construction rather than purely static DML.

Tables Accessed

The package reads and writes BIS_TARGET_VALUES, the base transactional table storing target values against measures and dimension levels. BIS_TARGET_VALUES_S is the corresponding sequence source used by GETID and VALUE_ID_CONVERSION to generate or resolve primary keys. The view-based objects BISBV_TARGETS, BISBV_TARGET_LEVELS, BISBV_DIMENSION_LEVELS, BISFV_TARGETS, and BIS_LEVELS_VL are referenced for querying target and dimension hierarchy data.

Supporting configuration and reference data include FND_FORM_FUNCTIONS and its TL/VL variants for function-level security, FND_USER for user identity, FND_GLOBAL for session context, and WF_ROLE_LOV_VL for role-based value lists. The presence of DBMS_SQL, HTP, and PLITBLM confirms dynamic SQL execution and HTML output generation, consistent with a web-enabled EBS module.

Usage Notes

BIS_TARGET_PVT is not intended to be called directly by end users or external integrations; customizations should invoke the public BIS_TARGET_PUB API instead. It is referenced by ten other packages, reflecting its role as a shared internal service. Typical invocation occurs through EBS forms and OAF-based pages, concurrent programs that generate scorecards or business plans, and the BIS_BUSINESS_PLAN and BIS_TARGET_LEVEL packages. Because it performs dynamic SQL and record locking, callers should ensure the correct FND_GLOBAL session context is initialized before invoking it.