Search Results pa_bill_pct




Overview
Explore in AI Chat

Overview

PA_BILL_PCT is an Oracle Projects billing utility package owned by the APPS schema. Its central purpose is the calculation and retrieval of percent-complete, event, revenue, and invoice amounts used during the billing cycle. The package provides the arithmetic foundation that Oracle Projects relies upon when determining how much of a contract, budget, or event value is eligible for invoicing at any point in time. In Oracle EBS 12.1.1 and 12.2.2, the object is documented as VALID and is classified under the ETRM as an OTHER API, reflecting its role as an internal calculation engine rather than a formally published public API. It does not expose a governed integration interface; instead, it is consumed internally by Oracle Projects' own billing components.

Key Procedures and Functions

The ETRM metadata documents six callable units within PA_BILL_PCT. Each serves a distinct calculation or retrieval role:

  • CALC_PCT_COMP_AMT — Calculates the monetary amount corresponding to a given percent complete, converting a completion ratio into a billable value.
  • POTEVENTAMOUNT — Derives the potential or event-based amount associated with a billing event, used when event revenue or billing is driven by milestone completion.
  • REVENUEAMOUNT — Returns the revenue amount attributable to the billing context, supporting revenue-to-billing reconciliation.
  • INVOICEAMOUNT — Returns the invoiced amount, allowing the package to track what has already been billed against a project or task.
  • GETPERCENTCOMPLETE — Retrieves the percent-complete value for a project, task, or billing assignment, which underpins percentage-of-completion billing methods.
  • GET_REV_BUDGET_AMOUNT — Retrieves the revenue budget amount, providing the denominator or baseline against which completion and billing figures are compared.

No parameter lists are documented in the ETRM metadata, and none are asserted here.

Tables Accessed

PA_BILL_PCT references a substantial set of APPS synonyms. The billing configuration and assignment tables — PA_BILLING_ASSIGNMENTS, PA_BILLING_EXTENSIONS, PA_BUDGET_TYPES, PA_BUDGET_VERSIONS, PA_FIN_PLAN_TYPES_B — supply the rules and budget context that govern how amounts are derived. Transaction and event data comes from PA_EVENTS, PA_EVENT_TYPES, PA_CUST_EVENT_REV_DIST_LINES, and PA_CUST_REV_DIST_LINES, which hold customer event revenue distributions. Actual cost and revenue figures are sourced from PA_EXPENDITURE_ITEMS_ALL, PA_DRAFT_REVENUE_ITEMS, and PA_DRAFT_INVOICE_ITEMS, while PA_PROJECTS_ALL and PA_TASKS supply the project and task hierarchy. DUAL is used for single-row arithmetic lookups.

Usage Notes

PA_BILL_PCT is an internal dependency rather than a customer-facing API. The ETRM records that it is referenced by PA_RETN_BILLING_PKG, the retention billing package, and by one additional package. Typical invocation therefore occurs indirectly: when retention billing, event billing, or percentage-of-completion billing logic executes, PA_RETN_BILLING_PKG and its peers call PA_BILL_PCT procedures to obtain the underlying amounts and completion percentages. In practice this means the package executes in the background of billing generation concurrent programs and billing-related forms. Because its signature is not documented as a published API, custom code should not call PA_BILL_PCT directly; developers requiring percent-complete or billing amounts should prefer supported Oracle Projects APIs. Its presence in a dependency chain indicates that any change to its logic can propagate into retention billing and related billing processes, making it a sensitive object during patching and upgrades between 12.1.1 and 12.2.2.