My Oracle Support Banner

ORA-01427 Error Loading Data To F_SHIPMENT_INVOICE_BILL_DETAIL And Other Tables (Doc ID 1570009.1)

Last updated on JULY 20, 2024

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

Changes

 

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
Changes
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.