Search Results time
The PA_EXPENDITURE_HISTORY
table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical data structure within the Project Accounting (PA) module. It serves as a historical repository for expenditure-related transactions, capturing changes over time to support audit trails, reporting, and reconciliation processes. Below is a detailed analysis of its purpose, structure, key columns, and functional significance.
Purpose and Functional Context
ThePA_EXPENDITURE_HISTORY
table stores historical snapshots of expenditure records from the PA_EXPENDITURES_ALL
table. It tracks modifications to expenditure data, such as adjustments to cost amounts, dates, or project assignments, ensuring compliance with financial auditing requirements. This table is integral to Oracle Project Accounting’s ability to maintain data integrity and provide visibility into expenditure lifecycle changes.
Key Columns and Structure
The table includes columns that mirror thePA_EXPENDITURES_ALL
table, along with additional metadata to track historical changes. Key columns include:
- EXPENDITURE_ID: Primary key reference to the original expenditure record.
- LAST_UPDATE_DATE: Timestamp of the last modification.
- CREATION_DATE: Date when the historical record was created.
- LAST_UPDATED_BY: User ID of the person who modified the record.
- VERSION_NUM: Sequential number to track versions of the same expenditure.
- SYSTEM_LINKAGE: Indicates whether the expenditure was imported from an external system (e.g., Payables, Labor Tracking).
- EXPENDITURE_END_DATE: The end date of the expenditure period.
- ORG_ID: Organization identifier for multi-org environments.
- ATTRIBUTE_CATEGORY/ATTRIBUTE1-30: Flexfield columns for custom attributes.
Data Flow and Integration
The table is populated automatically by Oracle EBS when expenditure records are created, updated, or adjusted. Key integration points include:- Oracle Payables: Expenditures imported from invoices.
- Oracle Time & Labor (OTL): Labor cost transactions.
- Oracle Projects: Direct entry of project-related expenditures.
PA_EXPENDITURE_PUB
) ensure historical records are generated whenever changes occur.
Reporting and Auditing
ThePA_EXPENDITURE_HISTORY
table supports:
- Audit Reports: Tracks who changed what data and when.
- Historical Analysis: Enables comparison of expenditure data across versions.
- Compliance: Meets regulatory requirements for financial data retention.
Technical Considerations
- Indexing: Typically indexed on
EXPENDITURE_ID
andVERSION_NUM
for performance. - Partitioning: In large implementations, partitioning by date may improve query performance.
- Purge Policies: Historical data should be archived or purged periodically to manage storage.
Customization and Extensions
The table can be extended using descriptive flexfields (DFFs) to capture additional attributes. Custom workflows or triggers may also be added to enforce business rules during historical record creation.Conclusion
ThePA_EXPENDITURE_HISTORY
table is a foundational component of Oracle Project Accounting, providing traceability and compliance for expenditure transactions. Its design ensures data accuracy, supports auditability, and integrates seamlessly with other EBS modules. Proper management of this table is essential for organizations relying on Oracle EBS for project financials.
-
Lookup Type: BUDGET TIME PHASED TYPE
12.1.1
product: PA - Projects , meaning: Budget Time Phased Type , description: Budget Time Phased Type ,
-
Lookup Type: BUDGET TIME PHASED TYPE
12.2.2
product: PA - Projects , meaning: Budget Time Phased Type , description: Budget Time Phased Type ,
-
Lookup Type: TIME_CHART_RECORD_TYPE
12.2.2
product: PA - Projects , meaning: Time Chart Record Type , description: Time Chart Record Type ,
-
Lookup Type: TIME_CHART_RECORD_TYPE
12.1.1
product: PA - Projects , meaning: Time Chart Record Type , description: Time Chart Record Type ,
-
Lookup Type: EXPENDITURE SOURCE
12.1.1
product: PA - Projects , meaning: Expenditure Source , description: Expenditure Source ,
-
Lookup Type: EXPENDITURE CLASS CODE
12.2.2
product: PA - Projects , meaning: Expenditure Class Code , description: Expenditure Class Code ,
-
Lookup Type: EXPENDITURE SOURCE
12.2.2
product: PA - Projects , meaning: Expenditure Source , description: Expenditure Source ,
-
Lookup Type: EXPENDITURE CLASS CODE
12.1.1
product: PA - Projects , meaning: Expenditure Class Code , description: Expenditure Class Code ,
-
Lookup Type: PA_GANTT_BAR_TYPES_CODE
12.1.1
product: PA - Projects , meaning: Gantt Bar Types , description: Gantt bar types ,
-
Lookup Type: PA_GANTT_BAR_TYPES_CODE
12.2.2
product: PA - Projects , meaning: Gantt Bar Types , description: Gantt bar types ,
-
View: PA_ONLINE_TASKS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_ONLINE_TASKS_V, object_name:PA_ONLINE_TASKS_V, status:VALID, product: PA - Projects , description: Customizable view for tasks used in Self Service Time, Oracle Time Capture, and Sel f Service Expense applications. PA_ONLINE_TASKS_V is a customizable view for Self Service Time application , Oracle Time Capture, and Self Service Expense. , implementation_dba_data: APPS.PA_ONLINE_TASKS_V ,
-
View: PA_ONLINE_TASKS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_ONLINE_TASKS_V, object_name:PA_ONLINE_TASKS_V, status:VALID, product: PA - Projects , description: Customizable view for tasks used in Self Service Time, Oracle Time Capture, and Sel f Service Expense applications. PA_ONLINE_TASKS_V is a customizable view for Self Service Time application , Oracle Time Capture, and Self Service Expense. , implementation_dba_data: APPS.PA_ONLINE_TASKS_V ,
-
Lookup Type: DATA TYPE
12.2.2
product: PA - Projects , meaning: Meaning N/A for : DATA TYPE , description: Data type ,
-
Lookup Type: DATA TYPE
12.1.1
product: PA - Projects , meaning: Meaning N/A for : DATA TYPE , description: Data type ,
-
Lookup Type: ADJUST INVOICE ITEM ACTION
12.1.1
product: PA - Projects , meaning: Adjust Invoice Item Action , description: Adjust Invoice Item Action ,
-
Lookup Type: ADJUST INVOICE ITEM ACTION
12.2.2
product: PA - Projects , meaning: Adjust Invoice Item Action , description: Adjust Invoice Item Action ,
-
View: PA_BUDGET_PERIODS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_BUDGET_PERIODS_V, object_name:PA_BUDGET_PERIODS_V, status:VALID, product: PA - Projects , description: R10SC Only - A view of all the periods used in time-phased budget entry , implementation_dba_data: APPS.PA_BUDGET_PERIODS_V ,
-
View: PA_BUDGET_PERIODS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_BUDGET_PERIODS_V, object_name:PA_BUDGET_PERIODS_V, status:VALID, product: PA - Projects , description: R10SC Only - A view of all the periods used in time-phased budget entry , implementation_dba_data: APPS.PA_BUDGET_PERIODS_V ,
-
Lookup Type: TIMELINE_SCALE_TYPE
12.1.1
product: PA - Projects , meaning: Timeline Time Scale , description: Timeline Time Scale ,
-
Lookup Type: ADJUST INVOICE ACTION
12.2.2
product: PA - Projects , meaning: Adjust Invoice Action , description: Adjust Invoice Action ,
-
Lookup Type: TIMELINE_SCALE_TYPE
12.2.2
product: PA - Projects , meaning: Timeline Time Scale , description: Timeline Time Scale ,
-
Lookup Type: PA_FP_PP_PERIOD_TYPE
12.2.2
product: PA - Projects , meaning: Time phasing code for period profile , description: Time phasing code for period profile ,
-
Lookup Type: ADJUST INVOICE ACTION
12.1.1
product: PA - Projects , meaning: Adjust Invoice Action , description: Adjust Invoice Action ,
-
Lookup Type: PA_FP_PP_PERIOD_TYPE
12.1.1
product: PA - Projects , meaning: Time phasing code for period profile , description: Time phasing code for period profile ,
-
Lookup Type: BILLING HOLD CRITERIA
12.1.1
product: PA - Projects , meaning: Billing Hold Criteria , description: Billing Hold Criteria ,
-
View: PA_ONLINE_WORK_TYPES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_ONLINE_WORK_TYPES_V, object_name:PA_ONLINE_WORK_TYPES_V, status:VALID, product: PA - Projects , description: Customizable view for projects used in Self Service Time application. PA_ONLINE_WORK_TYPES_V is a customizable view for Self Service Time application , implementation_dba_data: APPS.PA_ONLINE_WORK_TYPES_V ,
-
Lookup Type: BILLING HOLD CRITERIA
12.2.2
product: PA - Projects , meaning: Billing Hold Criteria , description: Billing Hold Criteria ,
-
Lookup Type: GANTT_TIME_SCALE
12.1.1
product: PA - Projects , meaning: Gantt Time Scales , description: Gantt Time Scales ,
-
View: PA_ONLINE_LOCATIONS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_ONLINE_LOCATIONS_V, object_name:PA_ONLINE_LOCATIONS_V, status:VALID, product: PA - Projects , description: Customizable view for projects used in Self Service Time application. PA_ONLINE_LOCATIONS_V is a customizable view for Self Service Time application , implementation_dba_data: APPS.PA_ONLINE_LOCATIONS_V ,
-
Lookup Type: ADJUST EXP ITEM ACTION
12.1.1
product: PA - Projects , meaning: Adjust Exp Item Action , description: Adjust Exp Item Action ,
-
Lookup Type: GANTT_TIME_SCALE
12.2.2
product: PA - Projects , meaning: Gantt Time Scales , description: Gantt Time Scales ,
-
View: PA_ONLINE_JOBS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_ONLINE_JOBS_V, object_name:PA_ONLINE_JOBS_V, status:VALID, product: PA - Projects , description: Customizable view for projects used in Self Service Time application. PA_ONLINE_JOBS_V is a customizable view for Self Service Time application , implementation_dba_data: APPS.PA_ONLINE_JOBS_V ,
-
Lookup Type: ADJUST EXP ITEM ACTION
12.2.2
product: PA - Projects , meaning: Adjust Exp Item Action , description: Adjust Exp Item Action ,
-
View: PA_ONLINE_PROJECTS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_ONLINE_PROJECTS_V, object_name:PA_ONLINE_PROJECTS_V, status:VALID, product: PA - Projects , description: Customizable view for projects used in Self Service Time application. PA_ONLINE_PROJECTS_V is a customizable view for Self Service Time application , implementation_dba_data: APPS.PA_ONLINE_PROJECTS_V ,
-
View: PA_ONLINE_PROJECTS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_ONLINE_PROJECTS_V, object_name:PA_ONLINE_PROJECTS_V, status:VALID, product: PA - Projects , description: Customizable view for projects used in Self Service Time application. PA_ONLINE_PROJECTS_V is a customizable view for Self Service Time application , implementation_dba_data: APPS.PA_ONLINE_PROJECTS_V ,
-
Lookup Type: REVIEW MASS UPDATE OPTION
12.1.1
product: PA - Projects , meaning: Review Mass Update Option , description: Review Mass Update Option ,
-
Lookup Type: REVIEW MASS UPDATE OPTION
12.2.2
product: PA - Projects , meaning: Review Mass Update Option , description: Review Mass Update Option ,
-
Lookup Type: REVIEW EXP ITEM OPTION
12.1.1
product: PA - Projects , meaning: Review Exp Item Option , description: Review Exp Item Option ,
-
Lookup Type: REVIEW EXP ITEM OPTION
12.2.2
product: PA - Projects , meaning: Review Exp Item Option , description: Review Exp Item Option ,
-
Table: PA_EXPENDITURE_HISTORY
12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_EXPENDITURE_HISTORY, object_name:PA_EXPENDITURE_HISTORY, status:VALID, product: PA - Projects , description: Audit records for self service time , implementation_dba_data: PA.PA_EXPENDITURE_HISTORY ,
-
Table: PA_ONLINE_EXP_SETTINGS
12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_ONLINE_EXP_SETTINGS, object_name:PA_ONLINE_EXP_SETTINGS, status:VALID, product: PA - Projects , description: User defined preferences for self service time entry. , implementation_dba_data: PA.PA_ONLINE_EXP_SETTINGS ,
-
Table: PA_EXPENDITURE_HISTORY
12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_EXPENDITURE_HISTORY, object_name:PA_EXPENDITURE_HISTORY, status:VALID, product: PA - Projects , description: Audit records for self service time , implementation_dba_data: PA.PA_EXPENDITURE_HISTORY ,
-
Table: PA_ONLINE_EXP_SETTINGS
12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_ONLINE_EXP_SETTINGS, object_name:PA_ONLINE_EXP_SETTINGS, status:VALID, product: PA - Projects , description: User defined preferences for self service time entry. , implementation_dba_data: PA.PA_ONLINE_EXP_SETTINGS ,
-
Table: PA_EI_DENORM
12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_EI_DENORM, object_name:PA_EI_DENORM, status:VALID, product: PA - Projects , description: Denormalized expenditure item records for online time entry , implementation_dba_data: PA.PA_EI_DENORM ,
-
Table: PA_EI_DENORM
12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_EI_DENORM, object_name:PA_EI_DENORM, status:VALID, product: PA - Projects , description: Denormalized expenditure item records for online time entry , implementation_dba_data: PA.PA_EI_DENORM ,
-
Table: PA_PTE_FLEX_VALUES
12.1.1
product: PA - Projects , description: Temporary holding table used to download descriptive flexfield values to Oracle Personal Time and Expense , implementation_dba_data: Not implemented in this database ,
-
Table: PA_PTE_FLEX_VALUES
12.2.2
product: PA - Projects , description: Temporary holding table used to download descriptive flexfield values to Oracle Personal Time and Expense , implementation_dba_data: Not implemented in this database ,
-
Table: PA_PTE_DESCRIPTIVE_FLEXS
12.2.2
product: PA - Projects , description: Temporary holding table used to download descriptive flexfields to Oracle Personal Time and Expense , implementation_dba_data: Not implemented in this database ,
-
Table: PA_PTE_DESCRIPTIVE_FLEXS
12.1.1
product: PA - Projects , description: Temporary holding table used to download descriptive flexfields to Oracle Personal Time and Expense , implementation_dba_data: Not implemented in this database ,
-
Table: PA_PTE_FLEX_VALUE_SETS
12.1.1
product: PA - Projects , description: Temporary holding table used to download descriptive flexfield value sets to Oracle Personal Time and Expense , implementation_dba_data: Not implemented in this database ,