Last updated on APRIL 06, 2017
Applies to:Oracle Project Planning and Control - Version 12.1.3 and later
Information in this document applies to any platform.
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 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:
'RCV', (SELECT LINE_NUM
WHERE PO_HEADER_ID = EI.DOCUMENT_HEADER_ID
AND PO_DISTRIBUTION_ID = EI.DOCUMENT_LINE_NUMBER),
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms