My Oracle Support Banner

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 later
Information 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


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