Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Using INITCAP on a TCC export but fails when the field is blank or empty — 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

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

Received Response
28
Views
1
Comments
edited Dec 13, 2022 6:39AM in Taleo Enterprise 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!