Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
TCC complex export projection
Summary
Complex projection to output system date as a date stamp on output fileContent
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>
0