Search Results projfunc_rate_date




Overview
Explore in AI Chat

Overview

PA_BILLING_ASSIGNMENTS is a reporting view in the Oracle EBS Projects (PA) module that exposes billing assignment and billing extension configuration data for project billing. In Oracle Projects, a billing assignment associates a billing extension—the mechanism that generates revenue or invoice amounts according to a defined rule—with a specific project or top task, and optionally allocates that extension via an amount, a percentage, or a distribution rule. This view surfaces those assignments in a single-organization (Single-Org) reporting context, meaning it presents the subset of rows belonging to the current operating unit as determined by the ORG_ID security predicate.

Rather than being a transactional entry point, PA_BILLING_ASSIGNMENTS is a query-oriented projection of the underlying ALL table, PA_BILLING_ASSIGNMENTS_ALL. Its role is to support reporting, integration extracts, and diagnostic queries where the caller wants billing assignment data scoped to the session's organization without writing the multi-org WHERE clause manually. The ETRM metadata classifies the object as "Not implemented in this database" at the documentation source, which indicates that the view is a standard seed object delivered with the product rather than something installed by a specific customer extension.

Underlying Base Objects

The documented base object is the Multi-Org table PA_BILLING_ASSIGNMENTS_ALL, and the view is defined as a secured single-org filter over it. The predicate compares the ORG_ID column against the operating unit identified in the session, extracted from USERENV('CLIENT_INFO') and converted to a number. Rows whose ORG_ID is null or does not match the session organization (defaulting to a sentinel value of -99) are excluded. No other base tables or joins are documented in the view text, so all columns are sourced directly from the ALL table.

  • PA_BILLING_ASSIGNMENTS_ALL — the Multi-Org base table holding billing assignment records across all operating units.
  • PA_BILLING_ASSIGNMENTS — the Single-Org view that filters the ALL table by the current ORG_ID.

Key Columns

Common Use Cases and Queries

Typical uses include auditing which billing extensions are attached to a project, verifying percentage versus amount allocation, and extracting rate override configuration for reconciliation. Because the view resolves ORG_ID automatically, queries require no explicit organization filter when run in an initialized session.

  • List active assignments for a project:
    SELECT billing_assignment_id, billing_extension_id, amount, percentage, active_flag FROM pa_billing_assignments WHERE project_id = :project_id AND active_flag = 'Y';
  • Inspect rate overrides:
    SELECT billing_assignment_id, rate_override_currency_code, project_rate_type, projfunc_rate_type FROM pa_billing_assignments;
  • Join to billing extension definitions to retrieve descriptive rule names for reporting and integration extracts.