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
Skip to content
  • 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

    oracle.xdo.dataengine.datasource.plugin.DataAccessException: java.net.SocketTimeoutException: Read t

    edited Mar 5, 2021 10:52PM in Reporting and Analytics for HCM 2 comments

    Content

    Hi Experts,

    I have Anniversary BI Report using OTBI analysis. Which has following filter criteria 

    CONCAT(CONCAT (CAST(MONTHNAME("Workforce Management - Person Real Time"."Person"."Person Start Date") AS CHAR)   ,'-'), 
    cast(DAYOFMONTH("Workforce Management - Person Real Time"."Person"."Person Start Date")AS cHAR))  
    = 
    CONCAT(CONCAT(CAST(MONTHNAME(TIMESTAMPADD(SQL_TSI_DAY, +1, TIMESTAMPADD(SQL_TSI_YEAR, -1, 
      CAST(TIMESTAMPADD(SQL_TSI_HOUR, cast(substring('@{session.timeZone}' from 5 for 3) as int), CURRENT_TIMESTAMP) as DATE))) )AS CHAR),'-'),
    CAST(DAYOFMONTH(TIMESTAMPADD(SQL_TSI_DAY, +1, TIMESTAMPADD(SQL_TSI_YEAR, -1, CAST(TIMESTAMPADD(SQL_TSI_HOUR, cast(substring('@{session.timeZone}' from 5 for 3) as int), CURRENT_TIMESTAMP) as DATE))) )AS CHAR))
    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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