My Oracle Support Banner

ELA: Data Conversion AE - DCRE28923993 Fails With Error: Single-row Subquery Returns More Than One Row (Doc ID 2605892.1)

Last updated on OCTOBER 31, 2019

Applies to:

PeopleSoft Enterprise FIN Lease Administration - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms


This is a conversion program that is run by Change Assistant. It fails with the following error.

ERROR
----------
Message Set Number: 200
 Message Number: 0
 Message Reason: File: e:\pt857p06b_1903270501-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 42 Return: 1427 - ORA-01427: single-row subquery returns more than one row
Failed SQL stmt: UPDATE PS_RE_LSA_PPTY SET CF_SEQNO = NVL((SELECT CF_SEQNO FROM PS_COST COST_BAL, PS_BU_AM_BOOK_VW BK WHERE COST_BAL.BUSINESS_UNIT = PS_RE_LSA_PPTY.BUSINESS_UNIT_AM AND COST_BAL.ASSET_ID = PS_RE_LSA_PPTY.ASSET_ID AND COST_BAL.BOOK = BK.LEASE_BOOK AND BK.BUSINESS_UNIT = PS_RE_LSA_PPTY.BUSINESS_ (200,0)
Process 6337715 ABENDED at Step DCRE28923993.MAIN.Step02 (SQL) -- RC = 1427 (108,524)
 Message Set Number: 108
 Message Number: 524
 Message Reason: Process 6337715 ABENDED at Step DCRE28923993.MAIN.Step02 (SQL) -- RC = 1427 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

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.