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 MARCH 15, 2022
Applies to:
Oracle Contract Lifecycle Management for Public Sector - Version 12.2 and laterInformation 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 |