Expression Not Allowing To Compare Varchar Value In If Condition
(Doc ID 2928860.1)
Last updated on FEBRUARY 22, 2023
Applies to:
Oracle Financial Services Profitability Management - Version 8.1.0.0.0 and laterOracle Financial Services Analytical Applications Infrastructure - Version 8.1.0.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Goal
User would like to have the ability to create an Expression with Constant Value using Alphanumeric field.
For example:
User would like to create an expression on Mortgages table for Reconciliation Plug Indicator (VARCHAR field) as below:
If (
Mortgages.Reconciliation Plug Indicator
= Y
In add constant its not allowing to enter any value other than Numeric, thus Y is not allowed.
Solution
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
| Goal |
| Solution |
| References |