This discussion is archived
5 Replies Latest reply: Mar 14, 2013 11:37 PM by Harish Nunna RSS

PA_WBS_V

jmft2012 Explorer
Currently Being Moderated
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 Employee ACE
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    Hi,

    What is the application release?

    Regards,
    Hussein
  • 4. Re: PA_WBS_V
    jmft2012 Explorer
    Currently Being Moderated
    r12
  • 5. Re: PA_WBS_V
    Harish Nunna Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points