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
Get Started with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

Error using Dynamic date

edited Dec 13, 2022 7:03AM in Taleo Enterprise 2 comments

Summary

Getting error when using Dynamic date to beginning of the year

Content

I am using the dynamic date filter to look for a hired date >= beginning of the year: TIMESTAMPADD(SQL_TSI_DAY, DAYOFYEAR(CURRENT_TIMESTAMP) * -(1) + 1, CURRENT_TIMESTAMP))

I am getting this error:

Error
  View Display Error
 
Error getting drill information: SELECT "Submission Dates"."Submission Completed Date" saw_0, "Submission Source"."Submission Source Type" saw_1, "Submission Source"."Submission Source (BL)" saw_2, "Submission Dates"."Hired Date" saw_3, "Candidate Identification"."State/Prov of Residence" saw_4, "Requisition Primary Location"."Location Level1 Code" saw_5, "Candidate Identification"."Candidate Identifier" saw_6, "Requisition Primary Location"."Location Level2 Name" saw_7, "Requisition Identification"."Req. Identifier" saw_8, "Candidate Identification"."Candidate Is Internal" saw_9, "Requisition Identification"."Title (BL)" saw_10, "Submission CSW Status - Current"."Current Status Name" saw_11, "Submission Source"."Submission Source Explanation" saw_12, "Requisition Flex Fields"."UDF20" saw_13, "Requisition Primary Location"."Location Level3 Name" saw_14, "Candidate Identification"."Zip Code of Residence" saw_15, "Candidate Identification"."City of Residence" saw_16, "Requisition Organization"."Organization Level4 Name" saw_17, "Requisition Organization"."Organization Level3
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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