Search Results fpa_pc_all_obj




Overview
Explore in AI Chat

Overview

The APPS.FPA_PROCESS_PVT package is a private (PVT) PL/SQL API that forms part of the Oracle E-Business Suite Financial Planning and Analysis (FPA), also referred to as Portfolio Analysis, module. Its principal business function is to encapsulate the processing logic that supports portfolio and project portfolio management activities, including the creation and maintenance of portfolio containers, the association of projects to those portfolios, the definition of strategic objectives, and the management of scenario-based analysis. As a private package, FPA_PROCESS_PVT is not intended for direct invocation by external custom code; instead it provides the internal engine that is called by the public application programming interfaces and user interface components of the FPA module.

The package is documented with an API classification of PVT and holds a VALID status in the APPS schema. It exposes twenty-five procedures and functions and depends upon the FND_API foundation package, the object types FPA_PC_ALL_OBJ, FPA_PORTFO_ALL_OBJ, and FPA_SCEN_PROJ_USERRANK_ALL_OBJ, as well as the sibling package FPA_PORTFOLIO_PVT. This dependency structure confirms that FPA_PROCESS_PVT operates as a lower-level processing layer that coordinates with the public portfolio API rather than with end-user forms directly.

Key Procedures and Functions

The documented procedures and functions reflect four functional groupings:

These procedures are named here strictly as documented; their parameter lists are not reproduced because the metadata does not provide them.

Tables Accessed

FPA_PROCESS_PVT references several core data structures through APPS synonyms:

  • PA_PROJECTS_ALL — the central Oracle Projects repository of project definitions. The package reads this table when collecting, adding, refreshing, or removing projects from a portfolio, and it supplies the project identifiers that underpin all portfolio analysis.
  • DBMS_AW — the Oracle OLAP Analytic Workspace package. This reference indicates that the package participates in multidimensional analysis or analytic workspace processing, likely when scenarios are created or evaluated.
  • PLITBLM — the PL/SQL table (index-by table) package used widely across Oracle EBS for collection-based parameter passing, consistent with the package's heavy use of object types for structured data exchange.

In addition, the package depends upon the FPA_PC_ALL_OBJ and FPA_PORTFO_ALL_OBJ object types, which represent portfolio container and portfolio records respectively, and FPA_SCEN_PROJ_USERRANK_ALL_OBJ, which carries scenario project user ranking data.

Usage Notes

Because FPA_PROCESS_PVT is a private package, it is not designed for direct invocation by external integrators or custom concurrent programs. It is invoked indirectly through the public FPA APIs and the Portfolio Analysis user interface. Typical invocation paths include FPA forms that call the public FPA_PORTFOLIO_PVT and FPA_PROCESS_PVT layers in sequence, and concurrent programs that process project collection or refresh operations on behalf of a portfolio owner. The metadata records that FPA_PROCESS_PVT is referenced by zero other packages, confirming that it sits at the execution layer rather than being a shared utility. Custom code requiring portfolio processing should call the supported public APIs rather than this private package, since Oracle may alter private interfaces without notice. When troubleshooting portfolio behavior in EBS 12.1.1 or 12.2.2, this package is a relevant target for tracing, but it should be treated as internal implementation and not as a stable extension point.