This discussion is archived
2 Replies Latest reply: Dec 4, 2012 7:36 AM by user11179792 RSS

Query to filter segment values based on operating unit

user11179792 Newbie
Currently Being Moderated
Hi Gurus,

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?

Edited by: user11179792 on Nov 30, 2012 9:59 AM
  • 1. Re: Query to filter segment values based on operating unit
    Ivruksha Pro
    Currently Being Moderated
    Hi,

    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..

    Regards,
    Ivruksha
  • 2. Re: Query to filter segment values based on operating unit
    user11179792 Newbie
    Currently Being Moderated
    Hi Ivruksha,

    Thank you for your reply! Here are more details:

    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.

    - Beibei

    Edited by: user11179792 on Dec 4, 2012 7:32 AM

    Edited by: user11179792 on Dec 4, 2012 7:34 AM

    Edited by: user11179792 on Dec 4, 2012 7:36 AM

Legend

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