My Oracle Support Banner

In Oracle Contract Lifecycle Management, Error with Exact Fetch Returns More than Requested Number of Rows While Getting Funds Remaining When Multiple Distributions Exist (Doc ID 2535322.1)

Last updated on MAY 08, 2020

Applies to:

Oracle Contract Lifecycle Management for Public Sector - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Requisition

ACTUAL BEHAVIOR
---------------

During the PDS Import Process, Contracts are failing with this error:
BSO Code: "java.lang.ClassCastException"

BCO Text: java.sql.SQLException cannot be cast to oracle.apps.fnd.framework.OAException

The document fails to create into the base tables, but seems to pass all validations.

FND Debug Log shows the following Exception:


## Detail 0 ##
java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at ""APPS.PO_UDA_IMPORT_PKG"", line 3587
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

 Steps to Replicate the issue :

------------------------------------------

1) Create an Award with multiple distributions with backing req
2) Approve the Award
3) Create Modification through PDS
4) Try to increase funds on line, and  PDS payload is failing

 

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
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.