PA Expenditure Item Transfer Upload – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Transfers expenditure items to another project or task, as the Transfer action of the Expenditure Items window (Expenditure Inquiry) does, through pa_adjustments.

Enter a To Task, and a To Project for a transfer to another project, on the rows to transfer. Each transferred item is reversed on its current task and recreated on the destination task, which takes its billable or capitalizable flag and transaction controls from there. The result shows the new item, with the original item in Transferred From Item Id. Rows without a To Task are not transferred.

The download lists the items that are not reversed, reversing or related items. An item is rejected with Oracle’s message where the window refuses the transfer, such as an unapproved item, an item already transferred or a date outside the destination project or task dates.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Upload Mode, Operating Unit, Project, Task, Expenditure Item Date From, Expenditure Item Date To, Expenditure Type Class, Expenditure Category, Expenditure Type, Employee, Expenditure Organization, Transaction Source, Expenditure Batch

Oracle EBS Tables Used

pa_system_linkages, per_all_people_f, hr_all_organization_units_vl, pa_transaction_sources, pa_expenditure_comments, pa_expenditure_items_all, pa_expenditures_all, pa_projects_all, pa_tasks, pa_expenditure_types, xxen_report_org_access

Report Categories

Enginatics, R12 only, Upload

GL Account Analysis, GL Account Analysis (Drilldown) (with inventory and WIP), GL Account Distribution Analysis, PA Project Expenditure Items with WIP and INV Detail, GL Account Analysis (Drilldown), PO Purchasing Document Upload, AP Invoices and Lines, GL Account Analysis 11g

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output PA Expenditure Item Transfer Upload 07-Nov-2026 154553.xlsx
Blitz Report™ XML Import PA_Expenditure_Item_Transfer_Upload.xml
SQL Source PA Expenditure Item Transfer Upload.sql
Full Report on Enginatics www.enginatics.com/reports/pa-expenditure-item-transfer-upload/

© Enginatics GmbH