My Oracle Support Banner

R12:OIE:Expense Report Export Completes in Error :"ORA-01422: exact fetch returns more than requested number of rows occurred in GetExpenseClearingCCID with parameters ()" (Doc ID 3028506.1)

Last updated on JUNE 14, 2024

Applies to:

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

Symptoms

Expense Report Export Program completes with below mentioned error in log file

ORA-01422: exact fetch returns more than requested number of rows occurred in
GetExpenseClearingCCID
with parameters ()
while performing the following operation:


Steps to reproduce the issue:
--------------------------------
1. Navigate to Internet Expenses Administrator Responsibility -> Create Expense Report for Credit Card Transaction.
2. Once the Expense Report is approved then run Expense Report Export Program.
3. Expense Report Export Program completes in error with mentioned error.

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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