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

    Performance Document Query Issue

    edited May 5, 2016 11:46AM in Reporting and Analytics for HCM 1 comment

    Content

    Hi All,

     

    As per the attached screen shot 2150 workers processed under mentioned performance document. When I linked BIP Data base tables to fetch the exact data getting few records only.

     

    Below are the tables I am using to fetch the data,

     

    SELECT

    count(EvaluationEO.worker_id) cnt

    from HRA_TMPL_PERIODS_VL htp

    ,HRA_TMPL_DEFNS_B  htd

    ,HRA_DOC_TYPES_TL hdt

    ,HRA_EVALUATIONS EvaluationEO

    where 1=1

    and htp.CUSTOMARY_NAME='FY2016 Nursing Demographic Questionnaire'

    and htp.TEMPLATE_DEFN_ID=htd.TEMPLATE_DEFN_ID

    and hdt.DOC_TYPE_ID=htd.DOC_TYPE_ID

    and htd.TEMPLATE_DEFN_ID = EvaluationEO.TEMPLATE_DEFN_ID

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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