My Oracle Support Banner

FTP Process Status Missing From Summary Screen After Running Through Batch Due To "getProcessStatus() : ORA-01427: single-row subquery returns more than one row" Error (Doc ID 2894463.1)

Last updated on SEPTEMBER 19, 2022

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.1.0.0.0 to 8.1.0.0.0 [Release 8.1]
Information in this document applies to any platform.
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In FTP 8.1 environment, after run a FTP process via a batch with multiple tasks, the "Status" is missing from the FTP Process Summary Screen.

Error:
The following error ORA-01427 is output to ftpapp.log:

[05-08-22 06:28:58,432 GMT AM] [ERROR] [WEB] ERR FTPUtil ::getProcessStatus() : ORA-01427: single-row subquery returns more than one row

Steps:
The issue can be reproduced with the following steps:
1. Create a Batch of FTP Processes
2. Run the Batch
3. Go to Funds Transfer Pricing
4. Go to FTP Processing > Standard Process

The Status column is blank for the processes included in the batch.
 

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.