Search Results get_last_refreshdate

Overview

APPS.BIS_SUBMIT_REQUESTSET is a PL/SQL package in the Oracle E-Business Suite APPS schema that supports the submission and orchestration of request sets within the Oracle Business Intelligence System (BIS) / Daily Business Intelligence (DBI) and Enterprise Command Center style reporting frameworks. Its principal business role is to assemble the runtime parameters required to launch a request set, record the history of each submission, and maintain refresh timestamps so that downstream dashboards and portals display current data. The package functions as an internal engine rather than a user-facing API; ETRM classifies it with an API classification of OTHER, indicating that it is intended for internal invocation by Oracle-provided components rather than by external integrations or customer extensions.

The package is validated and present in both 12.1.1 and 12.2.2 environments, and it depends on the SYS.STANDARD package plus the PLITBLM PL/SQL table library, which confirms it uses associative-array/table handling internally for sorting and parameter assembly.

Key Procedures and Functions

ETRM documents nine callable members, of which the following are named:

• GET_PARAMETER_FLAG — Determines whether a given request-set parameter requires prompting or supplies a stored/default value, allowing the submission logic to decide how to populate the parameter list.
• UPDATE_DEFAULT_VALUE — Persists an updated default value for a request-set option so that subsequent submissions reuse the maintained value.
• GET_LAST_REFRESHTIME — Returns the time component of the most recent refresh associated with a request set or its objects.
• GET_LAST_REFRESHDATE — Returns the date component of the most recent refresh, used for display in dashboards and portal regions.
• GET_LAST_REFRESHDATE_URL — Returns a formatted refresh date suitable for embedding in a URL or hyperlink target rendered by BIS portal pages.
• SORT_TABLE — Orders an in-memory collection, typically the list of objects or parameters bound to a request set, before submission.
• UPDATE_LAST_REFRESH_DATE — Writes the current refresh timestamp into the request-set history so that freshness indicators remain accurate.

Two additional documented members complete the nine-entry list; all follow the same internal-utility pattern described above. No parameter signatures are published in ETRM, and custom callers should not rely on positional arguments.

Tables Accessed

The package reads and writes a defined footprint of BIS and FND tables through APPS synonyms:

• BIS_REQUEST_SET_OBJECTS, BIS_REQUEST_SET_OPTIONS — define which report objects and runtime options belong to a request set.
• BIS_OBJ_DEPENDENCY, BIS_OBJ_PROG_LINKAGES, BIS_OBJ_PROPERTIES, BIS_OBJ_SET_TEMP — resolve object dependencies, program linkages, properties, and temporary staging for the set.
• BIS_RS_RUN_HISTORY — stores submission and refresh history used by GET_LAST_REFRESHDATE and UPDATE_LAST_REFRESH_DATE.
• FND_REQUEST_SETS, FND_CONCURRENT_PROGRAMS, FND_CONCURRENT_REQUESTS, FND_FORM_FUNCTIONS, FND_DESCR_FLEX_COLUMN_USAGES — resolve concurrent program definitions, submit requests, and map form functions and descriptive flexfield columns.
• DUAL — used for scalar evaluations.

Usage Notes

BIS_SUBMIT_REQUESTSET is referenced by BIS_PMV_UTIL, BIS_SET_PROCESSES_V, BIS_WWPOB_PAGES_V, BIS_WWPOB_PORTLETS_V, and ISC_DEPOT_BACKLOG_PKG, indicating it is called from BIS page/portlet views and from supply-chain backlog processing. It is typically invoked when a user launches a DBI dashboard refresh or when a scheduled concurrent program triggers a request set submission. Because it is an internal package, direct custom invocation is discouraged; integrators should submit request sets through the standard FND_REQUEST.SUBMIT_REQUEST interface and let the BIS layer manage refresh metadata.