Search Results reset_globals

Overview

FII_AR_UTIL is a utility package owned by the APPS schema within the Oracle E-Business Suite, classified in the ETRM repository as an API of type UTIL. It belongs to the Oracle Financial Intelligence (FII) family of components, which provide the analytical infrastructure behind the Receivables (AR) reporting and dashboard pages delivered through the BIS (Business Intelligence System) page framework. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the package owner, a standard convention for shared utility code that must respect caller-level security and synonym resolution.

The package functions as a global parameter container and query binder for FII Receivables performance pages. It holds a set of package-level global variables — including p_as_of_date, p_period_type, p_view_by, p_sgid, p_prod_cat, p_cust, p_curr, and p_record_type_id — that persist filter selections across a user's interaction with an FII AR page. These globals are initialized and refreshed through the package's procedures.

Key Procedures and Functions

• RESET_GLOBALS — Reinitializes the package-level global variables to their default state. This is the entry point most commonly invoked when an FII AR page is first loaded or when a user clears a prior filter selection, ensuring that stale values from a previous session or query execution do not contaminate subsequent results.
• GET_PARAMETERS — Accepts a BIS_PMV_PAGE_PARAMETER_TBL input table and populates the package globals from the page parameter collection supplied by the BIS page framework. It acts as the bridge between the page's runtime parameter values and the package's working variables.
• GET_LABEL — Returns a display label as a VARCHAR2 for a given sequence identifier, used to render localized or dynamically derived captions on FII AR pages.
• BIND_VARIABLE — Builds the dynamic SQL bind structure for FII AR queries. It accepts a SQL statement string and the page parameter table, and returns the bound SQL output together with a BIS_QUERY_ATTRIBUTES_TBL describing the query attributes. Optional inputs allow callers to pass a record type identifier, view-by value, and up to two additional FII-specific bind values.

Tables Accessed

• FII_TIME_ENT_PERIOD — Read to resolve the time-entered period dimension used by FII AR analytics, supporting period-type and as-of-date filtering driven by the package globals.
• FII_TIME_ENT_QTR — Read to resolve the quarter-level time-entered dimension, complementing the period table for quarter-based views.
• PLITBLM — The standard Oracle Applications time/period lookup table, accessed for calendar and period derivation logic.

Access is performed through APPS synonyms, consistent with the AUTHID CURRENT_USER declaration and standard EBS utility package design.

Usage Notes

FII_AR_UTIL is not intended for end-user or customer-named invocation. It is a supporting package for the FII Receivables performance pages, invoked by the BIS page execution engine and by at least one other documented package in the FII AR stack. In a typical page lifecycle, the controller invokes RESET_GLOBALS to establish a clean state, GET_PARAMETERS to load the user's filter selections, and BIND_VARIABLE to construct the bound data query, with GET_LABEL supplying presentation text. The header version 115.1 and the 2005 creation date indicate a long-stable interface retained through EBS 12.1.1 and 12.2.2. Customization should be avoided; extensions should instead wrap or call the documented procedures using the published signatures.