Search Results pft_acctrelcons_pub




Overview
Explore in AI Chat

Overview

APPS.PFT_ACCTRELCONS_PUB is a public PL/SQL package in the Oracle EBS Applications schema that belongs to the Financial Services Enterprise Performance Foundation / Profitability Manager (PFT) product family. It provides the public application programming interface through which account relationship consolidation rules are evaluated and executed. In the EBS 12.1.1 and 12.2.2 releases, this package acts as the runtime engine for consolidation logic that groups and relates general ledger account balances before they are loaded into the performance foundation data model. The "PUB" suffix indicates that the package is intended as a published, callable API: application logic and external integrators are expected to invoke its entry points rather than executing the underlying private logic directly. The package is recorded with a VALID status in the ETRM object catalog and depends on the Oracle-supplied FND_API utility package as well as the SYS.STANDARD package, confirming that it uses the standard EBS API error-handling and message conventions.

Key Procedures and Functions

The documented public interface exposes a single callable entry point, PROCESS_REQUEST. Consistent with the naming convention used across FEM and PFT packages, this procedure drives the processing of a submitted request by reading its control parameters, evaluating the applicable account relationship consolidation rules, and writing the resulting execution and process data. It is the sole documented procedure and therefore serves as the primary invocation surface of the package. No parameter list is documented in the ETRM metadata, so the exact signature should be confirmed against the deployed package specification in the target environment. The package specification and package body are both recorded, and the package is referenced only by itself, indicating that no other shipped package depends on it at the schema level.

Tables Accessed

The package operates against a focused set of Enterprise Performance Foundation and Profitability Manager tables, addressed through APPS synonyms. The rule definition and control data are held in PFT_ACCT_REL_CONS_RULES, FEM_RULESET_PROCESS_DATA, and FEM_MP_PROCESS_CTL_T, which together supply the consolidation rules and request-level process state. Metadata describing the objects being processed is resolved through FEM_OBJECT_CATALOG_B, FEM_OBJECT_DEFINITION_B, FEM_SOURCE_SYSTEMS_B, and FEM_DS_INPUT_OUTPUT_DEFS. Execution tracking and population scope are supported by FEM_PL_OBJECT_EXECUTIONS and FEM_COL_POPULATION_TMPLT_B. Utility access relies on DBMS_UTILITY, DUAL, and PLITBLM. Collectively these accesses allow the package to resolve rule metadata, apply the consolidation logic, and persist execution results within the FEM framework.

Usage Notes

PFT_ACCTRELCONS_PUB is normally invoked indirectly through the Profitability Manager concurrent program and process control framework rather than called interactively from a form. Because it is classified as a public API and is registered as a valid, compiled object in APPS, it may also be called from custom PL/SQL code, but such calls should follow the standard FND_API initialization and error-handling pattern and should respect the request control records in FEM_MP_PROCESS_CTL_T. The package is not referenced by other shipped packages, so it is effectively a top-level entry point for account relationship consolidation processing. Any modification to the rules in PFT_ACCT_REL_CONS_RULES takes effect the next time PROCESS_REQUEST is executed for the relevant request or process control row.