Search Results pa_proj_retn_bill_rules




Overview
Explore in AI Chat

Overview

The PA_PROJ_RETN_BILL_RULES table is a core data object within the Oracle E-Business Suite (EBS) Projects (PA) module, specifically for versions 12.1.1 and 12.2.2. It serves as the central repository for defining and storing retention billing rules at the project or task level. Retention billing is a critical financial practice in project-centric industries, where a percentage of an invoice is withheld by the customer until project milestones or contractual obligations are met. This table enables the systematic configuration of how these retention amounts are calculated, tracked, and eventually released for billing, forming an essential link between project execution, revenue recognition, and accounts receivable processes.

Key Information Stored

The table stores configuration rules that dictate retention billing behavior. While the full column list is not provided in the metadata, the documented foreign key relationships indicate the presence of critical columns that define the rule's scope and parameters. The PROJECT_ID and optional TASK_ID columns anchor the rule to a specific project or sub-task within the PA_PROJECTS_ALL and PA_TASKS tables, respectively. The CUSTOMER_ID links the rule to a specific customer account in HZ_CUST_ACCOUNTS, allowing for customer-specific retention terms. The RETN_BILLING_CYCLE_ID foreign key references PA_BILLING_CYCLES, defining the schedule or event that triggers the release of retained amounts. Other typical columns in such a table would include retention percentage rates, calculation bases (e.g., on revenue, invoice amount), retention ceilings, and effective date ranges.

Common Use Cases and Queries

Primary use cases involve configuring retention terms during project setup and generating reports for project financial analysis. Administrators use this data to ensure billing complies with contractual retention clauses. Common SQL queries include retrieving all retention rules for a specific project to review terms, or joining with customer and project tables for a consolidated view. A typical reporting query might be:

  • SELECT p.segment1 project_number, hca.account_number, prbr.* FROM pa_proj_retn_bill_rules prbr, pa_projects_all p, hz_cust_accounts hca WHERE prbr.project_id = p.project_id AND prbr.customer_id = hca.cust_account_id AND p.project_id = :p_project_id;

This data is also critical for the invoice generation engine within Projects Billing, which references these rules to calculate the correct billable and retainable amounts for each transaction.

Related Objects

The PA_PROJ_RETN_BILL_RULES table maintains defined foreign key relationships with several key EBS tables, as documented in the metadata:

  • PA_PROJECTS_ALL: Links via PA_PROJ_RETN_BILL_RULES.PROJECT_ID. This is the master table for all projects.
  • PA_TASKS: Links via PA_PROJ_RETN_BILL_RULES.TASK_ID. Allows retention rules to be defined at a granular task level within a project.
  • PA_BILLING_CYCLES: Links via PA_PROJ_RETN_BILL_RULES.RETN_BILLING_CYCLE_ID. Defines the cycle (e.g., monthly, upon completion) for releasing retained funds.
  • HZ_CUST_ACCOUNTS: Links via PA_PROJ_RETN_BILL_RULES.CUSTOMER_ID. References the Trading Community Architecture (TCA) customer master.

These relationships ensure data integrity and enable comprehensive joins for reporting and process execution within the integrated EBS framework.

  • Table: PA_PROJ_RETN_BILL_RULES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJ_RETN_BILL_RULES,  object_name:PA_PROJ_RETN_BILL_RULES,  status:VALID,  product: PA - Projects ,  description: PA_PROJ_RETN_BILL_RULES stores retention billing rules for a ,  implementation_dba_data: PA.PA_PROJ_RETN_BILL_RULES , 

  • Table: PA_PROJ_RETN_BILL_RULES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJ_RETN_BILL_RULES,  object_name:PA_PROJ_RETN_BILL_RULES,  status:VALID,  product: PA - Projects ,  description: PA_PROJ_RETN_BILL_RULES stores retention billing rules for a ,  implementation_dba_data: PA.PA_PROJ_RETN_BILL_RULES , 

  • View: PA_PROJ_RETN_BILL_RULES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJ_RETN_BILL_RULES_V,  object_name:PA_PROJ_RETN_BILL_RULES_V,  status:VALID,  product: PA - Projects ,  description: PA_PROJ_RETN_BILL_RULES stores retention billing rules for a project or top task. Retention invoice is generated based on these rules ,  implementation_dba_data: APPS.PA_PROJ_RETN_BILL_RULES_V , 

  • View: PA_PROJ_RETN_BILL_RULES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJ_RETN_BILL_RULES_V,  object_name:PA_PROJ_RETN_BILL_RULES_V,  status:VALID,  product: PA - Projects ,  description: PA_PROJ_RETN_BILL_RULES stores retention billing rules for a project or top task. Retention invoice is generated based on these rules ,  implementation_dba_data: APPS.PA_PROJ_RETN_BILL_RULES_V , 

  • View: PA_PROJ_RETN_BILL_VALUES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJ_RETN_BILL_VALUES_V,  object_name:PA_PROJ_RETN_BILL_VALUES_V,  status:VALID,  product: PA - Projects ,  description: PA_PROJ_RETN_BILL_VALUES is a view that used for displaying Billing Retentions in Summary page ,  implementation_dba_data: APPS.PA_PROJ_RETN_BILL_VALUES_V , 

  • View: PA_PROJ_RETN_BILL_VALUES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJ_RETN_BILL_VALUES_V,  object_name:PA_PROJ_RETN_BILL_VALUES_V,  status:VALID,  product: PA - Projects ,  description: PA_PROJ_RETN_BILL_VALUES is a view that used for displaying Billing Retentions in Summary page ,  implementation_dba_data: APPS.PA_PROJ_RETN_BILL_VALUES_V , 

  • Table: PA_BILLING_CYCLES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_BILLING_CYCLES,  object_name:PA_BILLING_CYCLES,  status:VALID,  product: PA - Projects ,  description: System-defined and implementation-defined billing cycle definitions ,  implementation_dba_data: PA.PA_BILLING_CYCLES , 

  • Table: PA_BILLING_CYCLES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_BILLING_CYCLES,  object_name:PA_BILLING_CYCLES,  status:VALID,  product: PA - Projects ,  description: System-defined and implementation-defined billing cycle definitions ,  implementation_dba_data: PA.PA_BILLING_CYCLES , 

  • Table: PA_TASKS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TASKS,  object_name:PA_TASKS,  status:VALID,  product: PA - Projects ,  description: User-defined subdivisions of project work ,  implementation_dba_data: PA.PA_TASKS , 

  • Table: PA_TASKS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TASKS,  object_name:PA_TASKS,  status:VALID,  product: PA - Projects ,  description: User-defined subdivisions of project work ,  implementation_dba_data: PA.PA_TASKS , 

  • Table: PA_PROJECTS_ALL 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECTS_ALL,  object_name:PA_PROJECTS_ALL,  status:VALID,  product: PA - Projects ,  description: PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. ,  implementation_dba_data: PA.PA_PROJECTS_ALL , 

  • Table: PA_PROJECTS_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECTS_ALL,  object_name:PA_PROJECTS_ALL,  status:VALID,  product: PA - Projects ,  description: PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. ,  implementation_dba_data: PA.PA_PROJECTS_ALL ,