My Oracle Support Banner

T2T Issue Working With Tilda (~) Sign (Doc ID 2903273.1)

Last updated on JUNE 27, 2023

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.1.1 and later
Information in this document applies to any platform.

Symptoms

On Ofsaa 8.1.1.1,

After editing the T2T, the function COALESCE(stg_pms_prem_transaction_a.v_stat_brkdwn_code,'~') defined in the ANSI JOIN condition changes it to COALESCE(stg_pms_prem_transaction_a.v_stat_brkdwn_code,''~)

Steps to reproduce:

1. Go to data mapping section and define a T2T.
2. Give the '~' symbol in the COALESCE function in the ANSI JOIN section.
3. Save it and after that edit that t2t.
4. Try to edit that ANSI JOIN condition.

 

Expected Behavior:

The '~' symbol in the COALESCE function in the ANSI JOIN section should be in the single quotation marks(').

 

Actual Behavior:

The '~' symbol in the COALESCE function in the ANSI JOIN section is coming out from single quotation marks(').

Changes

 N/A

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.