Search Results retn_billing_rule_id




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_PROJ_RETN_BILL_RULES is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores retention billing rules defined at the project, task, and customer level. Retention billing allows an organization to withhold a percentage or fixed amount of a customer invoice until a contractual milestone or completion threshold is met. This table captures the configuration that governs how much retention is withheld, the method used to compute it, and the billing cycle on which retention is subsequently released. The table resides in the PA schema and is documented as VALID in the ETRM repository, containing 16 columns.

From a dimensional modeling perspective, the metadata's heuristic Data Vault classification is link. This classification is derived from the foreign key structure: the table sits at the intersection of several core entities (project, task, customer, and billing cycle), which is characteristic of a link table that resolves many-to-many or associative relationships between hubs rather than storing descriptive attributes about a single business entity.

Key Information Stored

The surrogate primary key is RETN_BILLING_RULE_ID, which is also the sole documented unique index (PA_PROJ_RETN_BILL_RULES_U1) and therefore the business-key candidate. The remaining columns describe the retention arrangement:

The presence of both a percentage and a fixed amount column, combined with the method code, indicates the table supports multiple retention calculation strategies within a single rule record.

Common Use Cases and Queries

Typical usage centers on reporting retention exposure, validating rule configuration, and driving retention release during billing. A common query pattern joins the table to its parent project and customer records:

  • Retrieving active retention rules for a project — SELECT * FROM pa.pa_proj_retn_bill_rules WHERE project_id = :p_project_id;
  • Listing retention percentages and thresholds by customer — joining on CUSTOMER_ID to HZ_CUST_ACCOUNTS.
  • Reconciling total retention held per project using TOTAL_RETENTION_AMOUNT.
  • Identifying rules tied to a specific billing cycle for release processing through RETN_BILLING_CYCLE_ID.
  • Auditing configuration changes using the LAST_UPDATE_DATE and LAST_UPDATED_BY columns.

Related Objects

The documented foreign keys identify the principal related objects:

  • PA_PROJECTS_ALL — joined via PROJECT_ID; the master project definition.
  • PA_TASKS — joined via TASK_ID; the task within the project.
  • PA_BILLING_CYCLES — joined via RETN_BILLING_CYCLE_ID; defines the release cycle.
  • HZ_CUST_ACCOUNTS — joined via CUSTOMER_ID; the customer account record.

Retention rules ultimately feed the billing and invoicing streams in the Projects and Receivables modules, where the computed retention amounts influence invoice generation and subsequent release transactions.