Search Results get_put_messages

Overview

APPS.PFT_PROFCAL_CUST_PPTILE_PUB is a public PL/SQL package body belonging to the Profitability Management (PFT) module of Oracle Enterprise Business Suite (EBS) Release 12.1.1 / 12.2.2. Its principal business function is to calculate and persist customer-level profit percentiles as part of the Profitability Manager customer profitability analytics. The package reads customer profit results, derives percentile groupings, and writes the outcome to the FEM_CUSTOMER_PROFIT and FEM_CUSTOMER_PERCENTILE_GT target tables registered through the FEM_PL_PKG register_table API. The package declares an object version constant of 1 and follows standard EBS error-handling and FND_LOG instrumentation conventions (statement, procedure, event, exception, error, and unexpected log levels). Execution status is tracked through the constants ERROR_RERUN and SUCCESS, and SQL statement contexts are distinguished using INSERT and UPDATE constants. A default fetch limit of 99999 governs bulk collection of source rows, with an overridable package variable (gv_fetch_limit) supporting controlled batch sizes.

Key Procedures and Functions

The package exposes a single documented public entry point:

• PROCESS_SINGLE_RULE — Processes one defined profitability calculation rule for customer percentile derivation. It evaluates the rule's selection criteria, computes customer profit and percentile results, and applies the appropriate INSERT or UPDATE operation against the registered output tables. On success it returns the SUCCESS execution status; on failure it signals ERROR_RERUN so that the caller or concurrent manager can retry the rule. The procedure is intended to be invoked repeatedly, once per rule, driven by an outer orchestration program.

Supporting logic beyond this public procedure is encapsulated within the package body and is not part of the documented callable interface. Because the metadata documents only one procedure, callers should treat PROCESS_SINGLE_RULE as the sole supported integration point.

Tables Accessed

The documented table references via APPS synonyms are:

• FEM_DIMENSIONS_B — The base dimensions table supplying customer and related dimension identifiers used to resolve the rule's data scope.
• FEM_GLOBAL_VS_COMBO_DEFS — Stores global value set and combination definitions that constrain which dimension combinations apply to a given profitability rule.
• FEM_MP_PROCESS_CTL_T — The processing control table used to track execution state, batching, and completion status for the rule being processed.
• FEM_CUSTOMER_PROFIT and FEM_CUSTOMER_PERCENTILE_GT — Registered output tables that receive inserted or updated customer profit and percentile results.

Usage Notes

PFT_PROFCAL_CUST_PPTILE_PUB is not typically invoked directly from an EBS form. It is called from concurrent program logic and from parent profitability orchestration packages that iterate a set of profitability rules and delegate each rule to PROCESS_SINGLE_RULE. The package is referenced by one other package in the ETRM repository, confirming its role as a subordinate calculation component rather than a top-level user-facing entry point. Custom code integrating with this package should respect the documented execution status contract (SUCCESS versus ERROR_RERUN), allow retry on the error status, and avoid assuming behavior not exposed by the single documented procedure.