Search Results pft_pprof_multi_proc_err

Overview

APPS.PFT_PROFCAL_RGNCNT_PUB is a public PL/SQL package belonging to the Oracle EBS Profitability Management (PFT) application, part of the Enterprise Performance Foundation (FEM) technology stack. Its identifier, "PROFCAL_RGNCNT," denotes its role in profile calculation and region content processing — specifically, the package calculates and manages region-level content used during profitability profile computation. The package header carries the identifier FEM.PLSQL.PFT_PROFCAL_RGNCNT_PUB, confirming its placement within the FEM schema naming convention and its classification as a public API (PUB), meaning it is intended for invocation from outside the owning module.

Within the profitability calculation engine, region content defines the dimensional scope against which profile rules are evaluated. This package therefore sits at the intersection of rule execution, dimension management, and region enumeration, supporting the engine by resolving and validating the data sets that drive profit calculations.

Key Procedures and Functions

The documented interface exposes one public procedure:

• PROCESS_SINGLE_RULE — Executes the calculation logic for a single profitability rule against a defined region of content. The procedure encapsulates rule-level processing, including validation of the ledger and global versus combination (GVSC) definition, evaluation of the rule's where-clause data set, and persistence of outcome rows. Its name reflects the engine's ability to operate in a single-rule mode rather than only in multi-process batches.

The package declares message constants that reveal the error conditions reported by this procedure. Among these is PFT_PPROF_INVALID_GVSC_ERR (constant G_ENG_INVALID_GVSC_ERR), which is raised when the Global Versus Combination definition supplied to the calculation is missing or inconsistent. Related constants include PFT_PPROF_INVALID_LEDGER_ERR, PFT_PPROF_DS_WHERE_CLAS_ERR, PFT_PPROF_INVALID_OBJ_DEFN_ERR, PFT_PPROF_SINGLE_RULE_ERR, PFT_PPROF_MULTI_PROC_ERR, PFT_PPROF_RCNT_NO_OP_ROWS_ERR, and two row-update constants for operation and intermediate posting stages. Constant declarations such as FND_API.G_RET_STS_SUCCESS, G_RET_STS_ERROR, and G_RET_STS_UNEXP_ERROR confirm that the package follows the standard Oracle EBS API return-status convention.

Tables Accessed

Through APPS synonyms, the package reads and writes the following FEM tables:

• FEM_GLOBAL_VS_COMBO_DEFS — Stores global versus combination definitions validated during rule processing; the source of the PFT_PPROF_INVALID_GVSC_ERR condition.
• FEM_REGION_INFO — Defines the content regions that bound rule execution, central to the package's region-content purpose.
• FEM_DIMENSIONS_B and FEM_DIM_ATTRIBUTES_B — Provide dimension and attribute metadata required to construct the data-set where-clause.
• FEM_HIER_DIMENSION_GRPS — Supplies hierarchy and dimension group mappings used in region resolution.
• FEM_CUSTOMERS_B and FEM_CUSTOMERS_ATTR — Hold customer base records and attributes that participate in profitability content.
• FEM_MP_PROCESS_CTL_T — Tracks multi-process execution control, supporting engine status and restart handling.

Usage Notes

PROCESS_SINGLE_RULE is invoked by the profitability calculation engine, typically from concurrent program execution or from other FEM packages rather than directly from a form. The ETRM metadata records that this package is referenced by one other package, indicating a caller within the PFT/FEM calculation stack. Custom integrators should not call this API directly unless reproducing engine behavior, because it assumes prior setup of ledger, GVSC definition, and region content. When PFT_PPROF_INVALID_GVSC_ERR is raised, the standard diagnostic path is to verify that the global versus combination definition exists in FEM_GLOBAL_VS_COMBO_DEFS and is correctly associated with the ledger being calculated. As with all FND_API-compliant interfaces, callers must inspect the returned status and message rather than relying on exceptions alone.