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!

ID Flex Num

Discussion in 'Oracle HRMS & Payroll' started by rsamlal, Apr 22, 2013.

  1. rsamlal

    rsamlal Active Member

    Messages:
    7
    Likes Received:
    1
    Trophy Points:
    65
    Would like to know the meaning/use of ID Flex Num? Feedback's appreciated.
    regards
    Rishi Samlal
     
  2. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Are you referring to the Flexfield ID?
     
  3. ac.arijit

    ac.arijit Forum Advisor

    Messages:
    217
    Likes Received:
    22
    Trophy Points:
    280
    Location:
    Kolkata, India
    Hi Rishi,

    This topic should be posted under the Oracle Apps Technical Forums.
    Anyways, since u don't know the meaning/use of the matter, so we can consider... :)

    ID_FLEX_NUM is the database attribute for Flexfield structure number. To uniquely identify a Flexfield structure see the below sql code:
    Code (SQL):

    SELECT  fif.id_flex_name
           ,fif.id_flex_code
           ,fifs.id_flex_num
           ,fifs.id_flex_structure_code
           ,fifst.id_flex_structure_name
    FROM    applsys.fnd_id_flexs                fif
           ,applsys.fnd_id_flex_structures      fifs
           ,applsys.fnd_id_flex_structures_tl   fifst
    WHERE   fif.id_flex_code    =   'GL#'    
    AND     fifs.id_flex_code   =   fif.id_flex_code
    AND     fifst.id_flex_num   =   fifs.id_flex_num
    AND     fifst.id_flex_code  =   fifs.id_flex_code;