Search Results fii_gl_expense_pkg

Overview

FII_GL_EXPENSE_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle ETRM repository as an "OTHER" API type. The package forms part of the FII (Financial Intelligence) product family, which delivers the Oracle Financial Intelligence and Daily Business Intelligence reporting infrastructure used to populate management dashboards and analytics pages in EBS 12.1.1 and 12.2.2. Its principal role is to supply expense-related data — particularly travel and entertainment (T&E) expense information — at the employee level for consumption by FII/DBI reporting pages. The package extracts and aggregates expense figures from the underlying transaction tables and returns them in a structure suitable for rendering in a business intelligence page region. Status is documented as VALID, indicating the deployed object compiled successfully in the reference environment.

Key Procedures and Functions

ETRM documents three callable units within the package, each focused on retrieving expense data for an employee context:

• GET_TE_PER_EMP — Retrieves travel and entertainment expense data associated with a given employee, typically aggregating expense lines originating from Oracle Internet Expenses or Payables.
• GET_EXP_PER_EMP — Returns general expense amounts attributed to an employee, providing a summary view of expenses incurred by that individual over the requested period.
• GET_EXPENSES_PER_EMP — Produces the broader expense detail set per employee, supporting the drill-down or line-level presentation used by the FII expense dashboard region.

The naming convention (PER_EMP) confirms that all three units are keyed to employee-level reporting, consistent with the FII/DBI model in which data is summarized by person, organization, and period. Parameter lists are not reproduced here as they are not documented in the available metadata.

Tables Accessed

The package references the following structures, with access mediated through APPS synonyms:

• BIS_PMV_PAGE_PARAMETER_TBL — The Business Intelligence System page parameter table, used to pass page context and parameter values (such as employee identifiers and date ranges) into the FII page rendering process.
• BIS_QUERY_ATTRIBUTES_TBL — The BIS query attributes table, which holds metadata describing query definitions and their presentation attributes for FII/DBI reporting.

These dependencies confirm the package operates within the BIS_PMV (Page Metadata View) framework rather than directly against base transaction tables. The underlying expense amounts are sourced through the FII data model, while the parameter and attribute tables supply the runtime context and query-shaping information. No direct references to Oracle Payables, Internet Expenses, or GL interface tables are documented in the ETRM excerpt.

Usage Notes

FII_GL_EXPENSE_PKG is an internal reporting-support package rather than a general-purpose public API. It is typically invoked indirectly by the Oracle Financial Intelligence/DBI page framework when an expense dashboard or employee expense region is rendered, most commonly from the FII/DBI HTML pages rather than from a standard EBS form. The GET_* routines are called with page parameters drawn from BIS_PMV_PAGE_PARAMETER_TBL, and the results populate the region displayed to the end user. Because ETRM records zero packages referencing FII_GL_EXPENSE_PKG, it should be treated as a terminal consumer within the FII stack — dependencies flow into it, not out of it through other PL/SQL packages. Customizations should avoid calling these routines directly; developers extending expense reporting should target the supported FII data model views instead, so that upgrades across 12.1.1 and 12.2.2 do not invalidate the package or its compiled body. Because the package is documented as VALID and proprietary, modification of its body is unsupported.