What is the Purpose of the Default Value Defined in a Post Load Transformation Rule in OFSAA 7.2? (Doc ID 1302449.1)

Last updated on AUGUST 01, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version: 7.2.5 and later   [Release: 7 and later ]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.2

Goal

What is the default value in a post load transformation rule used for?

1. Create a new post load transformation rule as a stored procedure
2. Define a custom parameter and specify a default value (Batch ID and MISdate are standard mandatory parameters, define a third custom parameter)
3. Define a batch task as transformation and choose the transformation created in step 1
4. Do not define parameters

Expected behavior is that the stored procedure is called with the default values specified at Step 2. However, it appears that it is called without the custom parameter unless the value for the parameter is not specified in task parameters.

What is the use of defining default values for parameters when defining a post transformation rule?

Solution

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