Search Results prior_rev




Overview
Explore in AI Chat

Overview

APPS.FII_AR_SG_PROD_REV_PKG is a reporting package body belonging to the Oracle E-Business Suite Financial Intelligence (FII) product family, specifically the Receivables subject-area "Sales Graph / Product Revenue" (SG_PROD_REV) reporting component. Its principal role is to construct the dynamic SQL statement and the accompanying BIS_QUERY_ATTRIBUTES_TBL output descriptor used by Oracle Daily Business Intelligence (DBI) and Enterprise Planning and Budgeting style PMV (Page Master View) regions that display product revenue analyses for Accounts Receivable. Rather than storing data itself, the package functions as a query-generation engine: it accepts a page-parameter collection supplied by the reporting framework, translates those parameters into predicates, and returns a SQL text string and column-definition table that the report renderer executes.

The naming convention confirms its scope: "FII_AR" identifies Financials Intelligence for Receivables, while "SG_PROD_REV" denotes the Sales Graph product revenue business area. The package body carries a source header dated 2005/07/01 (FIIARSGPRB.pls 120.1), consistent with the FII reporting baseline delivered in Oracle EBS 12.1.1 and retained under 12.2.2.

Key Procedures and Functions

The package exposes a single documented procedure:

  • GET_SG_PROD_REV — The sole public procedure. It receives the incoming page-parameter table and returns two OUT parameters: a dynamically built SQL statement and a BIS_QUERY_ATTRIBUTES_TBL collection describing the query's attributes and output columns. Internally, the procedure declares numerous local variables that reveal its segmentation logic, including current period, SG identifier, product category, customer, view-by, period type, as-of date, and record type identifier. It also declares variables representing one, two, and three periods back, together with a prior-revenue flag mechanism (the "prior_rev" concept users search for), which supports period-over-period comparison of product revenue. The procedure resets package globals, calls FII_AR_Util.Get_Parameters to populate the shared reporting parameters, iterates the page-parameter table to extract the ORDERBY value, and assembles the final SQL from nested inner-SQL fragments and WHERE clauses.

Tables Accessed

The ETRM metadata documents one referenced table via APPS synonyms:

  • PLITBLM — A PL/SQL ranged temporary table used to stage and materialize row sets during query construction and result assembly.

The dynamic SQL text generated by GET_SG_PROD_REV targets FII Receivables materialized views rather than base transaction tables; the variable l_mv_to_be_used indicates the procedure selects among candidate materialized views according to the period type and record type (booked versus other record types) requested. No direct inserts, updates, or deletes against persistent data are performed by this package.

Usage Notes

The package is invoked indirectly by the Oracle DBI/FII reporting framework whenever a user opens a Receivables product revenue page or dashboard region. The framework passes the page-parameter table populated from the form or portal region, and the returned SQL and attribute collection are executed by the BIS query engine. It is not called from standard Oracle Forms directly, nor is it registered as a standalone concurrent program. Because it is classified as OTHER in the API taxonomy and is referenced by zero other packages, it should be treated as an internal reporting implementation detail rather than a public integration interface. Customizations should avoid calling it directly; instead, extend the underlying FII_AR_Util parameter contract or the report definition. The prior-period comparison behavior driven by the one-, two-, and three-period-back variables is the mechanism that answers searches for "prior_rev" within this object.