Search Results pft_pprof_ppct_no_op_rows_err




Overview
Explore in AI Chat

Overview

The APPS.PFT_PROFCAL_CUST_PPTILE_PUB package is a public PL/SQL API belonging to the Profitability Manager (PFT) module of Oracle Enterprise Performance Foundation (FEM), which underpins the Profitability and Cost Management features in Oracle E-Business Suite 12.1.1 and 12.2.2. Its primary business function is to support calculation of profit percentiles and profitability rule processing across ledger and dimension data. The package provides a controlled, API-governed entry point for evaluating a single profitability rule against a population of source records and deriving percentile-based results that feed downstream profitability analysis.

The package declares standard FND_API constants (g_success, g_error, g_unexp) and message tokens reflecting its role in performance engine processing, including PFT_PPROF_INVALID_LEDGER_ERR, PFT_PPROF_INVALID_GVSC_ERR, PFT_PPROF_SINGLE_RULE_ERR, PFT_PPROF_MULTI_PROC_ERR, and PFT_PPROF_PPCT_NO_OP_ROWS_ERR. The block identifier FEM.PLSQL.PFT_PROFCAL_CUST_PPTILE_PUB confirms its placement in the FEM profitability calculation layer.

Key Procedures and Functions

The documented API surface exposes a single public procedure:

  • PROCESS_SINGLE_RULE — Evaluates one profitability calculation rule for percentile processing. It validates ledger and global versus combo (GVSC) context, applies the rule’s data-source where-clause, executes the calculation, and records update counts for output and input populate steps. Error conditions are surfaced through the message constants listed above, including failures for single-rule and multi-processor scenarios and for cases where the percentile operation yields no rows.

No additional public procedures or functions are documented in the ETRM metadata for this package.

Tables Accessed

The package interacts with the following documented tables (referenced through APPS synonyms):

  • FEM_DIMENSIONS_B — Base dimension definitions used to resolve the dimensional context required by the rule.
  • FEM_GLOBAL_VS_COMBO_DEFS — Global versus combination definitions that establish the GVSC scope validated during rule processing.
  • FEM_MP_PROCESS_CTL_T — Multi-processor process control table used to coordinate execution state and step-level progress during percentile calculation.

Usage Notes

This package is typically invoked from within the Profitability Manager calculation engine rather than directly by end users. Calls originate from concurrent programs that orchestrate profitability rule execution, from higher-level FEM/PFT processing packages, or from custom extensions that require percentile computation for a single rule. The metadata indicates the package is referenced by one other package, consistent with an internal engine caller.

Because the API is classified as PUB, it is intended for external invocation and respects Oracle’s standard API conventions, returning FND_API status codes. Callers should supply a valid ledger and GVSC context to avoid the documented validation errors. The header 120.1 with date 2006/05/25 indicates the API has remained stable across releases and is compatible with both EBS 12.1.1 and 12.2.2 environments. Users searching for “ppt 2527346” are directed to this object as the relevant reference for PFT percentile rule processing.