Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 282 Oracle Analytics and AI News
- 59 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
etext - Can elements in a CONCATENATION section be formatted using rpad and format_date functions
Summary
etext - Can elements in a CONCATENATION section be formatted using rpad and format_date functions
Content
I have a requirement where an etext template has to be developed for a benefit carrier.
Every time I use a function such as decode, rpad etc, concatenated elements does not work. I have a simple concatenation section as shown below:
Does anyone know if this is possible
<DEFINE | CAT_LTD |
<BASE | Benefit_Enrollment_Results_DG |
<ELEMENT> | If Plan=’LTD’ THEN RPAD('456', 10, 'x') End If |
<DELIMITER> | ' |
<END | CAT_LTD |
Answers
-
It should work. I have used RPAD in concatenation it worked for me...may I know where you are facing issue?
It will be helpful if you can upload sample e-text rtf and xml file
0 -
Thank you, not sure what happened last week, but I'm able to get it working now.
Thanks again.
0