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
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

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

    Facing SQl time out Error for Performance Document report

    edited Jul 19, 2021 10:54AM in Performance Management 1 comment

    Content

    We are facing SQL time out error when scheduling the performance document report for 2021 mid year.

    Report is not failing when run for few users and also not failing for 2020 or 2019 Performance document filter.

    We are trying to fetch questionarie responses(answer texts) as part of this report, when this particular blocks are commented, report is running successfully.

    Below is the blocks we are using to fetch answer_texts

     ,(SELECT to_char(SUBSTR(regexp_replace(NVL(qr.answer_text, qa.long_text), '<[^>]+>|\&(nbsp;)|(amp;)', ''),1,2000))
        FROM hra_evaluations he,
            hra_eval_participants ep,
            hrq_qstnr_participants qp,
    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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