Search Results fii_ar_util




Overview
Explore in AI Chat

Overview

FII_AR_UTIL is a utility package body owned by the APPS schema in Oracle E-Business Suite. It belongs to the Financial Intelligence for Receivables (FII AR) product family, a component of the EBS analytics and reporting infrastructure that surfaces receivables performance data through the Oracle Business Intelligence (OBI) embedded reporting framework. The package is classified as a UTIL (utility) object, meaning it does not implement core business transactions but instead provides shared helper logic consumed by other FII packages and by the underlying page and parameter management layers.

The package's principal business role is to support the rendering of Receivables-related dashboard pages by normalizing inbound page parameters, resolving display labels, and assembling bind variable collections used in dynamic query execution. Its dependencies on BIS_PMV_PARAMETERS_PUB, BIS_PMV_PAGE_PARAMETER_REC, and BIS_PMV_PAGE_PARAMETER_TBL confirm that it operates within the Page Metadata Viewer (PMV) framework, which governs how OBI/EBS dashboard regions receive their runtime inputs. The dependency on FII_TIME_API and the FII_TIME_ENT_PERIOD and FII_TIME_ENT_QTR entities further indicates a role in temporal period and quarter resolution for receivables metrics.

The package body is documented as VALID and is not referenced by any database object, establishing it as a top-level library invoked directly by forms, concurrent programs, or report logic rather than being called from within other PL/SQL programs.

Key Procedures and Functions

The ETRM documentation lists four procedures and functions within APPS.FII_AR_UTIL. Their names describe their purposes as follows:

  • RESET_GLOBALS — Reinitializes package-level global variables and state so that a fresh invocation of the util package begins without residuals from a prior call within the same session. This is typically invoked at the start of a dashboard or page processing cycle to guarantee deterministic behavior in a shared session.
  • GET_PARAMETERS — Retrieves and consolidates the parameter values required for a Receivables dashboard page, drawing on the PMV parameter structures. It serves as the entry point for marshalling user- or region-supplied inputs into the form expected by downstream query generation.
  • GET_LABEL — Resolves a display label, presumably using message lookup facilities (FND_MESSAGE). This supports internationalized and consistent labeling of columns, parameters, or dashboard elements.
  • BIND_VARIABLE — Constructs or registers a bind variable, enabling dynamic SQL queries associated with dashboard regions to be executed with well-formed bind arrays.

Tables Accessed

The package accesses the following underlying entities, exposed to APPS through synonyms:

  • FII_TIME_ENT_PERIOD — Stores period-level time entity definitions for the FII time dimension. The package reads this to resolve the period context applicable to a receivables query.
  • FII_TIME_ENT_QTR — Stores quarter-level time entity definitions, read for quarter-based aggregation and filtering.
  • PLITBLM — The PL/SQL internal table type used within the package; documented here as a referenced object rather than as a persistent table. It indicates the package leverages associative or indexed table structures for parameter and bind collections.

In addition, the package references FND_MESSAGE for label lookup and the BIS_PMV_* structures for page and parameter metadata.

Usage Notes

FII_AR_UTIL is not referenced by any database object, so invocation is direct. Typical callers include Oracle Forms-based Receivables analytics pages, concurrent programs that render FII dashboards, and custom extensions that participate in the PMV reporting framework. A common invocation pattern is to call RESET_GLOBALS, followed by GET_PARAMETERS to populate the parameter table, GET_LABEL to resolve display text, and BIND_VARIABLE to prepare dynamic query bindings. The dependency on FII_TIME_API means callers should ensure the time entities are populated and current before invoking the util routines, otherwise period or quarter resolution may fail. Because the package maintains session-level globals, care should be taken in pooled or long-lived sessions to invoke RESET_GLOBALS between logical transactions.