Search Results fii_ar_sg_prod_rev_pkg

Overview

FII_AR_SG_PROD_REV_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the "OTHER" API category within the ETRM repository. The package name indicates a reporting or analytical role tied to Oracle Financial Intelligence/Financials Intelligence (FII) functionality for Oracle Receivables (AR), specifically oriented toward "SG" (a site- or localization-specific designation) production revenue reporting. In the Oracle EBS 12.1.1 and 12.2.2 environments, this package is a component of the Business Intelligence System (BIS) / Performance Management Viewer (PMV) framework, which drives embedded analytics and region-based reporting inside Oracle Forms and self-service pages.

The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking user rather than the package owner. This design is typical of query-generation packages that must resolve APPS synonyms and respect the caller's data-access context within a multi-org environment. Its source header (revision 115.1, dated 2004) reflects that it has been a stable, largely unchanged artifact carried forward through successive EBS releases.

Key Procedures and Functions

The package exposes a single documented procedure:

• GET_SG_PROD_REV — The sole entry point in the package. It accepts a PMV page-parameter table (BIS_PMV_PAGE_PARAMETER_TBL) as input and returns a dynamically constructed SQL query string plus a BIS_QUERY_ATTRIBUTES_TBL result structure. As implied by the naming convention used throughout the FII/BIS family, this procedure builds and returns the query definition used to display "SG production revenue" data in a PMV region, packaging both the SQL text and the associated query attributes for the calling viewer framework.

No other public procedures or functions are documented in the provided metadata. The naming pattern (a single get_ procedure returning SQL and output attributes) is consistent with the standard BIS PMV query-provider contract, in which the region layer supplies user-selected parameters and receives back a fully resolved query for execution.

Tables Accessed

The documented metadata identifies PLITBLM as the only referenced table, accessed through an APPS synonym. PLITBLM is a well-known Oracle Applications date/period translation table used to translate between period names, period numbers, and calendar dates. Its presence here indicates that GET_SG_PROD_REV resolves period-based parameters (such as accounting period or fiscal period selections made on the PMV page) into concrete date ranges before assembling the revenue query against the underlying Receivables balances and transaction data.

The package is listed as referenced by zero other packages, confirming that it is a top-level consumer rather than a shared utility.

Usage Notes

This package is invoked indirectly by the BIS/PMV reporting engine when a user opens the corresponding "SG production revenue" analytical region within Oracle Receivables. It is not intended as a general-purpose API and should not be called from custom code without careful attention to the expected parameter table structure. Typical invocation occurs through Forms-embedded analytics regions or self-service HTML pages that call the standard PMV query-provider interface.

Parameters are supplied through BIS_PMV_PAGE_PARAMETER_TBL, allowing the framework to pass page context (period, organization, and similar selections). Because the package is AUTHID CURRENT_USER, custom callers must have access to the APPS synonyms (notably PLITBLM) and any underlying FII views the generated SQL references. Modifications should be avoided, as the package is a seeded Oracle object; extensions should instead be made through supported PMV personalization or custom query providers.