How to Add a Flexfield Segment with Dynamic Values on BU (Business Unit) Basis to the Expense Lines

Summary

How to Add a Flexfield Segment with Dynamic Values on BU (Business Unit) Basis to the Expense Lines Entry Screen?

Content

Dear Experts,

We need to create a flexfield that only populates based on BU in the expense report line. In fact, we have defined a flexfield for this need and we can dynamically return values according to the BU information. We can detect the BU value via fnd_profile.value('DEFAULT_ORG_ID') and using BU value, we can make the flexfield value set show variable values on the basis of BU. 

However, in order to benefit from the fnd_profile.value('DEFAULT_ORG_ID')  functionality, a profile must be assigned to the person. We don't want to assign "Default Business Unit" profile to every person in the company. In addition, the use of this method causes incorrect values to be displayed in the flexfield value set in the scenario where the expense entry is delegated to different people, if the person entering the expense and the person who owns the expense have different business unit's.What we need is always to get the flexfield values according to the BU of the expense owner.