My Oracle Support Banner

OZF-TM Transfer To General Ledger Concurrent Program Error: "ORA-01427 Single-Row Subquery Returns More Than One Row" (Doc ID 979002.1)

Last updated on JANUARY 11, 2024

Applies to:

Oracle Trade Management - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
OZF_GL_TRANSFER_PVT


Symptoms

The OZF-TM: Transfer to General Ledger concurrent program completes in error.

Steps to Reproduce:

Error

The Request Log includes the following Errors: 
ORACLE error 1427 in FDPSTP 
Cause: FDPSTP failed due to ORA-01427: single-row subquery returns more than 
one row 
ORA-06512: at "APPS.OZF_GL_TRANSFER_PVT", line 349 
ORA-06512: at line 1 
Error: ORA-01427: single-row subquery returns more than one row 
Error: -1427ORA-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.