Search Results pa_draft_revenue_items




Overview
Explore in AI Chat

Overview

The PA_DRAFT_REVENUE_ITEMS table is a core transactional table within the Oracle E-Business Suite Projects (PA) module, specifically in releases 12.1.1 and 12.2.2. It serves as the detailed line-level repository for draft revenue transactions. This table is integral to the revenue recognition and billing processes, holding proposed revenue items before they are finalized and transferred to permanent revenue tables. Its role is to provide a staging area where revenue lines can be created, reviewed, and adjusted prior to formal generation and posting, ensuring data integrity and auditability in complex project accounting cycles.

Key Information Stored

The table stores detailed attributes for each draft revenue line item. Its primary key is a composite of PROJECT_ID, DRAFT_REVENUE_NUM, and LINE_NUM, uniquely identifying each item within a draft revenue batch. Key columns include TASK_ID, linking the item to a specific project task, and multiple currency code fields (REVPROC_CURRENCY_CODE, PROJFUNC_CURRENCY_CODE, PROJECT_CURRENCY_CODE, FUNDING_CURRENCY_CODE) that support the multi-currency capabilities of Oracle Projects. The table holds the raw revenue amounts, quantities, rates, and descriptive information that constitute the draft revenue line. Foreign key constraints enforce referential integrity with parent tables like PA_DRAFT_REVENUES_ALL for the header and PA_TASKS for the task assignment.

Common Use Cases and Queries

Primary use cases involve auditing draft revenue batches, troubleshooting revenue generation issues, and creating custom reports on pending revenue. A common query pattern retrieves all draft items for a specific project or draft batch to review details before finalization. For example: SELECT dri.line_num, dri.task_id, t.task_number, dri.raw_revenue_amount
FROM pa_draft_revenue_items dri,
pa_tasks t
WHERE dri.project_id = :p_project_id
AND dri.draft_revenue_num = :p_draft_num
AND dri.task_id = t.task_id
ORDER BY dri.line_num; Another critical scenario is identifying draft items linked to specific customer events or revenue distribution lines by joining to related tables like PA_CUST_EVENT_RDL_ALL. Data from this table is often used in reconciliation reports between draft and final posted revenue.

Related Objects

PA_DRAFT_REVENUE_ITEMS has extensive relationships within the Projects schema. Its primary parent is the PA_DRAFT_REVENUES_ALL table, which stores the header information for each draft revenue batch. It is a key parent table for several distribution and multi-currency sub-ledger tables, including:

These child tables store detailed accounting distributions for the draft revenue items. Furthermore, the table references PA_TASKS for task details and FND_CURRENCIES for currency validation across its four currency code columns, highlighting its central role in the project revenue accounting workflow.