Last updated on MARCH 08, 2017
Applies to:Oracle Treasury - Version 12.1.3 and later
Information in this document applies to any platform.
When submitting the Data Exchange-Market Data Transfer Process the following error occurs:
XTRMDTSF module: Data Exchange - Market Data Transfer
ORACLE error 1427 in FDPSTP
Cause: FDPSTP failed due to ORA-01427: single-row subquery returns more than one row
ORA-06512: at "APPS.XTR_MARKET_DATA_INTERFACE_P", line 467
ORA-06512: at "APPS.XTR_MARKET_DATA_INTERFACE_P", line 711
ORA-06512: at "APPS.XTR
Steps to Reproduce
1. Load legacy system rates in the XTR_MARKET_DATA_INTERFACE table using SQL Developer.
2. Go to Treasury responsibility.
3. (N) Other/Concurrent Requests/Submit Requests window.
4. Submit the Data Exchange-Market Data Transfer Process.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms