AP Expense Report Upload – Oracle EBS SQL Report

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

Overview

Creates and updates expense reports - the Excel equivalent of the Payables Expense Reports form (Invoices > Entry > Expense Reports) - and transfers them to Payables invoices with Expense Report Export.

Each row is one expense report line, with the expense report header columns repeated on every line. The header values are taken from the first row of each expense report. An expense report is identified by Employee and Invoice Num.

Each expense report is processed as a whole: when any of its rows fails validation, none of its rows are saved. The Amount must equal the total of the lines; leave it unchanged to set it to the total of the lines.

The account of a line defaults from the GL Account of the expense report, overlaid with the account segments of the expense item, as in the form. Set Delete Line to Yes to delete a line.

With Submit Expense Report Export set to Yes, Expense Report Export runs for the operating units of the uploaded expense reports and creates the Payables invoices. As in Payables, it transfers every expense report pending export in the operating unit, also those not in the upload file. Rows of an expense report that it did not transfer (rejected, or on hold) show the reason as an error, and the expense report can be corrected and uploaded again. An exported expense report cannot be changed.

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, Submit Expense Report Export, Operating Unit, Employee Name, Invoice Num, Report Date From, Report Date To, Not Exported Only

Oracle EBS Tables Used

ap_lookup_codes, ap_expense_report_headers_all, hr_all_organization_units_vl, per_people_x, gl_code_combinations_kfv, ap_expense_reports_all, gl_daily_conversion_types, ap_awt_groups, ap_expense_report_lines_all, fnd_territories_vl, pa_projects_all, pa_tasks, mo_glob_org_access_tmp

Report Categories

Enginatics, R12 only, Upload

AP Invoices and Lines, AP Invoice Upload, GL Account Distribution Analysis, GL Account Analysis, PO Headers and Lines, AP Invoices and Lines 11i, INV Items, GL Account Analysis (Drilldown) (with inventory and WIP), PO Purchase Requisitions with PO Details

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 Example
Blitz Report™ XML Import AP_Expense_Report_Upload.xml
SQL Source AP Expense Report Upload.sql
Full Report on Enginatics www.enginatics.com/reports/ap-expense-report-upload/

© Enginatics GmbH