Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Replacing a text from a result of Case When — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Replacing a text from a result of Case When

Received Response
44
Views
2
Comments
edited Jan 27, 2016 5:25PM in Reporting and Analytics Taleo Enterprise 2 comments

Content

I am converting a formula from BO to OBI but unfortunately I am encountering an error. Below is the BO formula:

Replace(Replace(Replace(If(Match([Event];"Status changed to*") And ([Application Tracking CSW Status])<>"Rejected") Or Match([Event];"Revert*") Then ("Event date: "+[Application Tracking Event or Transaction Date]) ElseIf([Event]="Correspondence sent") Then [Application Tracking Correspondence Template Used (7.5 Legacy Data)] ElseIf(Match([Event];"Service*")) Then Replace(Replace([Application Tracking Details];"{service}";[Application Tracking Passport Services Name]);"{provider}"; [Application Tracking Passport Services Provider]) ElseIf([Application Current CSW Step]<>"New" And [Application Current CSW Status]="Rejected") Or IsNull([Application Tracking Details]) Then [Application Tracking Motives] Else [Application Tracking Details];"Question: ";("Question: "+[Application Tracking Q&A Question (Before Update)]));"{1}";"_");"{SEPARATOR}";"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!