Search Results get_raw_cost

Overview

PA_FORECAST_COST is a PL/SQL package in the APPS schema that supports Oracle Projects' cost forecasting and burdening calculations. Within Oracle E-Business Suite 12.1.1 and 12.2.2, it provides the server-side logic used to derive raw and burdened cost amounts for forecast and planning purposes, applying the appropriate rate structures, labor multipliers, and cost distribution overrides configured for a given project or task. The package is classified under ETRM as an OTHER API, meaning it is an internal building block rather than a formal public interface, and it is referenced by no other packages, indicating that its primary consumers are Oracle Projects forms, concurrent programs, or specific custom extensions rather than a broad dependency chain.

Key Procedures and Functions

The documented package exposes eight procedures and functions. Their names indicate the following roles:

• GET_RAW_COST — Returns the raw, unburdened cost for a forecast line, forming the base amount before burden processing.
• GET_BURDEN_COST — Computes the burdened cost by applying applicable burden rates to a raw cost amount.
• GET_PROJ_RAW_BURDEN_COST — Derives both raw and burdened cost in a single call at the project level, useful where a consolidated pair of values is required.
• REQUIREMENT_RAW_COST — Calculates raw cost associated with a requirement or forecast source record.
• OVERRIDE_EXP_ORGANIZATION — Applies or resolves an expenditure organization override, allowing the costing organization normally defaulted from project setup to be superseded.
• GET_PA_DATE — Returns the appropriate Oracle Projects date, typically the effective or period date governing the cost calculation.
• GET_CURR_CODE — Returns the currency code applicable to the forecast or costing context.
• GET_SCHEDULE_ID — Returns the schedule identifier associated with the project or forecast record.

Tables Accessed

The package reads from a defined set of APPS-synonym tables that supply the parameters and rates required for costing:

• PA_PROJECTS, PA_PROJECTS_ALL, PA_PROJECT_TYPES, PA_TASKS — Project, task, and project-type attributes that determine which rates and options apply.
• PA_BILL_RATES — Bill rate schedules used in burden and rate derivation.
• PA_LABOR_COST_MULTIPLIERS — Labor cost multipliers applied to raw labor costs.
• PA_COST_DIST_OVERRIDES — Cost distribution override records, supporting the organization override logic.
• PA_COMPENSATION_DETAILS_ALL — Employee compensation details used in labor costing.
• PA_EXPENDITURE_TYPES — Expenditure type definitions that drive cost categorization.
• PA_PERIODS — PA accounting periods, supporting date resolution.
• PA_IMPLEMENTATIONS_ALL — Implementation-level settings and business group context.
• FND_CURRENCIES — Currency definitions used by GET_CURR_CODE.

Usage Notes

PA_FORECAST_COST is not typically invoked directly by end users; it is called from Oracle Projects forecast and costing flows, where a form or concurrent program requires raw and burdened cost figures for display or processing. Because it is classified as an OTHER API and is not referenced by any other package, customizations that call it should be treated as dependent on unsupported internal logic that may change between releases. Developers extending forecast costing should prefer documented public APIs, using PA_FORECAST_COST only when replicating existing Oracle Projects behavior is required, and should validate behavior independently across 12.1.1 and 12.2.2 since internal packages are not guaranteed to remain stable across upgrade boundaries.