My Oracle Support Banner

R12:AP: Error when Creating Expense Report - "ORA-01422: exact fetch returns more than requested number of rows occurred in GetAPSysCUrrencySetupInfo" (Doc ID 2618926.1)

Last updated on JULY 10, 2020

Applies to:

Oracle Internet Expenses - Version 11.5.10.2 to 12.2.9 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Symptoms

In Internet Expenses, when attempting to create an expense report, the following error occurs.

ERROR
-----------------------

Exception Details.
 oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20001: APP-SQLAP-10000: ORA-01422: exact fetch returns more than requested number of rows occurred in
GetAPSysCUrrencySetupInfo
with parameters ()
while performing the following operation:
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.AP_WEB_OA_MAINFLOW_PKG", line 1162
ORA-06512: at line 1




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into EBS with Internet Expense responsibility
2. Expenses Entry > Create Expense Report




Changes

Synonym  APPS.AP_SYSTEM_PARAMETERS_ALL was dropped and recreated.

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
References


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