Search Results pa_project_copy_overrides




Overview
Explore in AI Chat

Overview

PA_PROJECT_COPY_OVERRIDES is a Projects (PA) module table that stores the Quick Entry field definitions used when a project is created from a project template. During the "copy project" operation, Oracle Projects presents users with a set of prompts derived from this table, allowing template-driven defaults to be overridden at the point of creation. Each row describes one overridable field — its name, presentation label, ordering, and whether entry is mandatory — so the form can be rendered dynamically rather than hard-coded.

The table is owned by the APPS-facing PA schema and is classified as VALID in both 12.1.1 and 12.2.2. From a Data Vault modeling perspective, the FK relationship to PA_PROJECTS_ALL on PROJECT_ID and the absence of any outgoing child references suggest a satellite-leaning classification: the table hangs off the project hub and carries descriptive, attribute-style content rather than representing an independent business entity or an associative link between two hubs. This is a heuristic suggestion only; the table is a conventional EBS transactional-attribute table, not a formal Data Vault construct.

Key Information Stored

The documented physical schema contains twelve columns. The most significant are:

  • PROJECT_ID — Foreign key to PA_PROJECTS_ALL; identifies the project template or project record whose Quick Entry behavior is being configured.
  • FIELD_NAME — Internal identifier of the field being overridden during the copy operation.
  • DISPLAY_NAME — User-visible prompt or label presented on the Quick Entry form.
  • LIMITING_VALUE — Value constraint applied to the entry, controlling what a user may supply.
  • SORT_ORDER — Sequence in which the field is displayed; part of the composite primary key.
  • MANDATORY_FLAG — Indicates whether the field must be populated before the copy can proceed.
  • RECORD_VERSION_NUMBER — Optimistic locking counter used by the application during concurrent updates.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified each row and when.

The surrogate primary key is PA_PROJECT_COPY_OVERRIDES_PK, defined over (PROJECT_ID, SORT_ORDER). The unique index PA_PROJECT_COPY_OVERRIDES_U1 shares the same column list, making it the business-key candidate: no two override entries may occupy the same display position for the same project. Notably, FIELD_NAME is not part of either key, so field identity is positional within a project.

Common Use Cases and Queries

Typical scenarios include diagnosing why a Quick Entry prompt does not appear during template-based project creation, verifying that mandatory overrides are enforced, and auditing customizations applied to seeded templates.

  • List all Quick Entry fields for a given template in display order:

    SELECT sort_order, field_name, display_name, mandatory_flag, limiting_value
    FROM pa.pa_project_copy_overrides
    WHERE project_id = :p_project_id
    ORDER BY sort_order;

  • Identify templates with mandatory overrides that may block automated project creation:

    SELECT project_id, COUNT(*) mandatory_fields
    FROM pa.pa_project_copy_overrides
    WHERE mandatory_flag = 'Y'
    GROUP BY project_id;

  • Compare override configurations across templates to detect inconsistent or duplicated setups.
  • Reconcile the table against PA_PROJECTS_ALL to confirm orphaned override rows after project deletion.

Related Objects

The following objects are most significant when working with this table:

  • PA_PROJECTS_ALL — Parent of the FK on PROJECT_ID; join key for resolving template names and numbers.
  • PA_PROJECT_COPY_OVERRIDES_PK — Composite primary key on (PROJECT_ID, SORT_ORDER).
  • PA_PROJECT_COPY_OVERRIDES_U1 — Unique index on (PROJECT_ID, SORT_ORDER), enforcing positional uniqueness.
  • PA_PROJECT_TEMPLATES / template setup forms — Configuration UI that reads and writes override rows.
  • Project Copy / Quick Entry concurrent programs and APIs — Runtime consumers that render prompts and apply overrides during project creation.