My Oracle Support Banner

Break Identification Transform Data Batch Fails With No Messages in FSI_MESSAGE_LOG (Doc ID 2816001.1)

Last updated on OCTOBER 22, 2021

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.5 and later
Oracle 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.