Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
TCC complex export projection — Cloud Customer Connect
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

TCC complex export projection

Received Response
edited Sep 13, 2017 3:21PM in Taleo Enterprise Integrations 1 comment


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


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="">
  <quer:customFunction name="TO_CHAR">
      <quer:date type="now"/>

Howdy, Stranger!

Log In

To view full details, sign in.


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