Search Results gen_billing_amounts




Overview
Explore in AI Chat

Overview

PA_FP_GEN_BILLING_AMOUNTS is a PL/SQL package in the APPS schema that supports the Financial Planning (FP) module of Oracle Projects. Its core purpose is to generate and populate billing amounts within the financial plan generation framework used by Project Billing and Project Costing integrations. The package forms part of the FP generation engine, which computes projected revenue, budget, forecast, and billing figures based on a project's financial plan configuration, assignments, and rate schedules.

The package is classified as an OTHER API in the ETRM metadata, indicating that it is an internal or supporting utility rather than a formalized public interface. It functions within the PA_FP (Project Financial Planning) family of packages, which includes PA_FP_GEN_AMOUNT_UTILS, PA_FP_GEN_BUDGET_AMT_PUB, PA_FP_GEN_FCST_AMT_PUB, and PA_FP_REV_GEN_PUB. The status of this package, per the ETRM documentation supplied, is VALID.

Key Procedures and Functions

The ETRM metadata identifies six documented procedures and functions within this package:

  • GET_EVENT_DATE — Retrieves the appropriate event date used in the billing amount generation process, typically to align billing events with the correct accounting or project period.
  • CONVERT_TXN_AMT_TO_PC_PFC — Converts a transaction amount into the project currency and project functional currency (PC/PFC). This is central to multi-currency projects where billing amounts must be expressed in the project's reporting currencies.
  • GEN_BILLING_AMOUNTS — The primary procedure that generates billing amounts for the financial plan. It drives the overall computation and population of billing figures into the relevant temporary and permanent tables.
  • GET_BILLING_EVENT_AMT_IN_PFC — Returns the billing event amount expressed in the project functional currency, providing a normalized value for downstream processing.
  • MAP_BILLING_EVENT_RLMI_RBS — Maps billing events to RLMI (Resource List Member and Rate Based Schedule) or RBS (Rate Based Schedule) references, linking billing events to the appropriate rate structures and resource assignments.
  • UPD_TMP4_TXN_RA_ID_AND_ML — Updates the TMP4 temporary table with transaction, resource assignment ID, and market/markup list values. This is a supporting utility used during the generation process to stage intermediate results.

Tables Accessed

The package reads from and writes to a broad set of Oracle Projects tables, as documented in the ETRM table dependency list. The key tables include:

These tables are accessed via APPS synonyms as documented in the package metadata.

Usage Notes

PA_FP_GEN_BILLING_AMOUNTS is typically invoked indirectly through the Financial Plan Generation concurrent programs in Oracle Projects, rather than being called directly by end users. It is referenced by three other public packages — PA_FP_GEN_BUDGET_AMT_PUB, PA_FP_GEN_FCST_AMT_PUB, and PA_FP_REV_GEN_PUB — which act as entry points for generating budget amounts, forecast amounts, and revenue amounts respectively. The billing amount generation logic is shared across these entry points.

In Oracle EBS 12.1.1 and 12.2.2, this package operates as part of the FP generation engine triggered from the Project Financial Plan Generation UI and the associated concurrent programs. Customizations or extensions that require billing amount computation should call the referenced public packages rather than this internal package, since its procedures are not documented as a public API. Any direct invocation in custom code should account for the temporary table dependencies (PA_FP_ROLLUP_TMP, PA_RESOURCE_ASGN_CURR_TMP) and their lifecycle within a generation run.