My Oracle Support Banner

Settlement Invoice Generation Process Failed With Single-row Subquery Returns More Than One Row (Doc ID 2439991.1)

Last updated on FEBRUARY 01, 2019

Applies to:

PeopleSoft Enterprise SCM Services Procurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When enabling the workflow for the invoice and selecting the generate and sumit check box on the batch invoice process page, and running the invoice generation process(SPF_INVGEN), process will abend with error:
 Process 6137265 ABENDED at Step SPF_INVGEN.EMAIL_WL.Step01 (Action SQL) -- RC = 1427
SQL Error: ORA-01427: single-row subquery returns more than one row

ERROR:
Process 6137265 ABENDED at Step SPF_INVGEN.EMAIL_WL.Step01 (Action SQL) -- RC = 1427
SQL Error: ORA-01427: single-row subquery returns more than one row

The issue can be reproduced at will with the following steps:
1. Make sure that workflow is enabled for the invoice.
2. Run the batch invoice process (SPF_INVGEN_) process and make sure that the Generate and submit check box is selected
3. Run the SPF_INVGEN process to generate invoices.
4. Process will fail with the error message SQL Error: ORA-01427: single-row subquery returns more than one row




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