Results for “change_code”
6 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_EXPENDITURE_HISTORY_V is an APPS-schema database view in the Oracle E-Business Suite Projects (PA) module. Its documented purpose is to support the Online Expenditure Entry Form, where it provides the historical audit trail of changes made to expenditure items. Every time a user adjusts, reverses, or otherwise modifies an expenditure item through the online entry form, a corresponding history row is captured and exposed through this view for display and review.
Functionally, the view presents a denormalized, presentation-ready record of expenditure change history: it joins the raw history table to project, task, employee, and lookup information so that a form or report can render meaningful descriptions (project name, task name, employee name, and a translated change reason) rather than internal numeric identifiers. As a view rather than a table, it stores no data of its own; it is a read-only query layer over the PA_EXPENDITURE_HISTORY base object. Because it is owned by APPS and relies on PA security-aware underlying views, it participates in the standard Oracle EBS multi-organization and project security model. In 12.1.1 and 12.2.2 the object remains VALID and its definition is unchanged between the two releases for the documented columns.
Underlying Base Objects
The view text selects from five primary database objects joined together:
- PA_EXPENDITURE_HISTORY (H) — the transactional history table that is the foundation of the view; referenced through a synonym in the APPS schema. It supplies the change records, expenditure identifiers, project/task IDs, amounts, quantities, descriptive flexfield attributes, and audit columns.
- PA_PROJECTS_EXPEND_V (P) — a project security view supplying PROJECT_NUMBER and PROJECT_NAME for the expenditure's project.
- PA_TASKS_EXPEND_V (T) — a task security view supplying TASK_NUMBER and TASK_NAME for the expenditure's task.
- PA_EMPLOYEES (E) — a date-tracked employee view supplying FULL_NAME and EMPLOYEE_NUMBER for the person who incurred the expenditure. The join enforces
TRUNC(SYSDATE) BETWEEN E.EFFECTIVE_START_DATE AND E.EFFECTIVE_END_DATE, so only the currently effective employee record is returned. - PA_LOOKUPS (L) — joined on LOOKUP_TYPE = 'ONLINE_EXP_CHANGE_REASON' to translate the CHANGE_CODE into a user-facing meaning.
The documented metadata further lists supporting packages invoked by the underlying security views: FND_PROFILE, HR_GENERAL, HR_PERSON_NAME, HR_SECURITY, PA_CROSS_BUSINESS_GRP, PA_PROJECT_UTILS, PA_TASK_UTILS, and PA_UTILS4. These provide profile-option resolution, person-name formatting, and cross-business-group security filtering that govern which projects, tasks, and employees a given user may see.
Key Columns
The view exposes the full set of history and descriptive attributes. Notable columns include:
- EXPENDITURE_ID / DENORM_ID — identifiers linking the history record to the originating expenditure item.
- ADJUSTED_EXPENDITURE_ITEM_ID — the expenditure item created or affected by the adjustment.
- INCURRED_BY_PERSON_ID, EMPLOYEE_NAME, EMPLOYEE_NUMBER — the incurring person and their formatted name and number.
- PROJECT_ID, PROJECT_NUMBER, PROJECT_NAME — project context; TASK_ID, TASK_NUMBER, TASK_NAME — task context.
- EXPENDITURE_CLASS_CODE, EXPENDITURE_SOURCE_CODE, EXPENDITURE_TYPE, SYSTEM_LINKAGE_FUNCTION — classification and origin of the expenditure.
- EXPENDITURE_ITEM_DATE, QUANTITY — the item date and quantity on the history record.
- CHANGE_CODE and CHANGE_MEANING — the raw change reason code and its decoded lookup meaning (the displayed CHANGE_MEANING is what the form presents).
- ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE10 — descriptive flexfield context and segments.
- EXPENDITURE_ITEM_COMMENT — free-text comment captured with the change.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard Who columns for audit.
Common Use Cases and Queries
Typical uses include reviewing the change history of a specific expenditure item in a custom form or concurrent report, auditing who adjusted which expenditures and why, and reconciling adjustments for a project or date range. Because the view is already joined and security-filtered, it is convenient for ad hoc reporting in Oracle Projects.
Example: retrieve the change history for a given expenditure item.
SELECT expenditure_id, adjusted_expenditure_item_id, change_meaning, employee_name, expenditure_item_date, quantity, expenditure_item_comment, creation_date FROM apps.pa_expenditure_history_v WHERE expenditure_id = :p_expenditure_id ORDER BY creation_date DESC;
Example: list changes by project and date range for audit purposes.
SELECT project_number, project_name, task_number, employee_name, change_meaning, expenditure_item_date, creation_date FROM apps.pa_expenditure_history_v WHERE project_id = :p_project_id AND creation_date BETWEEN :p_from AND :p_to ORDER BY project_number, creation_date;
Because row visibility is governed by PA project and HR security plus FND profile options, results automatically respect the querying user's access. Analysts should note that use of TRUNC(SYSDATE) in the employee join means name data reflects only currently effective employee records, and that CHANGE_MEANING depends on the ONLINE_EXP_CHANGE_REASON lookup being populated.
-
For Online Expenditure Entry Form
APPS.PA_EXPENDITURE_HISTORY_V·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore PA module →
-
Audit records for self service time
-
Pa_Expenditure_History_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
-
Pa_Expenditure_History_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
-
For Online Expenditure Entry Form
APPS.PA_EXPENDITURE_HISTORY_V·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore PA module →
-
Audit records for self service time