Search Results fii_ar_inv_cust_l7d




Overview
Explore in AI Chat

Overview

ISC_EDW_O2C_DRILL_P is an Oracle EBS APPS schema package body classified under ETRM as OTHER, belonging to the Order-to-Cash (O2C) analytics family associated with the Oracle Supply Chain Intelligence / Enterprise Data Warehouse (EDW) reporting framework. Its dedicated purpose is to support drill-across navigation from summary-level O2C reports and dashboard regions into the underlying detail report or cross-tab view that the user has selected. The package is not a business data processor; it is a navigation and parameter-passing utility. Each procedure accepts a numeric selector, evaluates that selector, and constructs the target function name and URL query string, which is then handed to the generic drill-across handler BIS_PARAMETER_VALIDATION.DRILLACROSS along with the current user, session, and responsibility identifiers obtained from ICX_SEC.

The "view_by" reference in the search is significant because the package explicitly assembles VIEW_BY clauses into the generated URL strings, enabling the destination report to render the requested dimensional perspective, such as trade partner, without further user intervention.

Key Procedures and Functions

  • DRILL_ACROSS_WK — Executes the weekly drill-across action. It tests the incoming numeric selector and, depending on its value, builds a URL string targeting a specific destination function. Documented branches include navigation to ISC_OPI_TOP_ORDERS_WK, and to ISC_OPI_BOOKED_ORD_SUM_WK with VIEW_BY set to EDW_TRD_PARTNER_M plus EDW_TPRT_TRADE_PARTNER, and to the FII_AR_INV_CUST_L7D and FII_AR_REV_CUST_L7D receivables aging functions with the same VIEW_BY qualification. In every branch it supplies the current Web user ID, session ID, and responsibility ID to the drill-across handler and specifies ISC_OPI_IND_CROSS_TAB as the invoking function name.
  • DRILL_ACROSS_QTD — Provides the equivalent drill-across behavior for quarter-to-date reporting periods. Its structure mirrors DRILL_ACROSS_WK, resolving the numeric selector to a destination report function and delegating the actual session, responsibility, and URL construction to BIS_PARAMETER_VALIDATION.DRILLACROSS.

Tables Accessed

No base tables in the APPS schema are documented as referenced by this package. The package operates solely on PL/SQL package-level and session-level APIs: BIS_PARAMETER_VALIDATION (the drill-across dispatcher) and ICX_SEC (the security/session accessor exposing PV_WEB_USER_ID, PV_SESSION_ID, and PV_RESPONSIBILITY_ID). Data retrieval is deferred entirely to the destination report functions reached through the generated URL.

Usage Notes

ISC_EDW_O2C_DRILL_P is typically invoked from O2C dashboard and report regions where a user clicks a hyperlink or icon intended to drill across to a related report at a chosen aggregation level. It is not scheduled as a concurrent program and exposes no user-facing form; invocation occurs through the BI/EDW reporting stack, which passes the selector value corresponding to the chosen destination. The package is referenced by zero other database packages, confirming that its entry points are called from outside the PL/SQL package graph. Because access is delegated to ICX_SEC and BIS_PARAMETER_VALIDATION, correct behavior depends on a valid ICX session context; the package provides no independent authentication or authorization logic, and customization should preserve the existing VIEW_BY parameters that the target reports require.