Search Results get_exp_cc_by_cat1




Overview
Explore in AI Chat

Overview

FII_GL_COST_CENTER_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Financial Intelligence (FII) product family, which supplies the analytical data model and reporting infrastructure underlying financial statement generation, cost center performance analysis, and management reporting. The package serves a specialized business function: it aggregates and returns General Ledger balances — revenue, cost of goods sold, expenses, and time-and-expense amounts — organized by cost center, by transaction, and by category. These accessors allow downstream reporting pages and inquiries to retrieve pre-computed financial measures for a given cost center or organizational unit without exposing callers to the underlying GL schema or to the complexity of account hierarchy traversal.

The package is classified as OTHER under the ETRM API classification scheme, indicating that it is an internal, Oracle-maintained utility package rather than a public, documented integration API. It carries a VALID status in the 12.1.1 ETRM repository and is documented for both 12.1.1 and 12.2.2 release lines.

Key Procedures and Functions

The ETRM metadata documents eighteen procedures and functions within this package. These divide naturally into several functional groups:

  • Cost center balance accessors — GET_REV_CC (revenue by cost center), GET_COGS_CC (cost of goods sold by cost center), GET_EXP_CC (expense by cost center), and GET_TE_CC (time-and-expense by cost center) return individual GL balance components for a cost center. GET_REVEXP_CC and GET_TE_CC combine revenue/expense and time-entry views respectively. GET_REVEXP_TR and GET_TE_TR provide the corresponding transaction-level variants.
  • Category-specific accessors — GET_EXP_BY_CAT, GET_EXP_CC_BY_CAT1, GET_EXP_CC_BY_CAT, GET_REV_CC_BY_CAT, and GET_COGS_CC_BY_CAT return the same measures segmented by expense or account category, supporting dimensional breakdowns in reporting.
  • Margin calculations — GET_CONT_MARG (contribution margin) and GET_OPERA_MARG (operating margin) derive profitability measures from the underlying revenue and cost components.
  • Manager and organizational lookup — GET_EXP_CCC_MGR resolves the manager associated with a cost center hierarchy, supporting responsibility-based reporting and approval routing.

The naming convention consistently encodes the measure (REV, COGS, EXP, TE), the aggregation level (CC for cost center, TR for transaction), and the segmentation (BY_CAT). No public parameter signatures are documented in the ETRM metadata.

Tables Accessed

The package references three tables through APPS synonyms:

  • FII_CC_MGR_HIERARCHIES — the cost center manager hierarchy table, consulted by the manager-resolution routines to map employees and cost centers to their reporting managers and to define the hierarchical relationships used when rolling balances upward.
  • FII_TIME_ENT_PERIOD — the time-entry period table, used by the TE (time-and-expense) routines to associate periods with time-entry data and to constrain the reporting window.
  • DUAL — the standard Oracle single-row utility table, used for scalar expression evaluation and default returns.

The dependency listing also records references to the BIS_PMV_PAGE_PARAMETER_TBL and BIS_QUERY_ATTRIBUTES_TBL structures, indicating that the package integrates with the Oracle Business Intelligence System (BIS) Page Manager View framework to expose its measures as reporting page parameters and query attributes. This confirms the package's role as a data provider to FII's web-based financial reporting pages.

Usage Notes

Because FII_GL_COST_CENTER_PKG is an internal package, it is not intended to be called directly from customer-developed concurrent programs or forms without risk of breakage across patches. In practice, it is invoked by Oracle's FII reporting pages and by other FII packages that render cost center performance dashboards, profitability reports, and margin analysis. The package is not referenced by any other documented packages in the ETRM repository, confirming that it sits near the top of the FII call stack. Customizations that need cost center balance data should prefer documented public APIs or direct GL balance queries rather than calling this package, since its signatures and behavior are subject to change in Oracle maintenance releases.