Search Results filter_date




Overview
Explore in AI Chat

Overview

FII_AR_TRX_ACT_HISTORY_PKG is an Oracle Applications (APPS) PL/SQL package that supports the Oracle Receivables Transaction Activity History business intelligence report. The package is part of the Financial Intelligence (FII) family of database objects used by Oracle Daily Business Intelligence and related embedded analytics in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its principal role is to dynamically construct the SQL statement and query attribute definitions consumed by the BIS Page Metrics Viewer (PMV) engine, thereby driving the Transaction Activity History report that reconciles Receivables transaction balances against receipts and adjustments.

The package is classified as OTHER in the ETRM repository and is owned by APPS. The package body exposes a single documented program unit, GET_TRX_ACT_HISTORY, which is the entry point invoked by the reporting framework.

Key Procedures and Functions

  • GET_TRX_ACT_HISTORY — The sole documented procedure in the package body. It receives a page parameter table of type BIS_PMV_PAGE_PARAMETER_TBL and returns both a dynamically generated SQL statement (trx_act_history_sql) and a query attributes collection (trx_act_history_output). Internally it resets globals and retrieves report parameters through FII_AR_UTIL_PKG, evaluates conditional logic such as the adjustment-only flag and the transaction class, and assembles the drill-down linkage that allows users to navigate from an amount or balance column into the underlying Receipts Detail report. Because the exact parameter list is fixed by the source header, only these named inputs and outputs should be assumed.

Tables Accessed

The ETRM metadata lists PLITBLM as the only table referenced through an APPS synonym. This is the standard PL/SQL intermediate table used by the BIS reporting framework to hold the dynamically generated SQL text and associated query attributes for execution by the PMV engine. The package does not directly read or write Receivables base tables such as RA_CUSTOMER_TRX_ALL; instead, those tables are referenced within the dynamically constructed SQL string produced at runtime. This design keeps the package focused on query assembly while deferring physical data access to the generated statement, consistent with the Oracle Daily Business Intelligence reporting architecture.

Usage Notes

FII_AR_TRX_ACT_HISTORY_PKG is not intended for direct invocation by end users or custom PL/SQL code. It is called by the Oracle Financial Intelligence reporting framework when a user opens the Receivables Transaction Activity History page or dashboard region. The package is registered as the SQL generator for that page, and the framework passes the current page parameter values—including filter_date, transaction class, adjustment-only indicator, and other report filters—through the BIS_PMV_PAGE_PARAMETER_TBL structure.

The filter_date concept is significant because the report is period- and date-driven: the parameters collected from the page, including the date filter, determine the date range and join conditions embedded in the generated SQL. The drill-down strings assembled inside GET_TRX_ACT_HISTORY carry the customer, cash receipt, and transaction identifiers required to relaunch the Receipts Detail report when a user clicks an amount or balance figure. Because the package relies on session globals set by FII_AR_UTIL_PKG, it must be invoked within the standard reporting session context; calling it outside that context without first initializing the utility package parameters will not produce a valid query. No other packages in the documented metadata reference this package, confirming its role as a terminal report-generation unit rather than a reusable API.