5 Replies Latest reply: Mar 15, 2013 1:37 AM by Harish Nunna RSS

    PA_WBS_V

    jmft2012
      How to use the PA views-- PA_WBS_V , PA_TASKS_WBS_V?
      the both return no records. They should have tons records because they are based on PA_TASKS table.
      select count(*) from pa_wbs_b
      count(*)
      ------
      0

      what do I miss here?
        • 1. Re: PA_WBS_V
          Hussein Sawwan-Oracle
          Hi,

          What is the application release?

          Set the application context as per the following documents and check then.

          Note: 209185.1 - Setting the Applications Context (FND_GLOBAL.APPS_INITIALIZE)
          Note: 437119.1 - How to set the Organization Context in R12?
          Note: 420787.1 - Oracle Applications Multiple Organizations Access Control for Custom Code
          Note: 415860.1 - How to view org-specific data in a MOAC environment

          Regards,
          Hussein
          • 2. Re: PA_WBS_V
            jmft2012
            Hi , followed the notes and still get no records returning.

            get PA's application id:

            SELECT substr(APPLICATION_SHORT_NAME,1,8) product, p.application_id ---,
            ---substr(PRODUCT_VERSION,1,14) version,
            --- substr(PATCH_LEVEL,1,11) patch_level
            FROM fnd_application a, fnd_product_installations p
            WHERE a.application_id = p.application_id
            ORDER BY application_short_name
            /

            PRODUCT APPLICATION_ID
            -------- --------------
            PA 275

            Get the resp_id:
            SELECT responsibility_id
            FROM FND_RESPONSIBILITY_VL
            WHERE responsibility_name LIKE 'Project Costing Super User';

            ESPONSIBILITY_ID
            ----------------
            20433

            get the user_id
            select user_id
            from fnd_user
            where user_name = 'SYSADMIN';
            user_id
            -------
            0

            the org_id=81
            apps@sp1> BEGIN
            2 MO_GLOBAL.SET_POLICY_CONTEXT('S', 81);
            3 END;
            4 /
            PL/SQL procedure successfully completed.

            apps@sp1> begin
            2 FND_GLOBAL.APPS_INITIALIZE(0,20433,275);
            3 end;
            4 /

            PL/SQL procedure successfully completed.

            apps@sp1> select count(*) from pa_wbs_v;

            COUNT(*)
            ---------
            0
            • 3. Re: PA_WBS_V
              Hussein Sawwan-Oracle
              Hi,

              What is the application release?

              Regards,
              Hussein
              • 4. Re: PA_WBS_V
                jmft2012
                r12
                • 5. Re: PA_WBS_V
                  Harish Nunna
                  Hi,

                  I am also facing the same issue. Even after setting the Org Context/ Multi-Org setups, I couldn't view the data from PA_TASKS_WBS_V and PA_WBS_V views.
                  Could anyone help me to resolve this? I am currently using R12.1.3 version.

                  Thanks,
                  Harish Nunna

                  Edited by: Harish Nunna on Mar 14, 2013 11:37 PM