I am able to query Fnd_Flex_Values_Vl to find the possible segment values for each segment. Now we have a use case, in EBS, there are two operating units A and B. They both use the same independent flex value set but can display different list of segment values based on the operating unit. Wondering how do I filter the segment values based on given operating unit?
there is no direct link between the Values updated in the Value sets and the Operating units, hence you cannot write a query for that.
However they are linked through the transactions that are recorded in subledgers, therefore for a subledger you can take up the transaction list and filter out by Operating units and see which values are used by which operating unit ...
If you can elaborate more on the requirement/objective, we can think of other possibilities..
We display the accounting flex for each segment in an ADF application we create. We query Fnd_Flex_Values_Vl to find the possible segment values for each segment. The customer has a use case, in EBS, there are two operating units A and B. Both A and B use the same independent flex value set for a key flex field but they display different segment values based on the given operating unit. We need to replicate this behavior in our form to be able to filter the segment values based on the operating unit.
We set the MOAC policy context to a single org so it will only show data from the specified org id. But for segment lookup, it still returns the same list of segment values for both operating units.