Search Results pa_client_extn_burden_resource




Overview
Explore in AI Chat

Overview

PA_CLIENT_EXTN_BURDEN_RESOURCE is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that serves as an extension point within the Project Accounting (PA) burden costing and commitment summarization architecture. Its purpose is to expose project burden and commitment resource data to client-specific formatting and grouping logic used when building burden summary reporting views such as PA_CDL_BURDEN_SUMMARY_V and PA_CMT_BURDEN_SUMMARY_V. In the Oracle EBS 12.1.1 and 12.2.2 releases, burden costing relies on a configurable resource structure that classifies expenditures and commitments into burdenable cost components; this package provides the client-facing abstraction layer that translates the underlying expenditure and commitment resource identifiers into client-defined groupings and column values for reporting and costing calculations.

Key Procedures and Functions

The ETRM metadata documents two procedures or functions for this package. No parameter signatures are published, so only their purpose is described.

  • CLIENT_GROUPING — Provides client-defined grouping of burden resources. It is used to aggregate burdenable and burden cost components into the grouping logic that client reporting views require, allowing organizations to control how burdened resources roll up when summarized. This procedure or function supplies the mapping between Oracle's delivered resource structure and the client's own grouping scheme.
  • CLIENT_COLUMN_VALUES — Supplies client-specific column values for the burden summary views. It returns or populates the descriptive column data (for example, resource labels, categories, and column assignments) that appear when burden cost and commitment summaries are displayed through PA_CDL_BURDEN_SUMMARY_V and PA_CMT_BURDEN_SUMMARY_V.

Although this package is classified as a client extension, the shipped implementation is marked VALID in the APPS schema and is referenced by standard Oracle code rather than remaining a hollow stub.

Tables Accessed

The package references the following base tables through APPS synonyms:

  • PA_EXPENDITURES_ALL — Stores actual project expenditure transactions. The package reads expenditure records to derive burdenable cost amounts for burden calculation and summary reporting.
  • PA_EXPENDITURE_ITEMS_ALL — Stores the individual cost distribution lines of an expenditure. These items supply the resource-level detail necessary for classification and burden costing.
  • PA_COMMITMENT_TXNS — Stores commitment (encumbrance and obligation) transactions against projects. It is accessed so that burdened commitment amounts can be summarized alongside actual costs.

These three tables form the resource foundations on which the grouping and column-value logic operates.

Usage Notes

PA_CLIENT_EXTN_BURDEN_RESOURCE is invoked indirectly by Oracle's delivered burden costing and summarization code and is not normally called directly by end users. The standard packages and views that reference it — PA_BURDEN_COSTING, PA_CDL_BURDEN_SUMMARY_V, PA_CMT_BURDEN_SUMMARY_V, PA_FUNDS_CONTROL_PKG1, and its own dependent code — drive its execution during burden cost calculations, commitment burden summarization, and funds control processing. In the documented metadata it is referenced by four other packages.

Because the package is classified as OTHER (not a standard open interface or public API), customers typically extend the package body to implement organization-specific grouping and column naming while preserving the documented procedure names so the standard callers continue to resolve correctly. Customizations should be performed in a controlled environment and revalidated after patching, since changes to the standard references from PA_BURDEN_COSTING or the summary views can invalidate the dependency chain. The package should not be invoked through ad hoc SQL without understanding its dependencies on active burden structures.