Search Results projfunc_bil_rate_type




Overview
Explore in AI Chat

Overview

APPS.PA_PROJ_FUND_VALID_V is a security-filtered reporting view in Oracle EBS Projects (PA) that exposes project-level funding and billing currency attributes. Its principal role is to present only those projects for which the connected user holds both query and update privileges, and which are additionally eligible for cross–operating-unit funding. The view is defined with a name ending in "_V", following Oracle Applications naming conventions for views, and is owned by the APPS schema. It is intended for reporting and validation consumers that must confirm funding configuration before permitting currency-sensitive transactions such as revenue generation, invoicing, and billing rate determination.

The view consolidates customer assignment, project type, funding level, and multiple currency conversion attributes into a single denormalized projection. Because it applies the PA_SECURITY and PA_PROJECT_STUS_UTILS package routines inside the WHERE clause, it is not a simple join view; it inherits row-level access control and filters out projects whose status is closed. It is commonly referenced in conjunction with the search term revproc_currency_code, which appears as a projected column derived from the project funding configuration and governs the currency applied during revenue processing.

Underlying Base Objects

The documented metadata lists the following base objects referenced by the view: PA_PROJECTS_ALL (synonym), PA_PROJECT_TYPES_ALL (synonym), PA_PROJECT_CUSTOMERS (synonym), PA_LOOKUPS (view), PA_CONVERSION_TYPES_V (view, referenced twice as aliases C and C1), PA_MULTI_CURRENCY_BILLING (package), PA_PROJECT_STUS_UTILS (package), and PA_SECURITY (package).

  • PA_PROJECTS_ALL supplies the primary project record, including name, segment, template flag, multi-currency billing flag, and organization identifier.
  • PA_PROJECT_TYPES_ALL contributes project type classification, allowable funding level code, and the credit-card provider flag.
  • PA_PROJECT_CUSTOMERS links a project to its billing customer and exposes the customer bill split attribute.
  • PA_LOOKUPS resolves the allowable funding level code to its user-facing meaning.
  • PA_CONVERSION_TYPES_V resolves billing rate type names for both project billing and project functional billing.
  • PA_MULTI_CURRENCY_BILLING and PA_PROJECT_STUS_UTILS are referenced in the join and filter logic, including the check that cross-OU funding is permitted and that the project status is not closed.
  • PA_SECURITY enforces the query and update access predicates.

Key Columns

The projected columns divide into identity, classification, and currency groups:

Common Use Cases and Queries

Typical uses include validating that a project's revenue-processing currency (revproc_currency_code) is correctly configured before opening billing, and confirming conversion rate type and date codes are present. A representative query is:

SELECT project_id, name, segment1, revproc_currency_code, project_currency_code, projfunc_currency_code, multi_currency_billing_flag FROM apps.pa_proj_fund_valid_v WHERE org_id = :p_org_id;

Analysts also join the view to PA_PROJECT_CUSTOMERS or reporting tables on PROJECT_ID to present funding currencies alongside customer billing data. The security and status filters are applied automatically, so no additional predicate is required.