PALDLC - ORA-01427: Single-row Subquery Returns More Than One Row For One Resource (Doc ID 2057395.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

In one OU, the PRC: Distribute Labor Costs completes in error. There is no output report and the log only provides the following generic error. On Metalink, users found patch 14550609 which appeared to be a direct match. However, it was confirmed that the patch was already applied to the instance, and, by process of elimination the issue is isolated to one resource.
 

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