We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Using INITCAP on a TCC export but fails when the field is blank or empty

Received Response
28
Views
1
Comments
edited Aug 4, 2011 11:29AM in Taleo Enterprise Integrations 1 comment

Content

Hello,

In an export file of new hires, we're using the custom function INITCAP on the new hire's name (first, mi, last) and address. It seems there's an issue with INITCAP on the middle initial if it's BLANK or EMPTY. When the configuration file is executed it fails during the soap stripping mode, this is error message; The following error occurred during the export: [itk:ExportQueryExecutionError = ORA-00936: missing expression ]

How can I 1st check if the middle initial is blank/empty and if it is how to skip the initcap function? Also the initial is a UDF.

<quer:projection alias="Initial" xmlns:quer="

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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