1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Display Responsibility Name in Report Output

Discussion in 'Oracle Apps Technical' started by jagadekara, Jun 11, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi All,

    I have a requirement to display the responsibility name in my report output.

    I have a report which is attached to some request groups. I am able to run the report from 2 responsibilities.

    Ex: XX Resp1
    XX Resp2

    If I run the report from XX Resp1 then I need to display XX Resp1 in report at header level.

    If I run the report from XX Resp2 then I need to display XX Resp2 in report at header level.

    So How can I achieve this?
     
  2. rajenb

    rajenb Forum Expert

    Messages:
    361
    Likes Received:
    114
    Trophy Points:
    655
    Location:
    Mauritius
    Hi,

    You can either use "fnd_global.resp_id"

    OR get responsibility_id from fnd_concurrent_requests table

    and get the responsibility from:

    Code (SQL):
    SELECT responsibility_name FROM fnd_responsibility_tl
    WHERE responsibility_id=fnd_global.resp_id ...
     
    jagadekara likes this.
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Thanks Rajen,

    I will let you know, once I done this...
     
  4. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    I done this through

    FND_PROFILE.VALUE('RESP_NAME')