Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
TCC Union script?
Summary
Does anyone have a sample TCC script with a union?Content
I'm looking for a TCC script that performs a union on data from the User entity. Here's what I'm trying to do:
- String value ''Line Manager"
- projection: first name
- projection: last name
- projection: employee ID
UNION
- String value ''Dsg Manager"
- projection: first name
- projection: last name
- projection: employee code
where employee status=active
The xml I found in the TCC user guide hasn't helped much. I've tried adding xml as both a Complex Projection and a Subquery (Advanced Tab) but I keep getting 'Source is Not Valid' errors. Can anyone tell what I'm doing wrong? Can anyone tell me what's wrong with the xml below (added as a subquery)
Tagged:
0