My Oracle Support Banner

Hierarchy Flattening Process (Batch_HierTransformation) is Not Failing on Errors (Doc ID 2570994.1)

Last updated on AUGUST 12, 2020

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.7 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Oracle Financial Services Profitability Management - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On 8.0.7 version, Data Transformation Batch_HierTransformation for Hierarchy flattening process is not failing on Errors.

Error
FSI_MESSAGE_LOG:
Message_Cd=44309
<Batch Name>_1 Error while executing hierarchy Query


Expected Behavior
Expect to see failure in the Batch Monitor User Interface when hierarchy transformation batch failed.

Steps to Replicate:
1. Run Hierarchy Flattening Transformation that loads to table 'REV_HIER_FLATTENED'
2. The process ran in a batch with several tasks.
3. The Task for Batch Transformation is not failing per the Batch Monitor even though FSI_MESSAGE_LOG showing Error and DT log Executable returned : 0 ---> failure

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.