Expenses

Get Involved. Join the Conversation.

Topic

    William McLarty
    Is it possible to return values in a DFF that pertain to the...Answered
    Topic posted July 23, 2019 by William McLartySilver Medal: 2,000+ Points, tagged Expenses, Public Sector 
    58 Views, 3 Comments
    Title:
    Is it possible to return values in a DFF that pertain to the user selecting
    Summary:
    Is it possible to return values in a DFF that pertain to the user selecting
    Content:

    We want to create a DFF on the Cash Advance screen that contains the value of the Travel Authorization (this should be for the Idea Lab as well).  Ideally the values in the drop list would be travel authorizations for that specific user (rather than the entire universe of values).  This actually exists on the Expense header screen as a delivered field.  So the question is - is this possible to do?  And if so, how?

    Thanks,

    Bill

    Best Comment

    Marcus Comins

    Hi Bill

    I believe the following will return the logged in user in sql

    select  FND_GLOBAL.USER_GUID, FND_GLOBAL.USER_NAME from dual

    So you can use this in a table-validated value set query to return TAs related to the logged in user. 

    Bear in mind this wouldn't work where you may be entering an Advance for someone else as it would still only return your own.

    Thanks

    Marcus

    Comment

     

    • Marcus Comins

      Hi Bill

      I believe the following will return the logged in user in sql

      select  FND_GLOBAL.USER_GUID, FND_GLOBAL.USER_NAME from dual

      So you can use this in a table-validated value set query to return TAs related to the logged in user. 

      Bear in mind this wouldn't work where you may be entering an Advance for someone else as it would still only return your own.

      Thanks

      Marcus

    • William McLarty

      Hi Marcus,

      This worked beautifully (with the exception of delegates as noted).  Thank you for the suggestion...