Results for “drill_across”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.FII_AP_DRILL_ACROSS package body is a component of the Oracle E-Business Suite Financial Intelligence (FII) application, specifically within the Payables (AP) analytics domain. Its principal business function is to enable the "drill-across" navigation behavior found in Oracle Daily Business Intelligence (DBI) and FII dashboards. When a user viewing a summarized AP trend report selects a region, bar, or data point, the package constructs and dispatches a URL that opens a corresponding detail report filtered to the same context — the same operating unit, supplier, currency, and as-of date. This mechanism preserves report context across the transition from an aggregate summary to a transactional drill-down view, which is essential to the analytical workflow of the FII AP dashboard family. The FII_CURRENCIES parameter referenced in the user's search appears directly in the URL string assembled by this package, where it binds the currency selection to the target detail report.

Key Procedures and Functions

The package exposes a single documented procedure, DRILL_ACROSS. Its purpose is to translate the parameters of the originating summary report into the URL string required to launch the destination detail report. The procedure accepts a source report identifier, an operating unit, a supplier, a currency, an as-of date, a period, and a parameter-identifier flag. Based on the value of the source report parameter, the procedure branches into report-specific logic. For the FII_AP_HOLD_TREND source, it routes to the FII_AP_INV_ON_HOLD_DETAIL detail report. For the FII_AP_E_INV_ENT_DTL source (electronic invoice trend), it routes to the same-named detail report and additionally evaluates the period parameter through a CASE construct to select the appropriate time-dimension filter (period, year, quarter, or week).

In each branch the procedure assembles a URL string containing the function name, the operating unit mapped to FII_OPERATING_UNITS, the supplier mapped to POA_SUPPLIERS, and the currency mapped to FII_CURRENCIES, together with the report source and as-of date. The bisviewer_pub.showreport API is then invoked to display the report, passing the web user ID, session ID, and responsibility ID obtained through the icx_sec security package.

Tables Accessed

The ETRM metadata records no direct table references for this package. This is consistent with its design: the package does not query or write transactional AP tables. Instead, it relies on FII views and reporting objects accessed indirectly through the bisviewer_pub report engine and the icx_sec security package. All contextual data — operating unit, supplier, currency, and date — is passed through the procedure's parameters and embedded in the generated URL rather than read from the database by this package itself.

Usage Notes

FII_AP_DRILL_ACROSS is invoked from the FII AP dashboard reports when a user performs a drill-across action. It is not a concurrent program and is not intended for direct invocation by end users or custom code. It depends on the BISVIEWER_PUB reporting package and the ICX_SEC security package for authentication context. Because the procedure relies on the session and responsibility identifiers resolved at runtime, it must be executed within an authenticated FII application session. Extensions or customizations that add new source reports should follow the established branching pattern, explicitly mapping each source identifier to its destination report and binding the relevant FII currency, supplier, and organization parameters.