For more information, please refer to this announcement explaining best practices for getting answers to questions.
How To Group in TCC Export
Content
I have a requisition export where I am exporting ContestNumber and four complex projection fields to determine if the posting is college hire, professional, hourly and international. It was working as it should and only returned one requisition with the values for each complex projection. I added some additional JobInformation fields (i.e., JobInformation,DescriptionExternalHTML, JobInformation,ExternalQualificationHTML, etc.). My export then returned an error “ORA-00932: inconsistent datatypes: expected - got CLOB”. Taleo support indicated that I had to uncheck the ‘Prevent Duplicates” on the General Tab. When I do that, I receive duplicates; up to 4 for each complex projection. Could someone explain if I can group an export by ContestNumber and complex projection fields and how I could do it?