TCC

TCC – Reset the Collection

User Types and Groups are collections in Taleo. If you need to clear them you can drag the parent entity over to the columns of an import and then you can see the reset the collection is available and checked.  This is a Boolean for the import file.
read more »

TCC

TCC – ISO Locale’s

It always drove me crazy trying to figure out what the ISO codes were for locale, then the light came on and I realized I could export it from the language entity…

read more »

TCC

TCC – RowNum

<quer:projection alias="TestRowNum" xmlns:quer="http://www.taleo.com/ws/integration/query">
  <quer:customValue>
    <quer:expression>rowNum</quer:expression>
  </quer:customValue>
</quer:projection>
TCC

TCC – SSO Errors

In the URL when testing SSO, if something goes wrong you’ll get an errorReason=X, the reason codes are listed here:
read more »

TCC

TCC – Using CDATA for Specifying HTML

A lot of times you need to make an update on a description or a text field. Let’s say you want to concatenate a new statement at the bottom for the requisition or template that specifies EEO compliance.

Now we all know what fun it is to try to manually do anything with those fields so I just say don’t do it.

Instead use Taleo GUI to craft what you are looking for in the filed you are looking to place it in within the staging zone (i.e. if you want change/add to JobInformation,DescriptionExternalHTML then create your content in the JobInformation,DescriptionExternalHTML field, although this isn’t needed it’s best practice down the road for the import, just trust me on this one)

So when you get your export it’s going to be the Taleo HTML that we all know and love, but how in the world are you supposed to get it into an export to update everything?

This is where our friend CDATA comes in. CDATA stands for Character Data and it means that the data in between these strings includes data that could be interpreted as XML markup, but should not be.

<quer:string>
<![CDATA[Taleo_HTML]]>
</quer:string>

You may also need to set the projectedValueType to string.

TCC

SSO Bypass URL

When testing before the standard login is shut off you may need to bypass which is such:

https://zone.taleo.net/smartorg/iam/accessmanagement/login.jsf?redirectionURI=https%3A%2F%2Fzone.taleo.net%2Fsmartorg%2FTaleoHomePage.jss&TARGET=https%3A%2F%2Fzone.taleo.net%2Fsmartorg%2FTaleoHomePage.jss

TCC

TCC – SHA-2 Migration

Oracle has announced that they are ending support for SHA-1 and migrating all it’s products to be SHA-2 compliant. Today they have released the information needed in order to accomplish this.
TCC-TCB SHA-2_CustomerDocument_Final is the Oracle white paper on the migration. read more »

MSSQL

MSSQL – ROW_NUMBER

I had this come up when I was trying to insert the row number for the purpose of populating a SeqNo. This is what it looks like…

ROW_NUMBER() OVER (ORDER BY [Column Name]) as SeqNo

TCC

TCC – Reopen Vs. Reactivate Operations

A shout out to Kelly Amott for bringing this to resolution. I’ve always wondered what the difference between the the requisition reopen and reactivate operations and there’s not a bunch in the documentation that I’ve seen that would explain it. He got the answer from a case and was kind enough to share.

Update and FYI – To take the req off hold I was using the Requisition – reopen spec. Oracle advised that reopen is for cancelled reqs. The specification I needed to be using is the Requisition – reactivate.

TCC

TCC – Update Candidate EEO Questions

Occasionally I get the question if you can update candidate EEO information. The answer is yes but it’s tricky. The key is in Doc ID 1047686.1 which states:

To import Diversity Answers, a unique ID is necessary for both Question and PossibleAnswer. Unfortunately, the Code does not enforce uniqueness, so sometimes another field is needed to use in imports. The field Number is available for both PossibleAnswer and Question entities even if it isn’t presented in the feature pack. To use them, just drag another field from the entity and edit the Path to Number.

Run an export on Possible Answer and Question numbers in order to know what IDs to use in your imports.