Results for “fii_operating_units”

50+ results




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

Overview

FII_AR_PDUE_REC_TREND is a reporting package body in the Oracle E-Business Suite Receivables Intelligence (FII) product family. Its business purpose is to produce the "Past Due and Open Receivables Trend" analysis, a historical view of receivable balances and their aging across periods. The package assembles a dynamic SQL statement that is consumed by the Oracle Business Intelligence (OBI/BIS) Discoverer and PMV reporting layers, returning the query text and its associated column attributes rather than a result set directly. Embedded in the source is the header identifier FIIARDBIPTB.pls, confirming its role as a business-intelligence page template supporting the FII dashboards for Receivables.

Functionally, the package answers the question of how much of a customer's or organization's receivables balance is past due versus still open, and how that trend moves from one period to the next. It supports the daily operational and management reporting used by credit, collections, and financial shared-service teams in Oracle EBS 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

The package body exposes a single documented procedure, GET_PDUE_REC_TREND. It accepts the incoming page parameter table supplied by the reporting framework and returns two output parameters by reference: an open-SQL string and a query-attribute table describing the columns of the generated statement. The procedure does not execute the SQL itself; it builds and hands back the text for the BI container to run.

Internally, the procedure performs several setup steps. It resets package globals and reads the user's page parameters. It computes current and prior period end dates through the FII time API, then fixes the analysis dimension by assigning the view-by value "ORGANIZATION+FII_OPERATING_UNITS" to the utility package global. It then populates summary global temporary tables. Local variables build conditional WHERE fragments for party, collector, and customer account filters, and a view-by-driven group-by and order-by clause. A UNION ALL branch is added when the as-of date is not the last day of the month, so the report can show both the month-end and the interim as-of position.

The reference to fii_operating_units in the search term corresponds directly to the hard-coded view-by assignment at line 38: fii_ar_util_pkg.g_view_by := 'ORGANIZATION+FII_OPERATING_UNITS'. This means the trend report aggregates past-due and open receivables by operating unit, which is the standard securing and reporting dimension in multi-org EBS installations.

Tables Accessed

Only DUAL is recorded as a referenced table for this package through APPS synonyms. DUAL is used for the single-row date conversions, in which the time API functions for current and prior period end are selected into package globals. The substantive data provisioning is delegated to supporting FII packages, principally the AR utility package that populates summary global temporary tables, so no persistent base tables are read or written directly by this unit.

Usage Notes

Because the procedure has an OUT parameter contract, it is not called as a conventional concurrent program or from an EBS form. It is invoked by the Receivables Intelligence BI framework, which passes the page parameter table in and receives the generated SQL and attribute definitions for rendering. Typical contexts include the past-due and open receivables trend dashboard and region drill-downs for organization, operating unit, party, and collector. No other APPS packages are documented as referencing it, so its lifecycle is tied entirely to the FII reporting pages. Customizations should be made cautiously, as the "ORGANIZATION+FII_OPERATING_UNITS" view-by is a fixed design assumption in this version.