Search Results pa_project_customers




Overview
Explore in AI Chat

Overview

The PA_PROJECT_CUSTOMERS table is a core data object within the Oracle E-Business Suite Projects (PA) module, specifically for versions 12.1.1 and 12.2.2. It serves as the central repository for defining and managing customer relationships for projects. Its primary role is to establish the link between a project and one or more customers, enabling critical downstream processes such as billing, revenue recognition, and contract management. By storing customer and address information at the project level, this table ensures that financial transactions and project deliverables are correctly associated with the appropriate customer entities.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which enforce data integrity and define its relationships. The primary key is a composite of PROJECT_ID and CUSTOMER_ID, ensuring a unique relationship between a project and a specific customer. Key columns include PROJECT_ID, which links to PA_PROJECTS_ALL, and CUSTOMER_ID, which links to customer master tables (HZ_CUST_ACCOUNTS and the legacy RA_CUSTOMERS). Crucially, the table also stores address identifiers for billing (BILL_TO_ADDRESS_ID) and shipping (SHIP_TO_ADDRESS_ID), linking to the HZ_CUST_ACCT_SITES_ALL and RA_ADDRESSES_ALL tables. This allows for precise address management per customer-project relationship.

Common Use Cases and Queries

This table is fundamental for any reporting or process involving project customers. Common use cases include generating a customer list for a specific project, validating billing setup before invoice generation, and analyzing the customer portfolio across multiple projects. A typical query to retrieve all customers for a project, including their names and bill-to addresses, would join through the TCA (Trading Community Architecture) tables:

  • SELECT ppc.project_id, hca.account_number, hca.account_name, hcsua.location
  • FROM pa_project_customers ppc,
  • hz_cust_accounts hca,
  • hz_cust_acct_sites_all hcasa,
  • hz_cust_site_uses_all hcsua
  • WHERE ppc.customer_id = hca.cust_account_id
  • AND ppc.bill_to_address_id = hcasa.cust_acct_site_id
  • AND hcasa.cust_acct_site_id = hcsua.cust_acct_site_id
  • AND hcsua.site_use_code = 'BILL_TO'
  • AND ppc.project_id = :p_project_id;

Related Objects

PA_PROJECT_CUSTOMERS is a nexus table with dependencies on several key master and transactional tables. Its primary foreign key relationship is with PA_PROJECTS_ALL, anchoring it to the project definition. For customer data, it integrates with the modern TCA schema (HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL) and retains compatibility with the legacy Receivables schema (RA_CUSTOMERS, RA_ADDRESSES_ALL). This table is directly referenced by APIs and forms within the Projects module for customer assignment and is essential for the setup of project-related billing and invoicing interfaces in Oracle Project Billing.