View Landed Cost On LCM Shipments Error: JBO-27122 : SQL error during statement preparation - java.sql.SQLException: ORA-01427: single-row subquery returns more than one row (Doc ID 1916449.1)

Last updated on APRIL 13, 2017

Applies to:

Oracle Landed Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.
*** Checked on Relevance on 13/APR/2017 ****

Symptoms

View landed cost on LCM shipments

ERROR
-----------------------


ERROR DETAILS

-----------------

Error page. You have encountered an unexpected error.
.
Exception Details.

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM (SELECT cfaol.ship_header_id,
      cfaol.ship_line_group_id,
      cfaol.ship_line_id,
      cfaol.ship_line_num,
      cfaol.ship_line_type_id,
      cfaol.ship_line_src_type_code,
      cfaol.ship_line_source_id,

(...)

## Detail 0 ##
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

(...)

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