Search Results purge_project_status

Overview

APPS.PA_PURGE_PROJECTS_V is a reporting and integration view in Oracle E-Business Suite that consolidates project purge activity with descriptive project, status, and organization information. It joins the transactional purge extension table PA_PURGE_PROJECTS with PA_PROJECTS, PA_PROJECT_STATUSES, PA_LOOKUPS, and HR_ORGANIZATION_UNITS to expose human-readable values in place of raw codes. Because the purge extension table stores only coded identifiers, the view exists to translate those codes into status names and lookup meanings that support reporting, reconciliation, and downstream interfaces.

The view is particularly relevant to users who search for project_status_name because it exposes three separate status name columns sourced from PA_PROJECT_STATUSES: the current project status, the next status scheduled by the purge process, and the next project status prior to purge. In EBS 12.1.1 and 12.2.2 the view is owned by APPS and is intended for query access rather than direct maintenance.

Underlying Base Objects

The view is defined over the following documented base objects:

• PA_PURGE_PROJECTS (synonym to the purge extension table) — the driving table containing purge batch, flag, and status code columns.
• PA_PROJECTS (synonym) — provides the project number (SEGMENT1), name, carrying-out organization, project status code, closed date, project type, and ORG_ID.
• PA_PROJECT_STATUSES (synonym) — joined three times (PS1, PS2, PS3) to resolve NEXT_PP_PROJECT_STATUS_CODE, NEXT_P_PROJECT_STATUS_CODE, and PROJECT_STATUS_CODE into PROJECT_STATUS_NAME values.
• PA_LOOKUPS (view) — joined as L4 on LOOKUP_TYPE = 'PURGE_PROJECT_STATUS' and LOOKUP_CODE = PURGE_PROJECT_STATUS_CODE to return MEANING.
• HR_ORGANIZATION_UNITS (view) — joined as O1 on CARRYING_OUT_ORGANIZATION_ID to return the organization NAME.
• HR_GENERAL and HR_SECURITY (packages) — referenced package objects that support the HR organization view and security predicates used by the query.

The join keys are PP.PROJECT_ID = P.PROJECT_ID for project data and P.CARRYING_OUT_ORGANIZATION_ID = O1.ORGANIZATION_ID for organization data, with the three status lookups and the lookup view linked by status and lookup code equality.

Key Columns

• ROW_ID — ROWID of the PA_PURGE_PROJECTS row, useful as a unique identifier for updates or correlation.
• SEGMENT1, NAME — the project number and project name.
• MEANING — the decoded purge project status description from PA_LOOKUPS.
• PROJECT_STATUS_NAME (PS3) — the current status name of the project, exposed alongside PROJECT_STATUS_CODE.
• PROJECT_STATUS_NAME (PS1) and PROJECT_STATUS_NAME (PS2) — the status names corresponding to the next pre-purge and next post-purge status codes.
• PURGE_PROJECT_STATUS_CODE, LAST_PROJECT_STATUS_CODE, NEXT_PP_PROJECT_STATUS_CODE, NEXT_P_PROJECT_STATUS_CODE — coded status values used by the purge process.
• PURGE_BATCH_ID, TXN_TO_DATE, PURGED_DATE — batch grouping, cutoff transaction date, and date the purge was performed.
• PURGE_ACTUALS_FLAG, ARCHIVE_ACTUALS_FLAG, PURGE_BUDGETS_FLAG, ARCHIVE_BUDGETS_FLAG, PURGE_CAPITAL_FLAG, ARCHIVE_CAPITAL_FLAG, PURGE_SUMMARY_FLAG, ARCHIVE_SUMMARY_FLAG — indicators controlling whether each data category is purged or archived.
• CLOSED_DATE, PROJECT_TYPE, CARRYING_OUT_ORGANIZATION_ID, ORG_ID — descriptive project attributes; audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical uses include monitoring purge batches, verifying which projects are eligible or processed, and joining purge activity to project status for audit reporting.

List projects and their current status name:

SELECT segment1, name, project_status_name, purge_project_status_code
FROM   apps.pa_purge_projects_v
WHERE  project_status_name = 'Closed';

Review purge and archive flags by batch:

SELECT purge_batch_id, segment1, name, purged_date,
       purge_actuals_flag, archive_actuals_flag
FROM   apps.pa_purge_projects_v
WHERE  purge_batch_id IS NOT NULL
ORDER  BY purge_batch_id, segment1;

Resolve purge status meaning and next status by organization:

SELECT o1.name organization, v.segment1, v.meaning,
       v.project_status_name, v.next_pp_project_status_code
FROM   apps.pa_purge_projects_v v
WHERE  v.meaning = 'Purged'
ORDER  BY organization, v.segment1;

Because the view applies HR security through the underlying HR organization objects, results may be filtered by the querying user's organization access when HR security is enabled.