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