Search Results pa_cost




Overview
Explore in AI Chat

Overview

PA_COST is a core Oracle Projects cost processing package in the APPS schema, responsible for deriving raw and burdened cost amounts for project expenditure transactions and for resolving the currency, conversion, and organizational context in which those costs are calculated. It operates as a shared calculation engine invoked by other Projects packages rather than as an end-user-facing component. Within Oracle EBS 12.1.1 and 12.2.2, PA_COST functions as the lowest-level cost derivation layer used during expenditure import, cost distribution, revenue and billing generation, and financial plan calculations. Its central role is to take transaction attributes such as expenditure type, organization, and project, then return the appropriate raw cost and burdened cost figures after applying labor multipliers, bill rates, and currency conversion. Because it is classified as an "OTHER" API rather than a public interface, it is intended for internal consumption by Projects processing logic.

Key Procedures and Functions

The documented metadata identifies eight procedures and functions. Their names indicate distinct responsibilities within the cost calculation lifecycle.

  • GET_RAW_COST — Returns the raw (base) cost of an expenditure transaction before burden is applied.
  • GET_BURDENED_COST — Returns the burdened cost, incorporating burden multipliers and related cost build-ups applied on top of raw cost.
  • GET_CONVERTED_COST_AMOUNTS — Converts cost amounts between currencies, returning the converted raw and/or burdened figures.
  • GET_CURR_CODE — Determines and returns the applicable currency code for a given cost context.
  • GET_PA_DATE — Resolves the relevant Oracle Projects date used in cost determination, typically tied to the expenditure or period.
  • GET_SCHEDULE_ID — Returns the schedule identifier associated with the cost or rate lookup.
  • OVERRIDE_EXP_ORGANIZATION — Supports override of the expenditure organization used when deriving cost, allowing the correct owning or expenditure organization to be applied.
  • REQUIREMENT_RAW_COST — Determines raw cost for transactions governed by requirement or requisition-style processing.

Tables Accessed

PA_COST reads and writes against a set of Projects cost, rate, and setup tables. The primary transaction table is PA_EXPENDITURE_ITEMS_ALL, which holds the expenditure item detail that cost calculations act upon. Cost distribution overrides are read from PA_COST_DIST_OVERRIDES, while PA_EXPENDITURES_ALL provides the parent expenditure records. Rate and burden logic draws on PA_BILL_RATES_ALL, PA_LABOR_COST_MULTIPLIERS, and PA_ORG_LABOR_SCH_RULE. Organizational and project context is supplied by PA_PROJECTS_ALL, PA_PROJECT_ASSIGNMENTS, PA_PROJECT_TYPES_ALL, PA_EXPENDITURE_TYPES, and PA_IMPLEMENTATIONS_ALL. Period and currency data come from PA_PERIODS, PA_COMPENSATION_DETAILS, PA_COMPENSATION_DETAILS_ALL, and FND_CURRENCIES.

Usage Notes

PA_COST is referenced by seven other packages, including PA_COST1, PA_FIN_PLAN_UTILS2, PA_FP_CALC_PLAN_PKG, PA_FP_GEN_BUDGET_AMT_PUB, PA_PLAN_REVENUE, PA_RATE_PVT_PKG, and PA_REVENUE. This reference pattern confirms that the package is invoked indirectly through expenditure processing, revenue and billing generation, and financial plan and budget calculations rather than being called directly from Oracle Forms. Custom code extending Projects cost logic should call the documented procedures only within the supported execution context, respecting the fact that PA_COST is an internal calculation utility and not a formally published open interface.