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
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

TCC complex export projection

edited Dec 13, 2022 6:42AM in Taleo Enterprise 1 comment

Summary

Complex projection to output system date as a date stamp on output file

Content

Hello - I'm trying to write a complex projection to output the system date as a date stamp on the output file but receive the following error in TCC: ORA-00936: missing expression.  The complex projection i'm using is below.  Any suggestions as to how to export todays system date as a formatted date field?

 

<quer:projection alias="Date" projectedValueType="string" xmlns:quer="http://www.taleo.com/ws/integration/query">
  <quer:customFunction name="TO_CHAR">
      <quer:date type="now"/>
    <quer:string>yyyy-MM-dd</quer:string>
  </quer:customFunction>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!