My Oracle Support Banner

TCC Sample: How to list multiple values of a record as a single row in the results (export mode equals csv-report) (Doc ID 2928181.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Taleo Platform Cloud Service - Connect - Version 22A and later
Oracle Taleo Recruiting Cloud Service - Version 22A and later
Information in this document applies to any platform.

Goal

A TCC export based on the csv-report export mode returns a row for every unique value of the record being exported.

For example, a Candidate profile has two studies/educations. A Candidate export based on the csv-report export mode that includes TalentUser,StudyLevels,Sequence and TalentUser,StudyLevels,Code would have a result like the following:

Number    TalentUser,StudyLevels,Sequence    TalentUser,StudyLevels,Code
10760      1                                                    HIGH_SCHOOL_DIPLOMA_GED_11_YEARS
10760      2                                                    TECHNICAL_DIPLOMA_12_YEARS

Above shows that there is a separate row for every value of the candidate's "Study Level".  This KM explains how complex projections can be used so that the different values of a record appear in separate columns of a single row.

 

NOTE: This KM article is for TCC exports based on the csv-report export mode.  Changing the export mode to csv-entity can also bring the result to a single row, but the different values are in the same column of the result.

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.