R11i: R12: OIE: Expense Report Lines Do Not Match With Header Total - Maximum Amount Of Lines Were Exceeeded for an Expense Report (Doc ID 2017112.1)

Last updated on NOVEMBER 04, 2016

Applies to:

Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.
Expense Report Export
Expense Report Line and Distribution totals do not match
Query has exceeded X rows. Potentially more rows exists, please restrict your query.
Profile option "FND: View Object Max Fetch Size"

Symptoms

On : 12.1.3 version, Expenses Requests

A single expense report  with more than 500 expense lines cannot be exported. The report is rejected form Expense Report Export with the rejection reason Expense Report Line and Distribution totals do not match.   When attempting to view the expense report via the Internet Expense Audit responsibility the following error occurs

ERROR
-----------------------
Warning.
Query has exceeded 500 rows. Potentially more rows exists, please restrict your query.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Enter a report with more than 500 expense lines.
2. Approve the report by both Management and Payables
3. Submit Expense Report Export.
4. The report in question is rejected.
5. View the concurrent request rejections and see rejection reason "Expense Report Line and Distribution totals do not match".

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue the report cannot be imported into Payables as an invoice.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms