OFSAAI View Log Does not Display Complete Records for Data Transformation Component Tasks in 7.3.x
Last updated on MARCH 05, 2018
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 18.104.22.168.0 to 8.0.0 [Release 7 to 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
On OFSAAI 22.214.171.124.0, when checking the View Log for batches executed, there appears to be an issue for Data Transformation tasks. There rows for all tasks in the batch are mixed together.
In the OFSAAI UI -> Operations -> View Log, the interface shows a record related to the Batch Run ID for each record in FSI_MESSAGE_LOG. Each line for a Batch Run Id gives the same log information for Data Transformation components.
There is no way to differentiate between the tasks of a batch. In other words, if you have two tasks in a batch and both are Data Transformation components, then the View Log screen will show the logs for both of them, together.
Steps to reproduce
The issue can be reproduced at will with the following steps:
1. Create a custom pl/sql procedure in the "Unified Metadata Manager" -> "Data Integrator Framework" -> "Post Load Transformation"
2. Create a batch and include the custom procedure as a task in the batch
3. Execute the batch.
4. Navigate to Operations -> View Log
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms