Search Results pa_res_list_map_tmp4




Overview
Explore in AI Chat

Overview

PA_FP_GEN_BILLING_AMOUNTS is an Oracle Projects package body in the APPS schema that supports the generation of billing amounts for forecast and budget financial plans. Its principal role is to calculate the billable revenue, raw cost, and burdened cost amounts associated with project events and resource assignments, converting transactional amounts into the project functional currency and the project functional currency of the forecast or budget. The package operates within the financial planning and billing integration area of Oracle Projects, supplying the amounts that subsequently feed billing event generation. It is functionally coupled with multi-currency conversion logic through PA_FP_MULTI_CURRENCY_PKG, and it uses global temporary infrastructure such as the PA_RES_LIST_MAP_TMP4 table family to stage resource-to-event mappings. The package is documented as an OTHER API classification with six procedures and functions, and it is referenced by three other packages.

Key Procedures and Functions

  • GET_EVENT_DATE — Determines the effective event date given a transaction event date, an ETC start date, and a plan class code. For BUDGET plans the transaction event date is returned; for FORECAST plans the later of the event date and ETC start date is applied.
  • CONVERT_TXN_AMT_TO_PC_PFC — Converts transactional revenue, raw cost, and burdened cost amounts into both the project functional currency and the project functional currency of the forecast/budget, returning separate output values and rejection indicators for each dimension. It leverages bulk conversion types from PA_FP_MULTI_CURRENCY_PKG.
  • GEN_BILLING_AMOUNTS — The primary driver that generates billing amounts for the applicable financial plan, orchestrating amount calculation and staging of results.
  • GET_BILLING_EVENT_AMT_IN_PFC — Retrieves billing event amounts expressed in the project functional currency for downstream billing processing.
  • MAP_BILLING_EVENT_RLMI_RBS — Maps billing events to resource list member identifiers and resource breakdown structure identifiers for planning and reporting consistency.
  • UPD_TMP4_TXN_RA_ID_AND_ML — Updates the temporary resource list map structure (the PA_RES_LIST_MAP_TMP4 table) with transaction resource assignment identifiers and mapping level information.

Tables Accessed

Usage Notes

PA_FP_GEN_BILLING_AMOUNTS is typically invoked from Oracle Projects concurrent programs and internal workflows that generate billing amounts for forecast and budget financial plans. It is called from financial plan generation and billing event creation flows, and is referenced by other packages listed in the ETRM metadata. Custom integrations should not call this package directly for amount calculation, as the public API surface is not formally declared; developers needing billing amount logic should prefer documented Oracle Projects APIs. The package honors the PA_DEBUG_MODE profile option for diagnostic output. Because it depends on temporary tables such as PA_RES_LIST_MAP_TMP4, concurrent invocations should be scoped to avoid collisions, and currency conversion behavior should be validated against PA_FP_MULTI_CURRENCY_PKG for each implementation's functional currency setup.