R12: Projects EBS Extensions Query ORA-01427 Error
(Doc ID 2252601.1)
Last updated on FEBRUARY 12, 2019
Applies to:
Oracle Project Planning and Control - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Projects EBS Extensions Query Error
This problem is specific to the Endeca EBS Extensions, V5.
Projects Extensions seems to fail within the LoadDataFull.grf within the 'Expenditure Items' component with the following error:
ERROR
-----------------------
ERROR 135216 [WatchDog] Node EXPENDITURE_ITEMS error details:
org.jetel.exception.JetelException: SQLException when reading resultSet: ORA-01427: single-row subquery returns more than one row
caused by: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
After examining the SQL within the component, it seems that the component is failing at the following portion of code:
DECODE (
TR.ACCT_SOURCE_CODE,
'AP_INV', EI.document_line_number,
'RCV', (SELECT LINE_NUM
FROM RCV_SHIPMENT_LINES
WHERE PO_HEADER_ID = EI.DOCUMENT_HEADER_ID
AND PO_DISTRIBUTION_ID = EI.DOCUMENT_LINE_NUMBER),
NULL)
document_line_number
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 |