Search Results pft_profcal_prosp_ident_pub




Overview
Explore in AI Chat

Overview

The APPS.PFT_PROFCAL_PROSP_IDENT_PUB package is a public PL/SQL API belonging to the Profitability Manager (PFT) module of Oracle E-Business Suite. Its name reflects its role within the profitability calculation engine: "PROFCAL" denotes profitability calculation, and "PROSP_IDENT" denotes prospective or prospect identification — the resolution of eligible combinations for which profitability rules must be evaluated. The package serves as the entry point for identifying and processing the data sets against which individual profitability rules are run. It acts as a wrapper around the core dimension and hierarchy metadata stored in the FEM (Financial Enterprise Management / Enterprise Performance Foundation) schemas, exposing business logic to callers while enforcing the standard PL/SQL API conventions defined by FND_API. As a PUB-classified package, it is intended for supported external invocation by other application modules rather than for private internal use. In ETRM 12.1.1 the object carries a VALID status in the APPS schema, and the same metadata applies to 12.2.2 within the shared EBS technology stack.

Key Procedures and Functions

The ETRM documentation identifies a single public procedure within the package:

  • PROCESS_SINGLE_RULE — Drives the identification and processing of data for a single profitability calculation rule. The procedure is responsible for resolving the applicable combinations or "prospects" that a given rule must evaluate, then orchestrating the identification logic against the profitability dimension metadata. Consistent with public API design, it returns status through the standard FND_API p_return_status mechanism, allowing callers to detect success, unexpected error, or error conditions without inspecting internal state. The parameter list is not documented in the available ETRM extract; it should never be assumed, but the procedure name confirms a single-rule, discrete-unit-of-work processing model rather than bulk processing of an entire rule set.

Tables Accessed

The package operates against four documented tables, accessed through APPS synonyms:

  • FEM_DIMENSIONS_B — The base table holding profitability dimension definitions. The package reads this table to resolve which dimensions participate in a rule's combination.
  • FEM_GLOBAL_VS_COMBO_DEFS — Stores global versus combination definitions, used to map a rule's scope to concrete member combinations.
  • FEM_MP_PROCESS_CTL_T — The multiprocess control table, used to track execution state and coordinate processing for the profitability calculation run.
  • PLITBLM — The standard PL/SQL index-by table for VARCHAR2 used by Oracle applications for in-memory work collections; employed here as an internal work structure rather than as a persistent store.

These tables are largely read-oriented for identification purposes, with control-table writes confined to process state.

Usage Notes

This package is typically invoked from the Profitability Manager concurrent programs and calculation flows that drive rule execution, and from forms or custom code that need to trigger identification for a single rule. Because it is a PUBLIC API and depends on FND_API, callers should use standard return-status handling and avoid direct manipulation of the underlying FEM tables. The documented reference graph shows the package is referenced by no other packages and is itself self-referencing in the ETRM dependency listing; there is no documented dependency list beyond FND_API and the SYS STANDARD package. Customizations should attach to the public procedure rather than to private bodies, since only PROCESS_SINGLE_RULE is documented as a supported entry point. In both 12.1.1 and 12.2.2, the same invocation patterns apply; no additional procedures are documented for this object.