0 Replies Latest reply on Sep 12, 2017 1:23 PM by 3507467

    Oracle Project Resource Issue

    3507467

      Hi

       

      This may not be the best place to post this so please advise where I should put it if I need to move it

       

      Having an issue with Projects in Fusion.  To cut a long story short - when you go into the Fusion application and look at the resources associated to a project, the screen shows 7 people.

      However when we run any reports at all off the data, there is an 8th person coming out who we don't think should be associated to it but is showing up when joining on project party id.

       

      So for example, the screen in Fusion would show 7 resources allocated to this project but the query below will show 8:

      SELECT PJAB.PROJECT_ID,

        HP.PARTY_ID,

        HP.PARTY_NAME CONTACT_NAME,

        HP.EMAIL_ADDRESS,

        PPRTT.PROJECT_ROLE_NAME,

      pjab.segment1,

      PJP.PROJECT_ROLE_ID

      FROM PJF_PROJECTS_ALL_B PJAB,

        PJF_PROJECT_PARTIES PJP,

        HZ_PARTIES HP,

        PJF_PROJ_ROLE_TYPES_TL PPRTT

      WHERE PJAB.PROJECT_ID      = PJP.PROJECT_ID

      AND PJP.RESOURCE_SOURCE_ID = HP.PARTY_ID

      AND PPRTT.PROJECT_ROLE_ID  = PJP.PROJECT_ROLE_ID

      AND PPRTT.LANGUAGE         = 'US'

      AND TRUNC(SYSDATE) BETWEEN NVL(PJP.START_DATE_ACTIVE, TRUNC(SYSDATE)) AND NVL(PJP.END_DATE_ACTIVE, TRUNC(SYSDATE))

      AND PPRTT.PROJECT_ROLE_NAME <> 'Customer Organization'

      AND pjab.project_id = '300000003431942'

      AND pjab.segment1 = '10303'

      ORDER BY PROJECT_ID

       

      Any thoughts?

       

      Thanks