R12: Projects EBS Extensions Query ORA-01427 Error

(Doc ID 2252601.1)

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.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms