Search Results get_start_end_date




Overview
Explore in AI Chat

Overview

BIS_POSTACTUAL is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Balanced Scorecard and KPI framework delivered through the Configurable Homepage. Its primary responsibility is to persist actual performance values into the BIS_ACTUAL_VALUES table so that scorecard indicators, targets, and period-based measurements can be compared and displayed to end users. The package is classified as "OTHER" in ETRM rather than as a public API, indicating it is intended primarily for internal consumption by the Balanced Scorecard engine and adjacent components rather than as a formally supported integration interface. The header comment references source file BISPACTS.pls (version 120.1), confirming the module ships unchanged across the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

ETRM documents two public program units and includes several commented-out declarations that reflect the package's historical scope.

  • POST_ACTUAL — Inserts a single row into BIS_ACTUAL_VALUES. It accepts a target level short name, an organization identifier, the actual measured value, an optional timestamp, and up to five optional dimension level values. This is the workhorse routine used to load KPI results for a given organization and target level.
  • GET_START_END_DATE — Returns the most recent start and end date pair for a given period type within a specified calendar. If the calendar or period type is invalid, the function returns the current system date for both boundaries; if no data is found it returns an empty string. The return format is a concatenated string using a '+' delimiter.

Commented-out declarations include GET_TRGT_LEVEL_ORGS, GET_SOB, and GET_INDICATOR_CALENDAR, which correspond directly to the user's search term "get_sob." The Get_SOB routine was designed to retrieve the set of books identifier for a given organization, returning the SOB and a message. Its removal indicates that set-of-books resolution is now handled elsewhere in the Balanced Scorecard stack, but the historical footprint remains visible in the source.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

  • BIS_ACTUAL_VALUES and BIS_ACTUAL_VALUES_S — the primary and secondary actual-value stores receiving insert operations from POST_ACTUAL.
  • BIS_TARGET_LEVELS — supplies target level definitions referenced by the short name parameter.
  • GL_PERIODS — provides calendar and period boundaries used by GET_START_END_DATE.
  • HR_ALL_ORGANIZATION_UNITS — resolves organization identifiers used to segment KPI data.

Usage Notes

BIS_POSTACTUAL is typically invoked from Balanced Scorecard configuration flows, concurrent programs that refresh KPI actuals, and internal calls from other packages — ETRM records one dependent package. Direct invocation from custom code is discouraged because the module is not a supported public API; implementations that require set-of-books resolution should rely on current supported APIs rather than the deprecated Get_SOB interface referenced by legacy searches. The package remains consistent between EBS 12.1.1 and 12.2.2.