Break Identification Transform Data Batch Fails With No Messages in FSI_MESSAGE_LOG
(Doc ID 2816001.1)
Last updated on MARCH 16, 2023
Applies to:
Oracle Financial Services Funds Transfer Pricing - Version 8.0.5 and laterOracle Financial Services Analytical Applications Infrastructure - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Symptoms
On FTP 8.0.5 version, Break Identification process run via Batch Execution fails with below error.
Error:
RunProc_INFODOM_INF_BREAK_FUNDING_CHARGES_ALL_TEST_20210630_14_Task5.log:
Log Message here 1: Mon 18 Oct 2021 11:20:40 AM CDT||INFO||Parameters : fn_break_detection,'INFODOM_INF_BREAK_FUNDING_CHARGES_ALL_TEST_20210630_14','20210630','205107','<USERNAME>'
Log Message here 1: Mon 18 Oct 2021 11:20:40 AM CDT||INFO||Statement to execute : BEGIN :D := fn_break_detection('INFODOM_INF_BREAK_FUNDING_CHARGES_ALL_TEST_20210630_14','20210630','205107','<USERNAME>'); END;
Log Message here 1: Mon 18 Oct 2021 11:20:40 AM CDT||INFO||Fetching the return status.
Log Message here 1: Mon 18 Oct 2021 11:20:40 AM CDT||INFO||Return value From the Stored Procedure : 0
Log Message here 1: Mon 18 Oct 2021 11:20:40 AM CDT||SEVERE||Error code returned : -158639429
Log Message here 1: Mon 18 Oct 2021 11:20:40 AM CDT||INFO||execPackage : return val : 0
Log Message here 1: Mon 18 Oct 2021 11:20:40 AM CDT||INFO||After Calling execProc
Log Message here 1: Mon 18 Oct 2021 11:20:40 AM CDT||SEVERE||Stored procedure execution failed
Steps:
1. Run Break Identification via Batch Execution using Transform Data component and it fails.
2. Run the same Break Identification process via FTP Processing > Break Identification Process and it is successful.
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 |