Search Results pa_credit_receivers




Overview
Explore in AI Chat

Overview

PA_CREDIT_RECEIVERS is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the employees who receive credit for project revenue. Its documented description identifies it as the repository of revenue credit assignments, allowing organizations to attribute revenue to individual persons or sales representatives at the project and task level. The table is owned by the PA schema and is classified as VALID in the ETRM repository.

From a Data Vault modeling perspective, the heuristic classification for this object is a link. This suggestion reflects the table's structure: it resolves relationships between projects (PA_PROJECTS_ALL), tasks (PA_TASKS), and people or sales representatives (RA_SALESREPS_ALL) rather than acting as a standalone hub or descriptive satellite. Transactional attributes such as CREDIT_PERCENTAGE and date ranges are carried on the same row, which is common for EBS intersection tables.

Key Information Stored

The documented physical schema contains 17 columns. The most significant include:

The primary key, PA_CREDIT_RECEIVERS_PK, is composed of PROJECT_ID, TASK_ID, PERSON_ID, CREDIT_TYPE_CODE, and START_DATE_ACTIVE. A second unique index, PA_CREDIT_RECEIVERS_U1, matches that same business-key combination, while PA_CREDIT_RECEIVERS_U6 uniquely identifies rows by the surrogate CREDIT_RECEIVER_ID.

Common Use Cases and Queries

Typical use cases include revenue credit reporting, sales commission attribution, and reconciliation of project revenue distribution. Analysts frequently query this table to determine which individuals receive credit on a project during a given period.

  • List active credit receivers for a project: 
    SELECT person_id, credit_type_code, credit_percentage
FROM   pa.pa_credit_receivers
WHERE  project_id = :p_project_id
AND    TRUNC(SYSDATE) BETWEEN start_date_active
       AND NVL(end_date_active, TRUNC(SYSDATE));
  • Join to PA_PROJECTS_ALL for project names and to RA_SALESREPS_ALL for sales rep details.
  • Verify credit percentage totals per project/task to ensure allocations sum correctly.
  • Identify credits flagged for transfer to Receivables via TRANSFER_TO_AR_FLAG.
  • Audit historical assignments using START_DATE_ACTIVE and END_DATE_ACTIVE ranges.

Related Objects

The following objects are most significant given the documented foreign key relationships:

  • PA_PROJECTS_ALL — joined on PROJECT_ID; the parent project definition.
  • PA_TASKS — joined on TASK_ID; defines the task structure under a project.
  • RA_SALESREPS_ALL — joined on SALESREP_ID; supplies sales representative information.
  • PA_CREDIT_RECEIVERS_PK / _U1 / _U6 — indexes enforcing uniqueness on business keys and the surrogate identifier.
  • Related PA revenue and billing tables (for example, project revenue distribution and transfer-to-AR processes) depend on these credit assignments when calculating who receives revenue credit.

Understanding PA_CREDIT_RECEIVERS is essential for accurate project revenue attribution and downstream Receivables integration within Oracle Projects.