My Oracle Support Banner

Expense Report Export Error ORA-06512 Ap_web_export_er (Doc ID 1172965.1)

Last updated on JANUARY 16, 2018

Applies to:

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


In R12, When attempting to run the expense report export, the following error occurs.

Oracle error 1422 in FDPSTP
Cause : FDPSTP failed due to ORA-01422: exact fetch returns more than requested number of rows
ORA:06512: at "APPS.AP_WEB_EXPORT_ER", line 1911
ORA-06512: at line 1

The issue can be reproduced at will with the following steps:
1. Create a prepayment invoice and pay the same
2. Create an expense report  and apply the above prepayment
3. Run Expense Report Export program

The issue has the following business impact:
Due to this issue, users cannot create expense report invoices. Payments to employees are due.


To view full details, 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 a vibrant support community of peers and Oracle experts.