R11i: R12: OIE: Expense Report Lines Do Not Match With Header Total - Maximum Amount Of Lines Were Exceeeded for an Expense Report
Last updated on APRIL 11, 2018
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"
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
Query has exceeded 500 rows. Potentially more rows exists, please restrict your query.
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".
The issue has the following business impact:
Due to this issue the report cannot be imported into Payables as an invoice.
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