My Oracle Support Banner

SCRIPT() In FRT Unable To Validate Conditions Involving Values From Output Of Lower Sequence Fields (Doc ID 2764577.1)

Last updated on APRIL 07, 2021

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.9.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.9.0.0.0 version, ENV - Environment

ACTUAL BEHAVIOR
---------------
SCRIPT() in FRT unable to validate Conditions involving values from output of lower sequence fields.

The issue is while using SCRIPT() function in FRT that uploads raw transactions to the staging table. The SCRIPT() function is being used in order to compare the output from 2 different values and based on that derive the current field value. Even though the output values of the 2 source fields are printed properly in the logs, the SCRIPT() on the 3rd field is unable to use these values in the Condition block and hence resulting in wrong output values. It is observed that the SCRIPT() is able to use the value from the 2 source fields in the Output block.

Example: Below is a sample action of Formatting and Storing the incoming settled sate on to udf_dttm1 field.

Where the input date comes in yymmdd format. So, if it is a valid date we are concatenating 20 to output in the format yyyymmdd.
P_SETTLEDATEVALIDATE is the dummy field used for the above purpose, which stamps a '' value when it is an invalid date coming as input.
SETTLEMENT DATE is the actual date field which is stored in the udf_dttm1 field. If the output of P_SETTLEDATEVALIDATE is a valid date, then the above concatenated date is stored in yyyy-mm-dd with the help of a Business Service “CM_GETDATE” which does nothing but the conversion of date format.

If the input is '000000' or '' or ' '. For the above SCRIPT function the FRT returns the below values:
P_SETTLEDATEVALIDATE = ''
SETTLEMENT DATE = 000000
Here the SETTLEMENT DATE value should have been '' instead of 000000.

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
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.