My Oracle Support Banner

R12: AP: Expense Report Export Process Rejects Expense Reports With Message: Invoice Line Amount Is Null (Doc ID 1913609.1)

Last updated on FEBRUARY 21, 2020

Applies to:

Oracle Internet Expenses - Version 12.0.0 and later
Information in this document applies to any platform.


In Oracle Internet Expenses, Expense Report failed with rejection reason: invoice line amount is null; however, there is no line with 0 value.  The issue pertains to the Expense Report Export process that creates AP invoices from iExpenses.

The Expense Report status updates to 'Ready for Payment' suggesting no further actions can be taken in iExpenses.

1. Seeking the explanation for the issue, and
2. A fix for the expense report to reprocess it successfully.

Steps to reproduce

1. The expense repor (ER)t is created, submitted, and audited.
2. Run the Expense Report Export. The ER is rejected with the reason "Invoice Line amount is null"

The following query identifies data:

select * from ap_expense_report_lines_all
where amount is null
and report_header_id in (
select report_header_id
from ap_expense_report_headers_all
where invoice_num = '&expense_report_num');



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Standard Patching Process
 Patch Wizard
 Enhancement Requests
 Have more questions?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.