Results for “expenditure_comment”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_EXPENDITURE_COMMENTS is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores free-text comments attached to expenditure items. These comments explain or further describe the work performed against a project, task, or award, and are typically entered by users during expenditure entry, expense report submission, or timecard processing. Because a single expenditure item can carry multiple sequenced comments, the table functions as a detail-level narrative store rather than a master record.
In Data Vault modeling terms, the mined foreign-key structure classifies PA_EXPENDITURE_COMMENTS as satellite-leaning. It hangs off the PA_EXPENDITURE_ITEMS_ALL hub via EXPENDITURE_ITEM_ID and extends that entity with descriptive, non-key context (the comment text itself plus audit attributes). This is consistent with its role: it never independently identifies an expenditure item, and it derives its identity entirely from the parent item.
Key Information Stored
The table is defined in the PA schema with twelve documented columns. The most significant are described below, separating the surrogate primary key from business-key candidates.
- EXPENDITURE_ITEM_ID — Foreign key to PA_EXPENDITURE_ITEMS_ALL; identifies the expenditure item to which the comment belongs. Also part of the composite primary key.
- LINE_NUMBER — Sequence number that differentiates multiple comments on the same expenditure item. Also part of the primary key.
- EXPENDITURE_COMMENT — The free-text narrative entered to explain or further describe work performed.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY — Standard WHO audit columns tracking who created and most recently changed each row.
- LAST_UPDATE_LOGIN — Login identifier associated with the last update.
- REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — Concurrent program context capturing the request and program that last touched the row.
The surrogate primary key is PA_EXPENDITURE_COMMENTS_PK, defined on (EXPENDITURE_ITEM_ID, LINE_NUMBER). The unique index PA_EXPENDITURE_COMMENTS_U1 carries the same pair, making (EXPENDITURE_ITEM_ID, LINE_NUMBER) the definitive business-key candidate: an item and its comment line number uniquely determine a row. The single foreign key, PA_EXPENDITURE_COMMENTS.EXPENDITURE_ITEM_ID → PA_EXPENDITURE_ITEMS_ALL, enforces that every comment is anchored to a valid expenditure item.
Common Use Cases and Queries
Typical uses include retrieving all comments for an expenditure item, auditing who entered narrative text, and reporting on comments by project or date. A representative query joins the parent item table:
- Retrieve comments for one item:
SELECT LINE_NUMBER, EXPENDITURE_COMMENT FROM PA_EXPENDITURE_COMMENTS WHERE EXPENDITURE_ITEM_ID = :item_id ORDER BY LINE_NUMBER; - Audit trail: select CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE to trace authoring.
- Project-level reporting: join PA_EXPENDITURE_COMMENTS to PA_EXPENDITURE_ITEMS_ALL on EXPENDITURE_ITEM_ID, then to project/task tables, filtering by EXPENDITURE_COMMENT for keyword analysis.
- Integration extracts: use REQUEST_ID / PROGRAM_ID to identify comments generated by specific concurrent processes.
Because the table is detail-level and append-oriented, reporting queries should always order by LINE_NUMBER to preserve the intended comment sequence.
Related Objects
The following objects are most significant to working with PA_EXPENDITURE_COMMENTS, based on the documented FK/PK relationships:
- PA_EXPENDITURE_ITEMS_ALL — Parent table; joined on EXPENDITURE_ITEM_ID. The FK from PA_EXPENDITURE_COMMENTS points here.
- PA_EXPENDITURE_ITEMS_ALL related project/task columns — used to roll comments up to a project or task for reporting.
- Expenditure entry and expense report APIs that accept comment text and populate this table.
- Concurrent programs identified by PROGRAM_ID / REQUEST_ID that write comment rows.
- Projects reporting views that surface expenditure narrative alongside item amounts.
With only one documented foreign key, PA_EXPENDITURE_COMMENTS remains tightly coupled to PA_EXPENDITURE_ITEMS_ALL, and its satellite classification reflects that dependency.
-
Free text entered for expenditure items to explain or further describe work performed
-
Personal aliases for free text expenditure comments used when entering on-line timecards and expense reports
-
10SC Only
APPS.PA_EXPND_ITEMS_REVIEW_V·↳ PA_CURRENCY·↳ PA_EXPENDITURE_COMMENTS·↳ PA_EXPENDITURE_ITEMS·Explore PA module →
-
Personal aliases for free text expenditure comments used when entering on-line timecards and expense reports
-
Free text entered for expenditure items to explain or further describe work performed
-
Pa_Expenditure_Comments_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
-
10SC Only
APPS.PA_DRAFT_INV_LINE_DETAILS_V·↳ FND_LOOKUP_VALUES·↳ GL_DAILY_CONVERSION_TYPES·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PA module →
-
Pa_Expenditure_Comments_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
-
APPS.GMS_DRAFT_INV_LINE_DETAILS_V·↳ FND_LOOKUP_VALUES·↳ GL_DAILY_CONVERSION_TYPES·↳ GMS_AWARD_DISTRIBUTIONS·Explore GMS module →
-
10SC Only
APPS.PA_EXPND_ITEMS_REVIEW_V·↳ PA_CURRENCY·↳ PA_EXPENDITURE_COMMENTS·↳ PA_EXPENDITURE_ITEMS·Explore PA module →
-
10SC Only
APPS.PA_DRAFT_INV_LINE_DETAILS_V·↳ FND_LOOKUP_VALUES·↳ GL_DAILY_CONVERSION_TYPES·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PA module →
-
Release 10SC Only
APPS.PA_ASSET_LINE_DETAILS_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PA module →
-
View: PA_STATUS_EI_V 12.2.2
APPS.PA_STATUS_EI_V·↳ GL_DAILY_CONVERSION_TYPES·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PA_COST_DIST_LINES_ALL_BAS·Explore PA module →
-
View: PA_STATUS_EI_V 12.1.1
APPS.PA_STATUS_EI_V·↳ GL_DAILY_CONVERSION_TYPES·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PA_COST_DIST_LINES_ALL_BAS·Explore PA module →
-
11i Only
APPS.PA_EXPEND_ITEMS_ADJUST2_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PA module →
-
Release 10SC Only
APPS.PA_ASSET_LINE_DETAILS_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PA module →
-
This view shows all expenditure items
APPS.PA_EXPENDITURE_ITEMS_ONLINE_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PA module →
-
11i Only
APPS.PA_EXPEND_ITEMS_ADJUST2_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PA module →
-
10SC Only
APPS.PA_CUST_REV_DIST_LINES_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PA module →
-
10SC Only
APPS.PA_CUST_REV_DIST_LINES_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PA module →
-
View: PA_EXPENDITURE_ITEMS_V 12.1.1
10SC Only
APPS.PA_EXPENDITURE_ITEMS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PA module →
-
Single-Org
APPS.PA_TRANSACTION_INTERFACE_V·↳ FND_GLOBAL·↳ FND_NEW_MESSAGES·↳ PA_LOOKUPS·Explore PA module →
-
Pa_Txn_Interface_Audit_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
-
View: PA_EXPENDITURE_ITEMS_V 12.2.2
10SC Only
APPS.PA_EXPENDITURE_ITEMS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore PA module →
-
Single-Org
APPS.PA_TRANSACTION_INTERFACE_V·↳ FND_GLOBAL·↳ FND_NEW_MESSAGES·↳ PA_LOOKUPS·Explore PA module →
-
APPS.GMS_EXPEND_ITEMS_ADJUST_V·↳ FND_LOOKUP_VALUES·↳ GMS_AWARD_DISTRIBUTIONS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore GMS module →
-
Interface table to import transactions from external sources into Oracle Projects
-
This Table is used to store Tax Records interfaced to Projects Costing
-
Interface table to import transactions from external sources into Oracle Projects
-
10SC Only
APPS.PA_EXPEND_ITEMS_ADJUST_V·↳ FND_LOOKUP_VALUES·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·Explore PA module →
-
Auditing information about updates on PA_TRANSACTION_INTERFACE_ALL
-
APPS.PA_EXPEND_ITEMS_ADJUST_ALL_V·↳ FND_LOOKUP_VALUES·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·Explore PA module →
-
APPS.GMS_EXPEND_ITEMS_ADJUST_V·↳ FND_LOOKUP_VALUES·↳ GMS_AWARD_DISTRIBUTIONS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore GMS module →
-
APPS.GMS_DRAFT_INV_LINE_DETAILS_V·↳ FND_LOOKUP_VALUES·↳ GL_DAILY_CONVERSION_TYPES·↳ GMS_AWARD_DISTRIBUTIONS·Explore GMS module →
-
Pa_Txn_Interface_Audit_ar is a table for Archive/Purge. Refer to comments on the columns in the main table
-
APPS.PA_EXPEND_ITEMS_ADJUST_ALL_V·↳ FND_LOOKUP_VALUES·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·Explore PA module →
-
Auditing information about updates on PA_TRANSACTION_INTERFACE_ALL
-
10SC Only
APPS.PA_EXPEND_ITEMS_ADJUST_V·↳ FND_LOOKUP_VALUES·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·Explore PA module →
-
VIEW: PA.PA_EXP_COMMENTS_AR# 12.2.2
-
VIEW: PA.PA_EXP_COMMENTS_AR# 12.2.2
-
TABLE: PA.PA_EXP_COMMENTS_AR 12.2.2
-
TABLE: PA.PA_EXP_COMMENTS_AR 12.1.1
-
View: PA_TXN_INTERFACE_AUDIT 12.1.1
Single-Org
Not implemented in this database·Explore PA module →