OBIA 11g ODI-1228: Task PLP_SalesInvoiceLinesAggregate_Load.W_SALES_INVOICE_LINE_A (Integration) Fails (Doc ID 1933212.1)

Last updated on JANUARY 28, 2015

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Goal

Single-row sub-query returns more than one row for PLP_SalesInvoiceLinesAggregate_Load.W_SALES_INVOICE_LINE_A

Getting the following error during load:-

ODI-1228: Task PLP_SalesInvoiceLinesAggregate_Load.W_SALES_INVOICE_LINE_A (Integration) fails on the target ORACLE connection
Caused By: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

Single-row sub-query returns more than one row for PLP_SalesInvoiceLinesAggregate_Load.W_SALES_INVOICE_LINE_A

 This has been identified as <BUG 19338391> ODI PLP_SalesInvoiceLinesAggregate_Load, single-row subquery returns >1 row

Solution

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