ORA-01427 ERROR LOADING DATA TO F_SHIPMENT_INVOICE_BILL_DETAIL AND OTHER TABLES (Doc ID 1570009.1)

Last updated on JULY 29, 2013

Applies to:

Oracle Fusion Transportation Intelligence - Version 6.2.7 and later
Information in this document applies to any platform.

Symptoms

On FTI 6.2.7:

Below error occurs on ETL run via ODI to refresh tables
F_SHIPMENT_INVOICE_BILL_DETAIL(bills) and
F_SHIPMENT_INVOICE_BILL_LINE_D(bills)

1427 : 21000 : java.sql.SQLException: ORA-01427: single-row subquery returns
more than one row java.sql.SQLException: ORA-01427: single-row subquery
returns more than one row at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316) at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282) at
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639) at
oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedSt

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