OFSAAI View Log Does not Display Complete Records for Data Transformation Component Tasks in 7.3.x

(Doc ID 1615781.1)

Last updated on MARCH 05, 2018

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 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, 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