Search Results pa_cust_rev_dist_lines_all




Overview
Explore in AI Chat

Overview

The PA_CUST_REV_DIST_LINES_ALL table is a core transactional table within the Oracle E-Business Suite Projects module (PA), specifically for releases 12.1.1 and 12.2.2. It serves as the detailed repository for revenue distribution data generated from project expenditures. When an expenditure item is processed for revenue recognition and billing, the system creates one or more records in this table to define how the revenue amount is allocated across different dimensions, such as tasks, funding sources, and revenue accounts. Its primary role is to store the calculated revenue distributions that are subsequently interfaced to Oracle General Ledger (GL) and Oracle Receivables (AR), forming the critical link between project execution and financial accounting.

Key Information Stored

The table's structure is defined by a composite primary key on EXPENDITURE_ITEM_ID and LINE_NUM, linking each distribution line directly to its source cost in PA_EXPENDITURE_ITEMS_ALL. Key columns and the data they hold include amounts in multiple currency contexts (e.g., PROJECT_CURRENCY_CODE, PROJFUNC_CURRENCY_CODE, INVPROC_CURRENCY_CODE), which are essential for multi-currency projects. Critical foreign key relationships, as documented, point to currency (FND_CURRENCIES), conversion rate types (GL_DAILY_CONVERSION_TYPES), and tax codes (AR_VAT_TAX_ALL_B). The table also stores the derived revenue amounts, associated accounting flexfield combinations (e.g., code combination IDs for revenue), and identifiers for the associated customer, project, and task, enabling detailed revenue attribution and auditability.

Common Use Cases and Queries

This table is central to revenue reporting, reconciliation, and troubleshooting. Common operational scenarios include analyzing revenue distributions for a specific project or invoice, reconciling project revenue to the general ledger, and investigating revenue recognition issues. A typical query pattern involves joining to PA_EXPENDITURE_ITEMS_ALL and project/task tables to trace revenue back to source costs.

  • Revenue Distribution Report by Project: SELECT project_id, task_id, SUM(project_amount) FROM pa_cust_rev_dist_lines_all WHERE project_id = :p_project_id GROUP BY project_id, task_id;
  • Reconciliation to GL: Queries often join to GL_JE_LINES via the code_combination_id and reference columns to verify posted amounts.
  • Audit Trail: Investigating the revenue impact of a specific expenditure batch by joining on EXPENDITURE_ITEM_ID back to its parent expenditure batch and items.

Related Objects

As indicated by its extensive foreign key constraints, PA_CUST_REV_DIST_LINES_ALL has strong dependencies on several fundamental EBS tables. The most critical relationship is with PA_EXPENDITURE_ITEMS_ALL, the source of all project costs. For financial integration, it references FND_CURRENCIES and GL_DAILY_CONVERSION_TYPES for currency and rate data. Its link to AR_VAT_TAX_ALL_B facilitates tax calculation for billable revenue. This table is also a primary source for the revenue distribution lines in the Projects Accounting (PA) schema, feeding interfaces and summary tables that push data to GL (via PA_TRANSACTION_INTERFACE_ALL) and to AR for invoice generation. Key related APIs include the revenue generation and distribution programs within the PA process.