Projects Endeca: PRJ-PJT Incremental Load Fails (Doc ID 2218589.1)

Last updated on JANUARY 29, 2017

Applies to:

Oracle Project Planning and Control - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

When attempting to run Incremental Load
the following error occurs.

2016-11-24 10:24:51,297 ERROR 255247 [WatchDog_255247] Component [Expenditure Items:EXPENDITURE_ITEMS] finished with status ERROR.
ORA-01427: single-row subquery returns more than one row
2016-11-24 10:24:51,298 ERROR 255247 [WatchDog_255247] Error details:
org.jetel.exception.JetelRuntimeException: Component [Expenditure Items:EXPENDITURE_ITEMS] finished with status ERROR.
at org.jetel.graph.Node.createNodeException(Node.java:543)
at org.jetel.graph.Node.run(Node.java:522)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:722)
Caused by: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row


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